Create a new column header - 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)

How do I decide whether to select Local, Target System, or Free Text option when creating a new mapping for a column header?

The Local, Target System, and Free Text options are available in the Create New Column Header dialog box to create new mappings.

  • Use the Local option to search for an object, property, or relationship locally in the SmartPlant Foundation system and add it to a new mapping.

  • Use the Target System option to connect to an existing target system and add a new mapping.

  • Use the Free Text option to create a new object or property that does not exist in the target system and create the mapping.

  1. Click Create New Column Header from the Column Headers pane toolbar to open the Create New Column Header dialog box.

  2. In the Column header pane, select the column type required from the Column Type list box. The options on this dialog box differ for the column type selected. For more information, see Column types.

  3. Provide a name and any other details required for the selected column header type, such as in the Column Header Text box.

  4. Select the Multiple Values Column checkbox if any column in your CSV file contains multiple values.

    For example, if a tag has to be related to many secondary disciplines (such as MECH, ELEC, CIVIL), you can separate the values in the CSV file using a comma, and then select this checkbox when creating the column header.

    The Multiple Values Column option is supported for Physical and Computed Column types only. For Computed Column type, the function can return multiple values. However, it does not support multiple values as input.

  5. Select the Ignore properties with blank values option if you want properties with blank values in your CSV file to be ignored.

  6. From the Add New Mapping options, choose whether to map the new column header to:

    1. an object using a class definition

    2. an object using an interface definition

    3. a property

    4. a relationshp

    5. a relationship property

  • If you do not want to add prompted values for the Prompted API, Prompted, and Prompted Picklist column types, select the Value for this column can be blank option. A prompted value is then not needed when you create a job in Data Validator Job Management.

  • When you select the Ignore properties with blank values option for the Prompted API, Prompted, and Prompted Picklist column types, a prompted value is not needed when you create a job in Data Validator Job Management, and the property will not be instantiated in the target system.