Setting up the Bulk Loader with Multi-Valued attributes.

Document ID : KB000024004
Last Modified Date : 14/02/2018
Show Technical Document Details


Using the Identity Manager Bulk Load option to load the users from a CSV file to User Store.
All but multi-valued attributes work as expected. User is created as expected and all other attributes are populated from the CSV file.
Multi-valued attributes such as (IDMForgottenQuestions) have been created for storing the questions/answers from Identity Manager.
This Multi-Valued attribute does not get populated with all the values in the CSV file.

What is the correct format for populating the multiple values in a multi-valued attribute in Identity Manager using Bulk Loader?


The solution to this issue is to ensure that all Multi-Valued fields are separated by semi-colons in the CSV file. A line in the file might look like:

field1, field2, field3, multi1; multi2; multi3

The Application server will output exceptions when it has trouble parsing a line, so you should first look at the Application server's log to see if it provides any details.

It would also help to have the line it failed on, since that would give a clearer picture of what might be wrong.

Finally, if there are commas, quotes, and semi-colons being used in a field it will complicate how the line looks.

Additional Information:

This method will store all the values from the CSV file in the specific attribute, overwriting existing ones. For the ability to add some values while removing others, please review TEC1852168