Table of Contents
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.