Items empty or values incorrect - Intergraph Smart Reference Data - Version 10.1 - Training - Hexagon

Intergraph Smart Reference Data Training (10.1)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Training
Smart Materials/Smart Reference Data Version
10.1

In this scenario, all expected lines appear on the output data table, but the values for one or more attributes in one or more rows are missing or wrong.

General Hints

If the data table is contained in the catalog structure, navigate to Integration->Smart 3D->Smart 3D Transfer Jobs->Transfer Job Results. Select the data table from data table combo box to display the exported data from the data table.

f the data is ok there, it must have been transmitted incorrectly during the writing of the Excel file. You should look at the Write to file logfile.

If a complete column is missing from the data table, but it is on Integration->Smart 3D->Smart 3D Configurations->Data Table Configurations and also in the result display on Integration->Smart 3D ->Smart 3D Transfer Jobs->Transfer Jobs, make sure that the In XLS check box is selected on Integration->Smart 3D->Smart 3D Configurations->Data Table Configurations, which is set by default:

52

A value could also be missing from the data tablebut appear in the result because the Suppress Repetition indicator is selected. Suppressing repetition of equal values from row to row makes data tables more readable and files smaller. The question is if the Bulkload utility can handle this situation for the current attribute and data table.

If the attribute values are the same on the data table and in the result display of Integration->Smart 3D ->Smart 3D Transfer Jobs->Transfer Jobs, you should check the configuration of attributes on Integration->Smart 3D->Smart 3D Configurations->Data Table Configurations.

Consider this question: What method and source were used to retrieve the value? The method and source determine the resulting cell value.

If the retrieval method is NONE, you can expect that the default value is written to the data table.

  • If the retrieval method is ATTR_STND_METHOD, the source points to a function defined on retrieval sources screen. You can look at this screen to find out more about the retrieval source. If the source is "Default," the attribute mapping on Integration->Smart 3D ->Smart 3D Configurations->Data Table Mappings is used to populate the field.

  • If the retrieval method is BASE_COLUMN, sources must be references to valid columns used in the underlying tables, such as "cc.commodity_code." There may also be more complicated function calls that operate on those table columns.