Property - Import data from CSV

This LRT can be used to import property.

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

There is possibility to import property EAVs too along with basic attributes. To do it, CSV file will look like this:

name;code;description;setCode;serialNumber;disabled;eavName1;eavValue1;eavName2;eavValue2
Skoda Octavia 1;octavia_1;Broken seats;Cars;1234567gdfh-dfgdfg46;false;color;blue;price;300000
Skoda Octavia 2;octavia_2;Ordered;Cars;;truel;color;black;price;500000

For each EAV two new columns are needed, one for EAV code and one for its value. In this case, EAVs "color" and "price" will be imported. Names of these new columns consist of name/value prefix (which is defined in LRT parameters) and order of EAV (In order for all EAVs to be loaded correctly, the order sequence must form a continuous series starting from one (1, 2, 3…)).

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.

Now we will create the new LongRunningTask (LRT). Go to Settings → Task scheduler → Scheduled tasks and hit green "Add" button to add new LRT.

Now we need to create new LRT with these attributes:

Select task type Import property, drop CSV file into "Upload a CSV file" dropzone (or click on it to select file from dialog), set column separator and file encoding according to your CSV file. In case you want to import EAVs too, define eav name/value prefix.

Now we just need to hit run.

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

  • by koulaj