Book Creator
 Add this page to your book
Book Creator
 Remove this page from your book  

 Manage book(0 page(s))
 Help

Property - Import data from CSV

This LRT can be used to import property.

Prepare CSV file

Here is an example of CSV file which can be used for importing property. 

name;code;description;setCode;serialNumber;disabled
Skoda Octavia 1;octavia_1;Broken seats;Cars;1234567gdfh-dfgdfg46;false
Skoda Octavia 2;octavia_2;Ordered;Cars;;true

The names of the columns are fixed and you cannot change them.

Overview of attributes:

  • 'name' is the descriptive name of the property - must not be null
  • 'code' is the technical name of the property, must be unique - must not be null
  • 'description' is only a descriptive attribute
  • 'setCode' is the code of the set to which the property belongs - must not be null
  • 'serialNumber' is only a descriptive attribute
  • 'disabled' is an attribute which when true will prevent the property to be assigned to a user - must not be null
CzechIdM uses by default utf-8 encoding. If your input file is encoded in different encoding, or if you experience some issues with non English characters, you may set different encoding in configuration of import long running task. Examples of other used encodings might be windows-1250, or windows-1252
Update is not supported. Only new property can be created by import.

Create new LongRunningTask

Now we will create the new LongRunningTask (LRT). As shown in the picture, go to Settings → Task scheduler → Scheduled tasks and hit green "Add" button to add new LRT.

Fill all attributes

Now we need to create new LRT with these attributes:

- Task type - Import property - Import csv file - dropzone to select or drop csv file - Import file encoding - the encoding of the csv file - Column separator - separator of columns in csv file

Run the task

Now we just need to hit run.

Once the task is finished, the property will be imported.

  • by doischert