Define a raw attribute map - SmartPlant Foundation - IM Update 46 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

The data in a standard CSV file is typically organized in horizontal rows, where each row contains properties and relationships for the single object. However, it is possible to organize the data as an inverted CSV file.

The inverted CSV file, or CSV raw attribute format file, contains a smaller number of columns, and each property and attribute for an object is on in a separate row. In the case of a CSV raw attribute format file, the first column or columns contain data to identify the object, such as the area, for example, PLANT_CODE, and the name of the object, TAG_NAME.

The first column header can be defined to identify the object's attributes in your CSV template file. For information on defining the column headers, see Create column header mappings.

In the following example, the last three column header mappings for the import definition match the Property_Name, Property_Value, and Property_Value_UOM in the raw attribute map.

These column header mappings can be predefined in an imported CSV template XML file that you select when creating the import definition for CSV raw attribute mapping. However, these values are set as Property_Name, Property_Value, and Property_Value_UOM, but you can use different values for the column headers in the import definition. To define the object properties for these columns, see Create column header mappings.

When the CSV raw attribute mappings are complete and the raw attribute map column header has been mapped to the object property, the column is identified by a blue dot in the Column Headers pane.

Raw Attribute Map

When you have created an import definition using the Raw Property Format mapping format, the Raw Attribute Map dialog box displays under the Column Headers pane.

The Raw Attribute Map dialog box displays an editable list of CSV raw attribute mappings for inverted format files. The column headers are:

  • Parent Object Column - Mandatory. Any column with a class map

  • Property Name Column - Mandatory. Any column without mappings

  • Property Value Column - Mandatory. Any column without mappings

  • Property UOM Column - Any column without mappings

  • Property Format Action - Any of the property actions available for the Class map action on the Parent Object Column. This default value is based on the selected Parent Object Column, for example Create Update.

  • Property Name Suffix - When staging and target systems are the same, you must specify a suffix to avoid conflicts. For example, you can specify _SDV as a suffix.