Input file formats

The input template files are shipped with installer and can be found at location [Install Path]\Templates.

This table lists the Excel worksheet names and the CSV file names and columns in the templates provided:

Worksheet/CSV file name Column Description
Users UserID Unique ID of the user. It is a mandatory field.
Description
First Name
Last Name
Full Name
Group One user can have only one UserGroup.
ValidFromDate Date should be in the format MM/DD/YYYY
ValidToDate Date should be in the format MM/DD/YYYY
LockStatus

Lock status of the user.

  • For SAP: The value should be TRUE/FALSE.
  • For Oracle: The value should be Y/N.
  • For legacy application having different LockStatus values, activevalue/inactivevalue attributes for LockStatus field in the Configuration file will be used.
Email
Custom attribute(s) This can be additional attribute of the user.
Roles RoleID Unique ID of the role. It is a mandatory field.
RoleDescription
StartDate Date should be in the format MM/DD/YYYY
EndDate Date should be in the format MM/DD/YYYY
CreatedOn Date should be in the format MM/DD/YYYY
CustomAttribute
Programs ProgramID Unique ID of the program. It is a mandatory field.
ProgramDescription
Users_Roles UserID User ID present in Users worksheet/csv file.
RoleID Role ID present in Roles worksheet/csv file.
StartDate Date should be in the format MM/DD/YYYY
EndDate Date should be in the format MM/DD/YYYY
Roles_Programs RoleID Role ID present in Roles worksheet/csv file.
ProgramID Program ID present in Programs worksheet/csv file.
Note: Input Excel/CSV files should not contain blank rows in data files. Mandatory fields should not be blank.