Attributes - Intergraph Smart Reference Data - 2020 10.0 - Customization & Programming - Hexagon

Intergraph Smart Reference Data Integration (2020)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
2020 (10.0)

The Smart 3D attributes that are used to describe the data columns of the Excel sheets must be defined. All known standard attribute definitions are delivered with the product.

The Attribute name is used as the column title on the Excel sheets. On the Data Table Configuration screen, the Smart 3D attributes are assigned to the sheets. The same attribute can occur on different sheets if it labels the same thing.

The LOV Statement field can be used to define a statement to populate the LOV in Smart Reference Data. If this column is empty, the software tries to build a LOV from the assigned codelist. As a basis for an LOV, use a normal select statement with the following structure:

SELECT <column1> VALUE, NULL CODELIST, <column2> DESCRIPTION FROM ...

Alternatively, if there are values to be selected from a template, the structure may look like the following:

TEMPLATE?<Sheetname>?<ValueColumn>,<DescriptiveColumn>

The LOV definition is used for validation of the values entered. In the case of the TEMPLATE syntax, it is also used for synchronization of depending attributes. For example, if you change a codelist value on the Templates screen, the software updates all references with the same value on Item Mappings/ Templates screen if they belong to the same template.

If the attribute values are based on a codelist, the codelist table name is specified in the Codelist field. The value of the codelist is expected to be found on Templates screen on a sheet named as entered in this Codelist field, in a column named <codelistname><blank>'ShortDescription' while the codelist number is fetched from the same sheet from the column that is labeled Codelist Number.

Do not use the Codelist column and the LOV Statement column on the same attribute. For referencing codelists, use the Codelist column; for others, use the LOV statement.

Smart 3D custom interfaces are used to group existing attributes written in the CustomInterfaces sheet.

To define attributes for the transfer to Smart 3D, click Integration > Smart 3D > Smart 3D Configuration and then click the Attributes tab.

Attributes1