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.