The Batch Import Enrollment function in the system will add new enrollments or edit existing enrollments using a .csv file. Only Administrators can perform a Batch Import Enrollment.
This article includes the steps to create the .csv files and the steps to perform the batch import after logging in to the school or program domain. For more information on enrollments, please visit Manage Course Enrollments. A link to the Batch Import Enrollments Template Excel file can be found at the bottom of this page.
To Add New Enrollments and Create a Batch_Import_Enrollments.csv File
Note: End Date is mandatory. If an invalid date format error message displays, ensure dates are in YYYY-MM-DD order instead of MM-DD-YYYY.
1. Complete the csv file. (linked at the bottom)
2. From the Domain home page, open the Actions drop-down menu and select Import enrollments.
3. Choose your csv file or cut and paste the information into the field provided..
Note: Enrollments for usernames that do not exist will not import and or be selected. Do not select the option to Allow duplicate enrollments. Each user should be enrolled only one time in a given course.
- Select Next.
- Validate your data, fixing any errors.
- Import your data by selecting Import.
To Change the Status of Enrollments for Inactive Enrollments
Administrators may need to change the status of an enrollment, especially staff personnel. A .csv file can be used to edit the enrollment status in one action for more than one user. To change the enrollment status, the administrator must know the Enrollment ID for each user and course enrolled.
- Select Users from the Main Menu, then Filter to find the student’s name.
- Select the student’s User ID.
- Find the student’s enrollments that need to be adjusted. The Enrollment ID is in the first column.
- Create an Excel file that will contain three values, Action, Enrollment ID, and Status.
- Under Action, enter Edit.
- Under Enrollment ID, enter the user’s Enrollment ID found in step 3 for each course.
- Under Status, enter the desired new enrollment status. Common choices are Withdrawn, Completed, or Inactive.
- From the Admin App homepage, select the Actions menu.
- Select Import Enrollments and either upload the saved spreadsheet or copy and paste the values from the .csv file into the box.
Importing Course Enrollments in Bulk Process - Support Video