Help: Editing instances of a single Data Table

Rows of this Data Table editor form correspond to data instances.

To edit instances using the form

Click:

• to display a form containing only this row, allowing it to be edited.
• to append a new row so you can add a new instance
• to unlock a row to allow updates to any value (except the key)
• to validate and save one instance
• to undo changes to the current instance
• to delete the instance.

Click  <<Data Tables   to return to the list of eligible class descriptions.

To edit instances of a Data Table using Microsoft Excel

1. Confirm that you have the appropriate access to add, delete, and update instances of the class.
2. For the WorkManager portal, click the Data Tables link in the Accelerators and Wizards area of the Dashboard workspace. The system lists classes to which you have editing access.
3. For the Developer portal, select View > Data Tables. The system lists classes to which you have editing access.
4. Identify one class to edit.
5. Click  Edit in Excel .
6. Process Commander sends the Data Table to your workstation as an Excel 2003 spreadsheet, with macros. If a security alert appears, select Enable Macros.
7. In Excel, each row corresponds to a data table entry. Use the Add, Update, Refresh, and Delete buttons to convey your changes to Process Commander server. Do not use the Save or Save As facilities. (When using Excel 2007 in 2003 compatibility mode, click the Excel Add-Ins tab to access the control buttons.)

Notes

If the or links do not appear, you lack appropriate security for these functions for that class. Ask your system architect to review or update the Modify Instances setting for the Access of Role to Object rule that controls access to the class you need to edit.

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

About the Data Table editor