tutorial:adm:systems_-_import_of_data_from_csv

Systems - Import of data from CSV

This feature is available in extras module only!

Have you ever wonder that Virtual System would be good for you but cannot find the way how to import data at first? Well, now we are able to do so by LongRunningTask which takes schema id and other arguments and imports all into the system. In this tutorial, I will show you step by step how to run it!

Please use this tutorial to do so!

Here is an example of CSV file which can be used for import to the system.

"username";"email";"firstName";"lastName";"phone";"titleAfter";"titleBefore";"__ENABLE__"
"arnold";"arnold@somename.com";"Arnold";"Stastny";"723067901";"";"";"false"
"betty";"betty@somename.com";"Betty";"Lenc";"724647897";"";"";"false"
"cecilia";"cecilia@somename.com";"Cecilia";"Rudnik";"887824836";"";"";"false"
"elizabeth";"elizabeth@somename.com";"Elizabeth";"Martinson";"123456789";"";"";"false"
"peter";"peter@somename.com";"Peter";"Bondra";"";"ing.";"";"true"
"ruth";"ruth@somename.com";"Ruth";"Delict";"";"";"dis.";"false"
"joe";"joe@somename.com";"Joe";"LaBonte";"";"bc.";"";"false"

Now the new system should be created by your chosen name. Please copy or remember this name and follow to the next steps.

Make sure that the schema created for your virtual system fits the structure of your csv file!

Now we will create the new LongRunningTask(LRT). As shown in the picture, go to SettingsTask schedulerScheduled tasks and hit green "Add" button to add new LRT.

Now we need to create new LRT with these attributes:

  • Task type - Have to be ImportFromCSVToSystemExecutor
  • Description - it is up to you how you want it - just describes the task
  • Instance - Have to be idm-primary
  • Name of system - now we paste our name of system
  • Path to file - CSV file from which it will be imported
  • Name attribute - the attribute which holds the name - usually same as uid
  • Uid attribute - which the attribute is UID in your system
  • Attribute separator - which character separates the attributes
  • Separator of multivalued attributes - the character which separates values - multivalued

Now we just need to hit run

and we also need to process it in all tasks

Everything should be set up so far and when the task ends, your system is ready! Now while generating system, there was created synchronization with name Link virtual accounts to identities.

Run this synchronization and all entities should be paired.