Create 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)

Column headers are used to map the data in the CSV file to the correct locations in the staging area and target systems. Column headers support a number of different column types. You must create a column header mapping for each column header that is generated from the sample input file. Each of the column headers is mapped to an object or property that is available in the target system. The column headers in the CSV file are mapped to the target system objects that are created by loading the sample schema file into the target system. For detailed information on mapping, see Create column header mappings.

Object mapping

  1. In the Import Definitions pane, select the ImportDef-Tag import definition.

  2. In the Column Headers pane, select the Name column header and click Edit Column Header .

  3. In the Column Header pane, select Physical from the Column Type list.

  4. Verify that the Name and Column Header Text boxes are populated with NAME.

  5. In the Mappings pane, select the Object Mapping option.

  6. On the Target System tab, click Connect to Target System SPFTGT.

    The Target System tab is not enabled unless you selected the target system while creating the import definition.

  7. In the search box, type *SampleTag* and press ENTER.

  8. Select SampleTag from the class definition list, and click Add New Mapping .

  9. Select Create Update from the Object Action list.

  10. Verify that Unique Identifier is set to NAME.

  11. Select the Is Mandatory option to indicate that the column is required to have a value.

  12. Verify the Property Mapping option is selected in the Mappings pane.

  13. Verify that Name is populated in the class definition list, and then click Add New Mapping to map the Name property.

  14. Verify the following in the Maps to Property Name with action Create Update pane:

    • Name is populated in the Maps to Property box.

    • Property Action is set to Create Update.

    • Parent Objects box displays Name with Create Update action as selected.

  15. Click Save.

    SHARED Tip When a column mapping has been added successfully, a check mark displays in the Has Mapping column next to the column header mapping in the main window.

You must create a column mapping for each of the column headers available under the ImportDef-Tag import definition. This is required to load the data available in the sample input file to the target system.

Property mapping

  1. In the Column Headers pane, select the Description column header and click Edit Column Header .

  2. In the Column Header pane, select Physical from the Column Type list.

  3. Verify that the Name and Column Header Text boxes are populated with Description.

  4. In the Mappings pane, select the Property Mapping option.

  5. On the Target System tab, select SampleTag from the Class Definition To Filter Properties list.

  6. Click Search and select Description from the properties list.

  7. Click Add New Mapping .

  8. Select Create Update from the Property Action list.

  9. Verify the following in the Maps to Property Name with action Create Update pane:

    • Description is populated in the Maps to Property box.

    • Property Action is set to Create Update.

    • Parent Objects box displays Name with Create Update action selected.

  10. Click Save.

  11. Use the information in the following table to complete the property mappings:

    Column header text in the CSV file

    Maps to property in the target system

    Property action

    DESCRIPTION

    Description

    Create Update

    Pump Type

    SampleTag_Type

    Create Update

    Design_Pressure_Min

    SampleTag_Design_Pressure_Min

    Create Update

    Design_Pressure_Max

    SampleTag_Design_Pressure_Max

    Create Update

    Design_Temperature_Min

    SampleTag_Design_Temperature_Min

    Create Update

    Design_Temperature_Max

    SampleTag_Design_Temperature_Max

    Create Update

    OVERALL_LENGTH

    SampleTag_Length

    Create Update

    OVERALL_HEIGHT

    SampleTag_Height

    Create Update

    OVERALL_WIDTH_OR_DIA

    SampleTag_Width

    Create Update

Tell me more

Create column mapping for Pump Type

  1. In the Column Headers pane, select the Pump Type column header and click Edit Column Header .

  2. In the Column Header pane, select Physical from the Column Type list.

  3. Select the Property Mapping option in the Mappings pane.

  4. On the Target System tab, select SampleTag from the Class Definition To Filter Properties list.

  5. In the search box, type *type* and press Enter.

  6. Select SampleTag_Type from the class definition list, and click Add New Mapping .

  7. Verify the following in the Maps to Property Name with action Create Update pane.

    • SampleTag_Type is populated in the Maps to Property box.

    • Property Action is set to Create Update.

    • Parent Objects box displays Name with Create Update action as selected.

  8. Click Save.

Create column mapping for Design_Pressure_Min

  1. In the Column Headers pane, select the Design_Pressure_Min column header and click Edit Column Header .

  2. In the Column Header pane, select Physical from the Column Type list.

  3. Select the Property Mapping option in the Mappings pane.

  4. On the Target System tab, select SampleTag from the Class Definition To Filter Properties list.

  5. In the search box, type *pressure* and press Enter.

  6. Select SampleTag_Design_Pressure_Min from the class definition list, and click Add New Mapping .

  7. Verify the following in the Maps to Property Name with action Create Update pane.

    • SampleTag_Design_Pressure_Min is populated in the Maps to Property box.

    • Property Action is set to Create Update.

    • Parent Objects box displays Name with Create Update action as selected.

  8. Click Save.

Create column mapping for Design_Pressure_Max

  1. In the Column Headers pane, select the Design_Pressure_Max column header and click Edit Column Header .

  2. In the Column Header pane, select Physical from the Column Type list.

  3. Select the Property Mapping option in the Mappings pane.

  4. On the Target System tab, select SampleTag from the Class Definition To Filter Properties list.

  5. In the search box, type *pressure* and press Enter.

  6. Select SampleTag_Design_Pressure_Max from the class definition list, and click Add New Mapping .

  7. Verify the following in the Maps to Property Name with action Create Update pane.

    • SampleTag_Design_Pressure_Max is populated in the Maps to Property box.

    • Property Action is set to Create Update.

    • Parent Objects box displays Name with Create Update action as selected.

  8. Click Save.

Create column mapping for Design_Temperature_Min

  1. In the Column Headers pane, select the Design_Temperature_Min column header and click Edit Column Header .

  2. In the Column Header pane, select Physical from the Column Type list.

  3. Select the Property Mapping option in the Mappings pane.

  4. On the Target System tab, select SampleTag from the Class Definition To Filter Properties list.

  5. In the search box, type *temperature* and press Enter.

  6. Select SampleTag_Design_Temperature_Min from the class definition list, and click Add New Mapping .

  7. Verify the following in the Maps to Property Name with action Create Update pane.

    • SampleTag_Design_Temperature_Min is populated in the Maps to Property box.

    • Property Action is set to Create Update.

    • Parent Objects box displays Name with Create Update action as selected.

  8. Click Save.

Create column mapping for Design_Temperature_Max

  1. In the Column Headers pane, select the Design_Temperature_Max column header and click Edit Column Header .

  2. In the Column Header pane, select Physical from the Column Type list.

  3. Select the Property Mapping option in the Mappings pane.

  4. On the Target System tab, select SampleTag from the Class Definition To Filter Properties list.

  5. In the search box, type *temperature* and press Enter.

  6. Select SampleTag_Design_Temperature_Max from the class definition list, and click Add New Mapping .

  7. Verify the following in the Maps to Property Name with action Create Update pane.

    • SampleTag_Design_Temperature_Max is populated in the Maps to Property box.

    • Property Action is set to Create Update.

    • Parent Objects box displays Name with Create Update action as selected.

  8. Click Save.

Create column mapping for Overall_Length

  1. In the Column Headers pane, select the Overall_Length column header and click Edit Column Header .

  2. In the Column Header pane, select Physical from the Column Type list.

  3. Select the Property Mapping option in the Mappings pane.

  4. On the Target System tab, select SampleTag from the Class Definition To Filter Properties list.

  5. In the search box, type *length* and press Enter.

  6. Select SampleTag_Length from the class definition list, and click Add New Mapping .

  7. Verify the following in the Maps to Property Name with action Create Update pane.

    • SampleTag_Length is populated in the Maps to Property box.

    • Property Action is set to Create Update.

    • Parent Objects box displays Name with Create Update action as selected.

  8. Click Save.

Create column mapping for Overall_Height

  1. In the Column Headers pane, select the Overall_Height column header and click Edit Column Header .

  2. In the Column Header pane, select Physical from the Column Type list.

  3. Select the Property Mapping option in the Mappings pane.

  4. On the Target System tab, select SampleTag from the Class Definition To Filter Properties list.

  5. In the search box, type *height* and press Enter.

  6. Select SampleTag_Height from the class definition list, and click Add New Mapping .

  7. Verify the following in the Maps to Property Name with action Create Update pane.

    • SampleTag_Height is populated in the Maps to Property box.

    • Property Action is set to Create Update.

    • Parent Objects box displays Name with Create Update action as selected.

  8. Click Save.

Create column mapping for Overall_Width_Or_Dia

  1. In the Column Headers pane, select the Overall_Width_Or_Dia column header and click Edit Column Header .

  2. In the Column Header pane, select Physical from the Column Type list.

  3. Select the Property Mapping option in the Mappings pane.

  4. On the Target System tab, select SampleTag from the Class Definition To Filter Properties list.

  5. In the search box, type *width* and press Enter.

  6. Select SampleTag_Width from the class definition list, and click Add New Mapping .

  7. Verify the following in the Maps to Property Name with action Create Update pane.

    • SampleTag_Width is populated in the Maps to Property box.

    • Property Action is set to Create Update.

    • Parent Objects box displays Name with Create Update action as selected.

  8. Click Save.