Review Data Table Configurations tab - Intergraph Smart Reference Data - Version 10.2 - Help - Hexagon

Intergraph Smart Reference Data - Transition from Classic (10.2)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2
  1. Navigate to Integration > Smart 3D > Smart 3D Configuration.

  2. Click Data Table Configurations tab to view the delivered SRD – S3D Configuration, which contains details regarding the source of the data for the sheet, the columns, source of the columns, sort sequence, etc. of the data that will be included in the sheet during the export job.

    It is recommended that you copy the SDB_SHT_CONFIG and any other configurations you may need into a <Client>_SHT_CONFIG. That way if you have a need to make changes you will have the original to look at and you will not be affected by the upgrade to the latest version of the SDB.

  3. Double-click any configuration and note the Data Tables listed in the grid. For each sheet there is a Retrieval Method and Source which is executed to extract data during the Transfer Job. The Retrieval Method can be one of the following values:

    • CMS: The sheet contains Idents defined in CMS based on the Data Table Mappings (Group / Part) and the Commodity Code linked to the CMS Class.

    • PART_RANGE: The sheet contains idents based on the Group / Part specified in the Data Table Mappings.

    • SHT_CUST_METHOD: Not used as it requires custom procedures

    • SHT_STND_METHOD: The sheet contains data based on the Category of the sheet.

    • TABLE_DETAILS: The sheet contains data based on the Table Details associated with the sheet.

    • TEMPLATE_COPY: The sheet contains data based on the Template selected in the Export Job.

      The Source column for the Sheet and the Attributes determine the SQL code that will be executed to extract the data.

  4. Double-click any sheet to view the attributes, definition and procedures associated with the Data Table.

    • The first number in the Physical Attribute dictates the largest possible value the Attribute can have. i.e. AC0060_015 implies a limit of 60, AC0256_001 implies a limit of 256. If the exported data exceeds this the export will be aborted and an error will be reported in the log files.

    • If CodeList Number is checked then the Codelist associated with the Attribute will be used as a lookup and the corresponding Codelist number will be exported.

    • If the exported value is NULL then the value stored in the Default Value will be exported.

  5. For Data Tables of type CMS, the CMS_TYPE can be one of the following

    • ATTRIBUTE: The exported data will be the value in the Attribute specified in the CMS Source field. If the Use CMS NLS is checked then the description will be exported otherwise the value will be exported.

    • TABLE: The exported data will be the value in the Table specified in the CMS Source field. If the Use CMS NLS is checked then the description will be exported otherwise the value will be exported.

  6. For Data Tables that are not of type CMS, the RETRIEVAL_METHOD can be one of the following,

    1. ATTR_STND_METHOD:

      • If the Source is Default then the exported data will be derived from the Data Table Mappings / Attribute Mappings.

      • The Dependencies column determines the Mapping level i.e. CC = Commodity Code, I = Ident, P = Part, S = Spec, SI = Spec Item etc. The sequence determines the order in which the mappings will be scanned. CC, P implies check for Commodity Code level mapping first and then Part level mappings. If the Source is any other value then the SQL associated with the specified Source (retrieval source) will be used to calculate the exported value.

    2. ATTR_CUST_METHOD: Not Used as it requires customization.

    3. BASE_COLUMN: The exported data will the value stored in the field / formula specified by the Source.

    4. NONE: The value stored in the Default Value will be exported.

    5. CC_IDENT_INFO: The exported data will be a Table Detail or Attribute associated with the Commodity Code or Ident based on the entries in the Source Detail1, Source Detail 2, Source Detail3.

    6. PART_INFO: The exported data will be from the Commodity Group or Part associated with the Commodity Code based on the entries in the Source Detail1, Source Detail 2, Source Detail3.

    7. Click Definition Attributes tab to view the values that will be exported in the HEAD row of the sheet. These are fixed values and exported AS-IS.

    8. Click Attached Procedures tab to view the procedures that will be executed then the Data Table is being exported.

      The Type column determines when the procedure will be executed.

      • ON_MAINT_TPL_SHT: The procedure is executed when the data in the Template is updated.

      • ON_EXP_ROW: The procedure is executed as part of exporting the data to the Data Table.

      • PRE_EXP_SHT: The procedure is executed prior the exporting data for the Data Table.

      • POST_EXP_SHT: The procedure is executed after the data is exported for the Data Table.