About the Data Table editor

Use the Data Table editor to allow interactive entry and update of instances of simple data classes that contain only a few Single Value properties, such as those defined by the Data Table wizard.

To start the Data Table editor

To start the editor, select Application > Data Tables. A list of Data Tables appears.

Two standard examples are available, for the General-Product and General-ProductArea classes. (The General- top-level class is derived from the Data- base class.)

To edit an existing Data Table class within the portal

To edit the values in an existing eligible class:

1. Confirm that you have the appropriate access to add, delete, and update instances of the class.
2. Select Application > Data Tables. The system lists classes for which you have editing access.
3. Identify one class to edit. Click the Class Name link in that row to open an HTML form in a new window.

See Editing instances in a single Data Table.

Notes

1. If the or links do not appear, you lack appropriate access for these functions for that class. Review and update as needed the Modify Instances setting for the Access of Rule to Object rule that controls access to the class you need to edit.

2. Use of the Data Table editor requires that the workstation have the Excel Data Import Manager ActiveX control. The Excel file prExcelManagerTemplate.xls supports editing.

3. When editing a Data Table, a history instance is created for each Save operation. For example, if the class is named Data-ItemNums, the class History-Data-ItemNums has an instance containing the date, time, key, and Operator ID for each update. No standard facilities access these history instances, but you can view them with the Class Explorer and report on them with list view rules or summary view rules.

4. Editing in Excel is limited to data tables with no more than 32,767 rows. This is an Excel limitation.

About the Data Table wizard   Understanding ActiveX controls and Process Commander

Tools, accelerators, and wizards