Skip to content
  • There are no suggestions because the search field is empty.

Bulk-unenrolling Users

Unenroll many users at once by processing a tab-delimited file in Batch User Data.

Bulk-unenroll users by uploading a tab-delimited file that identifies them. Before processing, you can run an error check to verify that the file is properly formatted.

Prepare the tab-delimited file

The file must conform to the following specifications:

  • Use the Tab character (Hex 0x09) to separate data items.
  • Each line must end with a carriage return/line feed.
  • The first line must contain the field names used to locate the corresponding columns within the data. Column order is not important.
  • Unrecognized columns of data are discarded.
  • Include the column names described below.

Column names

  • OrgID (required) – The user's organization.
  • ID (required) – The user's user ID.
  • LastName (required) – The user's last name.
  • FirstName (required) – The user's first name.
  • Password – The user's password. When importing a user for the first time, you can create a password by supplying this field. If you do not supply this field in the import file, the default password is inserted as the user's password. The default password is controlled using the ImportDefaultPassword manage property. On export, CourseMill provides a field for the password but does not insert it in that field.

    Note: When resetting current users' passwords, use a password other than the default password. If you do not, the password is not modified.

  • PasswordResetType – Specifies what type of password changing restrictions are allowed. Options:
    • N – Password never expires.
    • X – User cannot change password.
    • T – Password expires every xx days, where xx is the number specified in the DefaultPasswordExpiration property.
    • M – User must change password at next log in.

    Note: The user setting then switches to either N or T, depending on the value specified in DefaultPasswordExpiration. If DefaultPasswordExpiration is zero (0), it switches to N; if the value is greater than 0, it switches to T.

  • EmailID – The user's email address. 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.
  • LangDef – The language preferred by the user. Options:
    • USA – English
    • BRA – Brazilian Portuguese
    • DEU – German
    • ESP – Spanish
    • FRA – French
    • HUN – Hungarian
    • POL – Polish
    • ZHS – Simplified Chinese
  • SubOrg 0-15 – Values for the custom fields that were defined when the organization was added. Optional, but it is recommended that you specify sub-org data. For details about defining sub-org fields, see Adding an organization.

    Note: If the AddSubOrgValuesOnImport property is set to yes, any value in this column is added to the drop-down list of values for the corresponding sub-org. If the organization is set up to use sub-orgs but they are not specified in the import file, the sub-orgs are blank.

  • InstructorFlag, ReporterFlag, and ActiveFlag – Values for True or False representing the user's privileges. 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.

    Note: If ReporterFlag is set to Yes, the CC Student Emails check box is automatically checked.

  • 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 details about defining personal information fields, see Adding an organization.
  • CurrPermissions – Values representing the user's curriculum permissions. Optional, but it is recommended that you specify the curriculum permissions. If allowing more than one value, separate each with commas. Codes:
    • Cre – Add curriculum
    • Mod – Modify curriculum
    • Dup – Duplicate curriculum
    • Del – Delete curriculum
    • Reg – Register curriculum
  • CoursePermissions – Values representing the user's course permissions. If allowing more than one value, separate each with commas. Codes:
    • Cre – Add course
    • Ses – Add session
    • Mod – Modify course
    • Dup – Duplicate course
    • Del – Delete course
    • Reg – Register in course
    • Imp – Import course content
    • Gbk – Grade book
  • UserPermissions – Values representing the user's permissions. Optional, but it is recommended that you specify the user's permissions. If allowing more than one value, separate each with commas. Codes:
    • Cre – Add user
    • Mod – Modify user
    • Del – Delete user
    • Reg – Register a student
    • Imp – Import user data
    • Gbk – Grade book
    • Pwd – Change password
  • ReportsTo – Reporters to be assigned to this student.
  • UserNotes – Notes to be associated with the user.
  • CurrID (required) – Curriculum ID of the curriculum into which the student should be enrolled.
  • CourseID (required) – Course ID of the course into which the user should be enrolled.

    Note: It is recommended that the course has at least one content item.

  • SessionID (required) – Session ID of the session into which the user should be enrolled.
  • EnrollDate – Enrollment date for the course or curriculum.
  • PassDate (required) – Date on which the CourseStatus change is applied.
  • CourseStatus – The user's status of the course. Optional, but it is recommended that you specify the course status when available. This can be any valid SCORM course status (including blank), such as: Not Attempted, Incomplete, Completed, Passed, Exempted, Failed, Browsed.
  • Score (required) – 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. Optional, but it is recommended that you specify informative comments when appropriate.
  • MergeOldID – Old ID that should be merged into the student ID.
  • MergeEmailNotify – Email address of the person to notify of success or failure of the merge.
  • RecordDate – Date on which the CourseStatus change is applied.
  • ScoreComment – A gradebook comment regarding the score or status for a session.
  • WCAG – Enables the WCAG/Section 508 features. Specify "Y" or "1" to enable the feature, or "N" or "0" to disable it. For details, see Enabling WCAG/Section 508 compliance.

Process the file to unenroll users

  1. Open the Users side-tab and click Manage Users.
  2. Use the fields in the search window above the results table to filter the list of users:
    • Org ID – The 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.
    • Email – Enter any combination of letters and numbers to search for users that contain that combination in the email address.
    • More Options – Click this to display more search criteria if sub-org settings have been defined, such as Region, Department, Location, and Job Title.
  3. Click Batch User Data.
  4. On the Batch User Data window, specify the org ID, select Bulk Unenroll in the Batch Operation field, and click Browse to navigate to 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.
  5. Click Process.

Users identified in the file are unenrolled.

Related articles