Data table configurations are pre-defined sets of sheets with attribute mappings and retrieval methods. Retrieval methods allow you to define how the sheet or sheet column is populated with data. The standard data table configuration 1ST_CONFIG_2014 is delivered with the software; they have the Standard indicator set to Yes.
To define data table configurations, click Integration > XI20 Smart 3D > XI2030 Smart 3D Configuration and select the Data Table Configurations tab.
To create a new configuration, click Add 
above the tree, type the configuration name and a comment, and click Save 
. Click Refresh 
to display the new configuration in the tree.
The existing configurations are listed in the tree on the left. Click the + next to a configuration name to view all data tables assigned to the configuration.
Double-click a configuration name to view the details in the grid on the right.
To add data tables to a configuration, click the Add above the grid. A multi select list is available in the Data Table cell to add multiple data tables in a single step.
To view attributes and procedures attached to data tables, expand the configuration in the tree and double-click the data table.
To add attributes to a data table, click the Add above the Attributes grid. A multi select list is available in the Attribute Name cell to add multiple attributes in a single step. Expand a data table configuration
in the tree view, and double-click the data table. Click the Attached Procedures tab to attach procedures.
Click the Add above the grid.
Data Table Creation On-The-Fly
When you enter a nonexistent data table on this screen, a window opens for you to create the missing data table and then save it to the corresponding configuration.
The picture below displays the example of a missing Aspect Code(0) table.
When saving, the following window pops up to allow you to create it on the fly.
Copy and Paste Smart 3D Data Table Configurations
You can duplicate an existing data table configuration with its corresponding data tables, attributes, definition attributes, and attached procedures. Furthermore, you can copy (or cut) data table(s) with data from single or multiple data table configuration(s) to another data table configuration.
Right-click the data table configuration in the tree to open the shortcut menu.
You can multi select and copy data tables using Copy from the shortcut menu or CTRL+C. Then, assign the selected data tables to the destination configuration using Paste from the shortcut menu or CTRL+V. Alternatively, you can drop data tables onto the destination configuration.
When pasting the data tables, you are prompted with the review copy information. A window shows the missing data tables. If you selected the same data table from two different configurations, the conflict is shown in the Review Copy cell.
If you select a data table that is already in the destination configuration, the corresponding data table is not copied. This is shown in the Review Copy cell.
Possible retrieval methods for the sheets are:
|
CMS |
This retrieval method can be used to specify mappings between CMS (Component Management System) tables/attributes and Smart 3D Excel sheet attributes. These mappings are used by the Smart 3D export jobs during the export of idents that were created in Smart Reference Data Component Management System.
|
|||||||||||||||||||||
|
PART_RANGE |
This retrieval method supports the retrieval of range size parts like olets (for example, weldolets, endolets). This method is valid only for sheets defined with the category PART_DEFINITION. To configure the sheets to use PART_RANGE, proceed as follows: Select the PartClass sheet (category PART_DEFINITION) from the LOV in the Sheet field. For example, select the Endolet sheet. Select the retrieval method PART_RANGE from the drop-down list in the Retrieval Method field. The retrieval source is automatically set to PartClass in the Source field; it cannot be changed. The Null Column field has no significance and cannot be set if PART_RANGE is selected as the retrieval method. On the Attribute tab, select the retrieval method from the drop-down list in the Retrieval Method field and the retrieval source from the LOV in the Source field according to the list displayed below.
The ScheduleThickness attributes are not mandatory. |
|||||||||||||||||||||
|
TEMPLATE_COPY |
The sheet will be available on the Integration > Smart 3D > Smart 3D Configurations > Templates screen. The export job will create the corresponding sheet by simply copying the values from the template defined on Integration > Smart 3D > Smart 3D Configurations > Templates. If the sheet retrieval method is TEMPLATE_COPY, the sheet retrieval source will be ignored. The retrieval method settings on attribute level are not being used for sheets with retrieval method TEMPLATE_COPY. For example, almost all codelists with category CODE_LIST have the retrieval method TEMPLATE_COPY assigned. |
|||||||||||||||||||||
|
SHT_STND_METHOD |
A standard method is called, which has to be assigned in the Source field. If ‘Default’ is selected as source on the sheet level, the retrieval method is automatically defined by the ‘Sheet Category’. For example, the Source for almost all part class sheets with category PART_DEFINITION is ‘PartClass’. |
|||||||||||||||||||||
|
SHT_CUST_METHOD |
This retrieval method will call the CIP m_pck_sp3d_custom.sht_cust_method. By default, this procedure is empty, which means that you must program the logic to export the sheet yourself. |
|||||||||||||||||||||
|
TABLE_DETAILS |
If the retrieval method is TABLE_DETAILS, the sheet will be generated from the table groups and table details of commodity attribute tables. The table(s) to be considered are defined in the retrieval source. This method is valid only for sheets defined with category as CODE_LIST. |
The CMS retrieval method is not applicable to the generic sheets.
On clicking the Data Table Configuration tab, you can see the three tabs:Attributes, Definition Attributes, and Attached Procedures, which are explained in detail below: