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.
|
|
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.