Create a new job details item object - 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 job details item object contains information to process the CSV files attached to the object being converted into a job.

You can split the basic CSV files attached to the object. You must specify a column name and values for splitting the CSV files as inputs in the New Job Details Item dialog box. For example, you can specify the following:

  • Action as the column name in the Column name used to split CSV file box.

  • Create, Update or C, U as values in the Value used to split create or update records box.

  • Delete or D as value in the Values used to split delete records box.

The split CSV files are then related to the specified import definitions for create and delete.

You can also unzip the zipped files uploaded with the object, if it is a document object. To skip referenced files when unzipping the files, you can specify the file column names in the New Job Details Item dialog box. If the Import definition for create action or the Column name used for file names (zip) boxes are blank, the unzip process is skipped.

If you attach a raw property (inverted) CSV file, you must specify the characters which are included in the file name to distinguish it from the basic CSV file to avoid errors during validation.

  1. In the Desktop Client, click File > New > Data Validator > Job Details Item.

  2. In the Main details section, type a name and description for the job details object.

  3. In the Basic CSV format details section, do the following:

    • Type an import definition name in the Import definition for create action box.

    • Type an import definition name in the Import definition for delete action box.

    • Type a column name in the Column name used to split CSV file box to split the CSV file.

    • Type the values in the Value used to split create or update records box to split the create or update records in the CSV file. Use a comma to separate multiple values.

    • Type the values in the Values used to split delete records box to split the delete records in the CSV file. Use a comma to separate multiple values.

    • Type a column name in the Column name used for file names (zip) box to skip any referenced files when unzipping the zip files.

      SHARED Tip This is required only if the object is a document.

  4. In the Inverted CSV format details section, do the following:

    • Specify an import definition in the Import definition for inverted format box.

    • Specify the characters that are included in the CSV file name in the Inverted CSV file name includes box.

  • If a column name is not specified in the Column name used to split CSV file box, you must specify an import definition in the Import definition for create action box to create or update all the records in the CSV file.

  • When no values or empty values are specified in the column used to split the CSV file, the records in the CSV file will be created or updated by default.