Skip to content

Structure of the CSV file

The basis for using the Easy Asset Integrator is a CSV file in which the components that are to be created or changed are recorded.

The CSV file can contain the following columns in the specified order. Not all columns must be filled. If a front of the middle columns is to remain empty, enter two separators in succession. If, for example, no jobs are to be created, i.e. the back columns are not filled, you do not need to specify the separators.

Info

You can create a CSV file as a template directly after starting the Easy Asset Integrator. You can select whether the file should contain the sample data or components of your system. You can also save your own error-free CSV file and use it as a template, e.g. for further changes or additions.

CSV file columns

  • Component ID: The component ID does not necessarily have to be specified for existing components. These can also be identified by the combination of name and component directory. For new components: The Icon add symbol indicates that the component is newly created. The ID is then automatically assigned by the system.
  • Name: Component name
  • Directory: Component directory in the Project tree. Path of the directory is specified relative to the client archive and always begins with a \.
  • Component type: ID or name of the component type
  • Working directory: The working directory does not need to be specified if it is identical to the component directory.
  • Source data directory: Directory on the local system containing the project data to be transferred to the component and checked in. To import entire directory structures, you can also specify a ZIP file as the source directory. This must contain the extension .zip. The ZIP file is automatically unpacked during import and its contents are written to the working directory. If no source data directory is specified when creating a new component, the component is created without a base version.
  • Change reason: Change reason that is specified when the component is checked in. Whether or not a change reason must be specified depends on how this is configured in the Global settings in the AdminClient. If no user-defined change reason is specified, the change reason "Version was created by Easy Asset Integrator" is automatically entered when a new version is created.
  • Multi-User editing: Specifies whether Multi-user editing is activated.
  • Master data of the component. Master data does not have to be specified.
    • Client
    • Project
    • Country
    • City
    • Plant
    • Hall
    • Plant area
    • Note 1-3

Columns for creating jobs for the components (highlighted in color). Default values are used for the job configuration settings that are not filled in here.

  • Create job: Specifies whether a job should be created for the component. Possible values are true or false. If no value is specified here, no job is created. If a job already exists for the component, no new job is created either.
  • Upload type: Upload type of the job. Not every upload type can be used for every component type.
  • IP address: IP address or computer name of the device for which the job is to be executed. The value can only be specified for upload types for which this specification is supported.
  • User name and password: Login data of the user under which the device is to be accessed. The value can only be specified for upload types where login data is requested.
  • Result: Result of the import. If the lines of the file were imported successfully, the system enters the value Imported here. Otherwise an error is displayed.

The CSV file does not necessarily have to contain a first line with the column names. When importing, you can specify whether the first line should be ignored or not.

You can use the following characters as separators between the columns in the CSV file:

  • The list separator set by default in your Windows system
  • The CSV separator set by default in the AdminClient in the Global settings module (Server: Server settings and paths tab).
  • Tab
  • Semicolon
  • Space
  • Comma

When importing, enter the separator you have selected in the Easy Asset Integrator dialog.