Import users into a group using a CSV or XLS file. System administrators can import enrollments for groups across their organization. Group administrators can import enrollments for groups they manage.
-
Members can be enrolled in one group at a time.
-
Media album tags are not supported in groups containing more than 1,000 members.
Import file requirements
The XLS or CSV file for import must contain the required fields.
|
Field |
Requirement |
Description |
|---|---|---|
|
User Unique ID |
Required* |
Identifies the user to enroll. This is typically a school ID or SIS ID. |
|
Username |
Required* |
Identifies the user to enroll. |
|
Email Address |
Required* |
Identifies the user to enroll. |
|
Enrollment Type |
Optional |
Include this field if the file contains both group administrators and group members. |
Group enrollments considerations
Permissions
System administrators can import enrollments for all groups in their organization. Group administrators can import enrollments only for the groups they manage.
The Import group enrollments permission is available only when the Manage roster permission is enabled. Disabling Import group enrollments does not disable Manage roster.
Enrollment types
Enrollment Type determines whether a user is enrolled as a group administrator or group member.
If all users in the file have the same enrollment type, select that enrollment type during import. If the file contains both group administrators and group members, include the Enrollment Type field in the import file.
Use the following values:
|
Value |
Enrollment Type |
|---|---|
|
1 |
Group admin |
|
2 |
Group member |
Select users
If you need a list of users for the import file, export users by selecting Export and choosing Users. Filter the file to include only the users you want to enroll.
When exporting users, consider including:
-
First Name
-
Last Name
-
Email Address
-
Role
-
Building
-
Enrollment Type
Clear existing enrollments
The Clear existing enrollments before import option removes existing enrollments from the selected group and replaces them with the users in the import file.
When a user is re-added to the group, content previously created by that user in the group is restored.
You can clear:
-
Only group administrators by importing an Admin enrollment file.
-
Only group members by importing a Member enrollment file.
If the import file contains both group administrators and group members, existing users not included in the file are removed from the group.
Import group enrollments
Select file
-
Select Tools and choose School Management.
-
Select Import.
-
Select Group Enrollments.
-
Configure enrollment type options.
-
Select the group to update.
-
Optionally, select Clear existing enrollments before import.
-
Upload the CSV or XLS file.
-
Select Upload File.
Match columns
-
Match each Schoology field to the corresponding column in the import file.
-
Verify the column mappings.
-
Select Preview.
Preview and confirm
-
Review the import preview.
-
If errors occur, verify that the User Unique IDs, usernames, or email addresses in the import file match existing users in your organization. You do not need to correct every error before continuing. As long as the file contains at least one valid row, the import can proceed, and valid additions or removals are applied.
-
Select Confirm to complete the import.