About the User Profile Data Loader

Administrators can add, update and delete users' profile information in bulk via the User Profile 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. 

The user profile data imported by the User Profile Data Loader corresponds to information in users' My Profile tab of the Settings page, accessed via their Avatar menu. It does not upload user account data, which administrators access in the Profile tab of the User Editor. (To import user account data, use the User Data Loader.) Therefore, the User Profile Data Loader can only update the profile information for existing user accounts.

Specifically, you can update the following profile data:

The Action field in the CSV file dictates whether new information is added to one of these sections, or whether the data is deleted.

The Education History, Work History and Language Skills sections can contain multiple records. The delete action for those sections deletes all of the records.

To import user profile data, your user role must have unrestricted access to the User Profile 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 Profile Data Loader.

Preparing CSV Files for Import

To prepare a user profile CSV file for import, you can download a template CSV file from the User Profile 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

Import User Profile Data

User Profile Data Loader Field Reference

 

Why does the help differ from what I see on the screen?

 

Powered by PeopleFluent