You can add user accounts by importing users, user information and optionally update existing user details by reading data from a specially formatted text file. After you create the file, you can run an error check to verify that the file is properly formatted.
The file can be in LDAP Data Interchange Format or a comma-delimited file. For further instruction on using LDAP, see Working with LDAP and SS0.
![]() |
• |
You can download user data to a text file (.txt) that you can edit for importing bulk changes. The data is displayed in a browser window. Save the page and open it as a tab-delimited file in a spreadsheet application. When you are finished making changes, upload the changes using the Import instructions described below. For details about downloading user data to a text file, see Exporting user data. |
• |
Once added, you can also update existing users using the same import approach. Based on the fields that are available to import, you can also do the following:
|
|
• | You can import historical student completion records from another LMS. For details, see Importing historical student completion records. |
The tab-separated file must conform to the following specifications:
Use the Tab character (Hex 0x09) to separate data items.
Each row represents one user.
Each row must end with a carriage return/line field.
The first row must contain field names used to locate the corresponding columns within the data. Order is not important.
If a header field name in the import file does not match one of the first four CourseMill column names, you will get an error. If it does not match any of the other field names, you will not get an error message and the field will not be updated.
Unrecognized columns of data will be discarded. If a data column from the host system does not contain a value for each user, insert -None- to avoid blank or null data columns.
For Excel, if you have leading zeros (0), Excel will truncate the zeros leading to a failed data load. Save the field as a text field to retain the zeros.
Include the following column names:
Column name |
Description |
||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
OrgID |
The user's organization. This field is required. |
||||||||||||||||
ID |
The user's user ID. This field is required. |
||||||||||||||||
LastName |
The user's last name. This field is required. |
||||||||||||||||
FirstName |
The user's first name. This field is required. |
||||||||||||||||
Password |
The user's password. If you do not supply this fielde, the default password will be inserted as the user’s password. The default password is controlled using the ImportDefaultPassword manage property.
|
||||||||||||||||
PasswordResetType |
Specifies what type of password changing restrictions are allowed. Options are:
|
||||||||||||||||
EmailID |
The user's email address. This field is optional but it is recommended that you specify the email address.
|
||||||||||||||||
MiddleInitial |
The user's middle initial. |
||||||||||||||||
Address |
The user's address. |
||||||||||||||||
City |
The user's city. |
||||||||||||||||
State |
The user's state. |
||||||||||||||||
Zip |
The user's zip or postal code. |
||||||||||||||||
Country |
The user's country. |
||||||||||||||||
Phone |
The user's phone number. |
||||||||||||||||
Hire Date |
The user's date of hire. The format must be specified as YYYY-MM-DD. |
||||||||||||||||
LangPref |
The language preferred by the user. Options are:
|
||||||||||||||||
SubOrg 0-15 |
Values for the custom fields that were defined when the organization was added. This field is optional but it is recommended that you specify sub-org data. For detailed information about defining Sub-Org fields, see Adding an organization.
|
||||||||||||||||
GuestFlag, InstructorFlag, ReporterFlag, and ActiveFlag |
Values for True or False presenting the user's privileges. This field is optional but it is recommended that you specify these flags when appropriate.Use "y", "yes", or "1" for True. Use "n", "no", or "0" for False.
|
||||||||||||||||
TermsOfUseAccept |
The date when the user accepted the Terms of Use policy. Depending on the database you are using the time might also be exported. |
||||||||||||||||
Personal Info 0-15 |
Values for the custom personal information fields that were defined when the organization was added. For detailed information about defining personal information fields, see Adding an organization. |
||||||||||||||||
CurrPermissions |
Values representing the user's curriculum permissions. This field is optional but it is recommended that you specify the curriculum permissions. Specify the values as follows. If allowing more than one value, separate each with commas.
|
||||||||||||||||
CoursePermissions |
Values representing the user's course permissions. Specify the values as follows. If allowing more than one value, separate each with commas.
|
||||||||||||||||
UserPermissions |
Values representing the user's permissions. This field is optional but it is recommended that you specify the user's permissions. Specify the values as follows. If allowing more than one value, separate each with commas.
|
||||||||||||||||
ReportsTo |
Reporters to be assigned to this student |
||||||||||||||||
UserNotes |
Notes to be associated with the user |
||||||||||||||||
CurrID |
Curriculum ID of the curriculum into which the student should be enrolled |
||||||||||||||||
CourseID |
CourseID of the course into which the user should be enrolled.
|
||||||||||||||||
SessionID |
SessionID of the session into which the user should be enrolled |
||||||||||||||||
EnrollDate |
Enrollment date for the course or curriculum, The format must be specified as YYYY-MM-DD. |
||||||||||||||||
PassDate |
Date on which the CourseStatus change is applied. The format must be specified as YYYY-MM-DD. |
||||||||||||||||
CourseStatus |
The user's status of the course. This can be any valid SCORM course status (including blank), such as:
|
||||||||||||||||
Score |
The user's score of the course or session. |
||||||||||||||||
Comment | The comment you would like to make in the grade book as to why you changed the grade. | ||||||||||||||||
MergeOldID |
Old ID that should be merged into the student ID |
||||||||||||||||
MergeEmailNotify |
Email address of person to notify of success/failure of merge |
||||||||||||||||
RecordDate |
Date on which the CourseStatus change is applied. The format must be specified as YYYY-MM-DD. |
||||||||||||||||
ScoreComment |
A gradebook comment regarding the score or status for a session |
||||||||||||||||
MobileUser or MobileUserFlag |
Indicates that the student is authorized to use CourseMill Mobile features |
||||||||||||||||
MobileUserActivation or MobileActivation |
The user's mobile user activation code |
||||||||||||||||
WCAG |
Enables the WCAG/Section 508 features. Specify "Y" or "1" to enable the feature or "N" or "0" to disable the feature. For details about CourseMill's WCAG/Section 508 features, see Enabling WCAG/Section 508 Compliancy. |
|
For the Accepted Terms of Use date, the system can force students to re-accept the Terms of Use policy at any time by resetting this value with the student's profile (based on the setting of the system property RecordTermsOfUseDateForExistingUsers). |
To process the tab-delimited file:
Open the Users side-tab and click Manage Users.
Use the fields in the search window above the results table to filter the list of organizations. Use the fields as follows:
Search Field | Description |
Org ID | Org ID with which an organization was added. |
User ID |
Enter any combination of letters and numbers to search for users that contain that combination in the user ID. |
First Name | Enter any combination of letters and numbers to search for users that contain that combination in the first name. |
Last Name | Enter any combination of letters and numbers to search for users that contain that combination in the last name. |
Include Inactive | Enable this check box to include inactive users in the results. |
Enter any combination of letters and numbers to search for users that contain that combination in the last name. | |
More Options | Click this to display more search criteria items if sub-org settings have been defined, such as Region, Department, Location, and Job Title. |
Click Batch User Data.
On the Batch User Data window, specify the org ID, select Import User Data in the Batch Operation field, and click Browse to navigate and select the file. To run an error check on the tab-delimited file before processing it, select Error Check Data in the Process Data field. To process the file, select Error Check Data in the Process Data field.
Click Process.
If user records already exist, the information will be updated according to the information in the file. Passwords are not changed.
Support | About ELB Learning
© ELB Learning 2022