Uploading users in bulk

Multiple users can be synched at once from a CSV file through the SelfService portal. To synchronize users in bulk, follow the steps below.

  1. Select Access Management > Bulk Upload.
  2. Select Browse to choose a local CSV file that contains the user data to be synched to OpenIAM. Select Sync Now to begin synchronization.
  3. Synchronization details will show the status of the synchronization by displaying the number of records processed, the number of records synched successfully, and the number of records that failed to synch.

The table below provides a reference for CSV column names and data types for successful synchronization.

Field NameData TypeDescription
FIRST_NAMEStringEmployee's first name.
LAST_NAMEStringEmployee's last name.
PREFERRED_NAMEStringAlternate employee name.
EMPLOYEE_IDStringUnique identifier for the employee within the HR system.
SUPERVISORStringManager's username.
START_DATEDateDate the employee joins the company.
LAST_DATEDateDate the employee leaves the company.
COMPANYStringCompany.
DEPARTMENTStringDepartment.
EMAILStringEmail address.
PHONEStringEmployee's desk phone.
MOBILE_PHONEStringEmployee's mobile phone.
STATUSStringEmployee's status: Active, Terminated, etc.
TITLEStringEmployee's corporate title.
TYPEStringType of employee: Employee, Contractor, etc.
ADDRESSStringStreet name.
CITYStringCity.
STATEStringState or province.
POSTAL_CODEStringZip or postal code.
COUNTRYStringTwo letter country code.
BADGE_NUMBERStringEmployee badge ID.