Administrators can add or remove users from user groups in bulk via the User Group Data Loader. To get started, you can download a CSV file template and populate the required fields offline in a spreadsheet application or text editor. The LMS provides information to help you fill in the CSV template, such as the expected values for each field.
You can add or remove users via the data loader only by specifying their User ID. This is not an ideal method of selecting users for adding or removing. It may be easier to select users based on the various criteria available in the New or Edit User Group pages.
The CSV file required by the User Group Data Loader has the following three fields, all of which are mandatory when adding users to a group, or removing them:
If the user group you want to add users to doesn't exist, and you want the LMS to create it and add the users to it, select the Create any new user groups found in the CSV file check box on the User Group Data Loader page.
To import user group data, your user role must have unrestricted access to the User Group Data Loader feature in System Roles (Manage Features > User Manager Features).
To import user group data and review previous imports, go to Manage Center > Users > User Group Data Loader.
To prepare a user group CSV file for import, you can download a template CSV file from the User Group Data Loader page and populate the fields as required.
Note that CSV files are likely to be opened by Microsoft Excel if it is installed on your system. If you encounter any problems with importing a CSV file into the LMS, it could be caused by Microsoft Excel applying extra formatting to the file. Alternatively, you can edit CSV files in a text editor instead of Microsoft Excel. The data should conform to the formatting required by the template as specified in the corresponding CSV Formatting Help.
If the values for text area fields include punctuation, these fields must be enclosed in double quotation marks (" "). Do not include commas or semicolons in other fields as they could be interpreted as a field delimiter (depending on your choice of delimiter at import).
Additional Information