Skip to main content

Import CSV

Use this form to load objects from a CSV file into the object tree. For the structure of the input CSV file, see ImportUtil.

  • Input file - select the input CSV file from disk that you want to import.
  • Create in - select a folder object into which you want to import new objects.
  • Extended

    • Object type - if the input file does not contain a Class column (or Type), select the type of objects you want to create. If the input file contains a Class column (or Type), select the <all in input file> option or, if you want to read only rows for a specific object type from the file, select the type.

    • Key columns - select the columns in the input file that uniquely identify the objects. If an object already exists in the object tree with the same property values according to the key columns, a new object is not created in the tree, but only the values of the other loaded properties are updated in the existing object.

    • Search discarded assets - if you enable this option, the assets in the Discarded assets folder are also searched and updated during import.

    • Format of date columns - date format in text strings (e.g. dd/MM/yyyy). For a detailed description of the formats, see Custom date and time format strings.

      note

      Date formats are governed by local language settings on the server.

    • Column separator - specify the column separator used in imported CSV file, e.g., comma (,) or semicolon (;).

  • Import - start the import.
note

The Create any objects right is required for this operation.