Define a raw attribute map - HxGN SDx - Update 63 - Administration & Configuration

Administration and Configuration of HxGN SDx

Language
English
Product
HxGN SDx
Search by Category
Administration & Configuration
SmartPlant Foundation / SDx Version
10

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.