Configure Attribute Sets - Intergraph Smart Materials - Version 10.1 - Administration & Configuration - Hexagon

Intergraph Smart Materials Integration (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Construction Version
8
Smart Materials/Smart Reference Data Version
10.1

Use A.50.04 to transfer the Instrument entity type and complete the attribute sets that you want to use to build CCs with the information where the data for your attributes can be found in Smart Instrumentation.

The source for the attributes M_COMMODITY_GROUPS and M_PARTS can be left out because their definition cannot depend on attribute sets. Their source is stored in IN 10.01 and is equal for the whole project.

The location of the other attributes in Smart Instrumentation can be configured. The column information tells Smart Materials from which database column in Smart Instrumentation to query the data. The table is the physical table in Smart Instrumentation from which the information is fetched. You are not required to enter a table name if your column belongs to the same table from which the tag number is retrieved. The tag number for instruments is the column cmpnt_name within the component table. Therefore, if you use another column in this table as attribute information, such as cmpnt_serv, you can leave the table field blank. The same is true for the join column field. The join column field is used to connect the tag-number-table with the table that contains the column that you want to use as attribute information.

You can use SQL functions in the column field, for example, to retrieve only a substring of the requested column. The column name is always prefixed automatically by the program internally. You will not see the prefix. If you use SQL functions, Smart Materials cannot set this prefix, so you will have to set it manually. Always use "dflt" if your column is in the tag-number-table. In other cases, use "other."

You cannot use SQL functions in the join column field.

Any leading and trailing blanks from the data are removed automatically.