Using a Delimiter within Bulk Loader (Identity Manager)
search cancel

Using a Delimiter within Bulk Loader (Identity Manager)

book

Article ID: 33329

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

This readme will walk you through how to use a delimiter within the bulk load process.

Environment

Release:
Component: IDMGR

Resolution

The bulk loader delimiter is the semicolon or ;

The delimiter is used to add multiple values to a single attribute.

Example CSV #1

For Users:

action,%USER_ID%,%SERVICE_PROPERTIES%

modify,user07,234523;32452345;523542345

The delimiter is used in this example to add multiple values to the %SERVICE_PROPERTIES% attribute.

Example CSV #2

For Groups:

action,%ORG_Description%,%ORG%,%ORG_OWNER%

modify,user07,Employee,"ou=Employee,ou=NeteAuto,dc=security,dc=com","uid=user01,ou=Admins,dc=Support,o=CA,c=US";"uid=user02,ou=Admins,dc=Support,o=CA,c=US";"uid=user03,ou=Admins,dc=Support,o=CA,c=US"

In this example the OU being declared must be in quotes then the delimiter can be used to add multiple groups to a single user.