How to add and remove values from multi valued attribute using CSV and bulk loader
search cancel

How to add and remove values from multi valued attribute using CSV and bulk loader


Article ID: 43368


Updated On:


CA Identity Manager CA Identity Governance CA Identity Portal CA Risk Analytics CA Secure Cloud SaaS - Arcot A-OK (WebFort) CLOUDMINDER ADVANCED AUTHENTICATION CA Secure Cloud SaaS - Advanced Authentication CA Secure Cloud SaaS - Identity Management CA Secure Cloud SaaS - Single Sign On




The Bulk Loader handles attributes in the CSV file as if they are Single Valued. It will set a value to them. See the workaround to learn how to bypass this limitation to be able to add or remove values to a multi-valued attribute via the CSV and use Bulk Loader.





Release: CAIDMB99000-12.6.7-Identity Manager-B to B


Consider this example:

Your multi-valued attribute is Phone Number where a user can have many phone numbers. What you can do is: you can add two new attributes to your schema, called: 'addedPhoneNumbers' and 'removedPhoneNumbers'. 

In your CSV you will be able to set values to these two attributes and then build up an Identity Policy that in it's 'Add' action rule it will add the values from the 'addedPhoneNumbers' to your multi-valued PhoneNumbers attribute and in its 'Remove' action rule is will remove the values that are set in 'removedPhoneNumbers' from the multi-valued PhoneNumbers attribute. 

So, let's take an example. Let's say: user already has PhoneNumbers having: "111-1111" and "222-2222". Let's say that you would like to add "333-3333" and remove "222-2222" . The result in PhoneNumbers should be: "111-1111" and "333-3333". 

So, you set your CSV 'addedPhoneNumbers' attribute to: '333-3333'. You set your CSV 'removedPhoneNumbers' attribute to '222-2222'. 

Now, your Identity Policy will have an Add action rule that will add '333-3333' to Phone Numbers. It will also have a 'Remove' action rule that will remove '222-2222' from Phone Numbers and so the result will be that Phone Numbers will have '111-1111' and '333-3333' as you need it to be.