|
|
|
Administrators can add, update and delete users in bulk via the User 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. For more information, see User Data Loader Field Reference.
When adding a new user, the mandatory fields are:
When updating users, the mandatory fields are Action and UserID.
Assign a value of NONE to clear the value from a field.
To import user data via the User Data Loader, your user role must have unrestricted access to the User Data Loader feature in System Roles (Manage Features > User Manager Features).
To import user data and review previous imports, go to Manage Center > Users > User Data Loader.
To prepare a user CSV file for import, you can download a template CSV file from the User Data Loader page and populate the fields as required, or you can run report R109 - Generate User Data Dump in CSV Data Uploader Format - to export users to a CSV file and update the field values. The CSV file template you download from the User Data Loader page includes any user attributes and user attribute extensions (prefixed with UA-).
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
