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

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

book

Article ID: 74743

calendar_today

Updated On:

Products

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

Issue/Introduction

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

Environment

Release: CAIDMB99000-14.0-Identity Manager-B to B
Component:

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,SampleUser1,Sample,User,Sample User,Sample,'null',NeteAuto,"ou=NeteAuto,dc=security,dc=com",Import,LA,111 Generic address st

The above values will actually set the mail attribute to the word null as a string value:
Sample User email = null