Define column headers - SmartPlant Foundation - IM Update 48 - 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)

You can define the column headers for each import definition to map the column data from imported CSV files to the existing columns in a target system. The mapping can be driven by the target system database and defined manually using the free text option, or you can use existing mapping in the local staging area. All existing column headers for a selected import definition are displayed in the Column Headers pane.

You can create, edit, and modify each column header mapping to match the class definitions, objects, properties, relationships, and relationship properties between the imported data objects and target system objects.

If you selected Raw Property Format as the mapping format when creating the import definition, a separate Raw Attribute Map pane displays under the Column Headers pane. Initially, the Raw Attribute Map fields are empty and only show the column headers after at least one column has been mapped to an object; matching the CSV template file selected in the import definition. The Raw Attribute Map contains a read-only representation of the CSV raw attribute mappings. For information on defining the raw attribute mappings, see Define a raw attribute map.

Create a new column header Connect to a target system Search using a local search Create a new object or property using free text Create column header mappings Manage column header order

SHARED Tip Click a box in the diagram to go to the associated procedure.

What do you want to do?