How to pass the word null as a string value in a bulk loader csv file in Identity Manager

Document ID : KB000074743
Last Modified Date : 03/04/2018
Show Technical Document Details
Issue:
How to pass the word null as a string value in a bulk loader csv file in Identity Manager
Resolution:
The setter methods in the CSV Parser class work so that the value "null" (null surrounded by double quotes), is interpreted as an empty string. However the value 'null' (null surrounded by single quotes) is converted to an explicit string with value null (i.e. the word null as a string value). So if you set the attribute to 'null' then you will get the word null as a string value, generated for that attribute. 

Here's a sample csv that puts the word null as a string value into email attribute:
action, uid, givenName, sn, cn, description, email, organization, city, state, addresses:
create,JaneFadida1,Jane,Fadida,Jane Fadida,Jane,'null',NeteAuto,"ou=NeteAuto,dc=security,dc=com",Import,LA,14 Maple st. 

The above values will actually set the mail attribute to the word null as a string value:
Jane Fadida's email = null