As stated in the Data Tables article, the Data Tables Configuration interface has three main functions: Data Table Creation, Data Table Definition, and Data Table Population. After navigating to the System Administration tab and clicking the Data Tables icon (), the user can complete one, or multiple, of these actions.
Data Table Creation
To create a new data table, the user can follow these steps:
- First, click the "Create New" button on the Data Table Configuration interface to trigger the appearance of the Create New interface.
- Then, fill out the necessary and desired fields. The Name and Year fields are required.
- Finally, click the “Create” button at the bottom of the interface after all desired fields have a value.
Data Table Definition
This functionality is covered by the three tabs in the interface.
Data Table Information Tab
The Data Table Information tab is used to edit the general information of the selected data table. Users can click into the desired fields to edit the information on this tab.
Required Items Tab
The Required Items tab is used to specify the route network to use when retrieving route data. To add a R&H or Non-R&H route source, the user must follow these steps:
-
Check the “Is R&H” checkbox for a R&H route source or uncheck the “Is R&H” checkbox for a Non-R&H route source. The fields will then change to support this selection.
-
Fill out the fields.
-
Click the “Save Changes” button at the bottom of the interface.
Attributes Tab
The Attributes tab can be used to define the attributes that can be found in the data table. This tab has its own internal tabs which accomplish this role: R&H Events, Non-R&H Events, Parent/Child Events, and Derived Events.
Add Data Item
In order to add a R&H, Non-R&H, Parent/Child, or Derived data item, users must follow the steps below.
- Click the “Add New Row” hyperlink to add a blank row. To copy an existing row, click the checkbox located to the left of the data item that will be copied. After selecting the desired rows, click the “Copy Selected Rows” link. All fields are populated except the Item Name column.
- Fill out the parameters. Edit a parameter by clicking into the desired cell. A picklist or textbox will appear relative to the column being edited.
- After adding the desired data items, click the “Save Changes” button at the bottom of the interface.
Delete Data Item
If a user wishes to delete a data item from any of the four tabs, they can follow these steps:
- Select the checkbox located in the first column of each desired item or use the checkbox in the table header to select all data items for deletion.
- After selecting the desired items, click the “Delete All Selected” hyperlink to permanently delete the items from the data table definition.
Data Table Population
Once the user has configured all the routes and desired Inventory data items, they can populate the data table by clicking the static “Populate Data Table” button. After the populate process is complete, the button will change to display the message, “Refresh Data Table.” At any point, the user can reload the data in the table with the latest updates by clicking the “Refresh Data Table” button.
This population process only adds data items that are complete (i.e., all required fields have values on the data table). The “Attributes Complete Message/Count” will appear below the Attributes tab's table to display the number of data items that are complete, and it will appear in the data table after the populate/refresh process.
Comments
0 comments
Please sign in to leave a comment.