User Data Loader Validation

Use the information below to help you resolved errors when importing user data.

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. 

Adding New Users

When adding new users:

• Ensure that the data contained in the CSV file conforms to the formatting required by the template. Do not insert commas as these will cause subsequent data to be treated as a separate column.
• If a new user is to be assigned to a particular organization structure, ensure that the entire organization hierarchy is included in the CSV file. This could be a new or existing structure. For example, in an organization with four levels, you must include specifications for levels 1, 2, 3, and 4. You may not omit definitions for intermediate levels (that is, levels 2 or 3).
• If an organization structure is not specified (that is, levels and descriptions are left blank), the user profile organization structure will be used if the option to use a profile has been selected. If a profile is not used, the user will be created with an organization structure of Unassigned.
• If an organization description for a particular level is entered but the corresponding description code is not, the organization level will not be added. A warning message will appear in the log file.
• When adding a new user, the mandatory fields are: Action, UserID, FamilyName, GivenName, Password.
• The length of the password field is specified in the system configuration settings.
• If the password field is left blank when adding system defaults, the system default password will be used.
• If you use a profile during a data upload, the password defined in the profile will be used.
• Personal Title: the LMS will check the format of this field to ensure that it complies with one of the valid, predefined titles (for example, Mr., Mrs., Dr.). If the personal title specified in the uploaded file does not match one of the predefined titles, it will default to NONE.

Updating Users

When updating users:

• Ensure that the data contained in the CSV file conforms to the formatting required by the template. Do not insert commas as these will cause subsequent data to be treated as a separate column.
• Profiles are not used when updating existing users even if the option is selected.
• Incorrectly formatted records will be rejected as invalid data.
• When updating the only mandatory fields are: Action and User ID.

Table: User Data Validation

Error	Corrective Action
Invalid User ID format	Ensure that all User IDs do not exceed the maximum length of 85 characters, that there are no spaces, and that only valid alphanumeric characters are used.
Adding users to other organizations is not allowed	Log in as System Administrator to import the data or disable the Enforce Partitioning by Level 1 Organizations system configuration setting.
Assigning users to an inaccessible organization is not allowed	Log in and import with a system role that has Role with Highest Organization Level Visible higher than or equal to the organization level that users are being moved to in the file.
Updating users from an inaccessible organization is not allowed	Log in and import with a system role that has Role with Highest Organization Level Visible higher than or equal to the organization level of the users being updated.
Creating organizations in an inaccessible area is not allowed	Log in and import with a system role that has Role with Highest Organization Level Visible higher than or equal to the organization level that is being created via the upload.
Deleting users from an inaccessible organization is not allowed	Log in and import with a system role that has Role with Highest Organization Level Visible higher than or equal to the organization level of the users being deleted.
Multiple assignments found for User ID: 'X', please specify an Assignment ID	Identify X's assignment ID that should be used and insert it in the appropriate column with the required format.
More than one special character	Remove this value to allow the rest of the row to be processed. Configure the property manually in the LMS.
Additional Role Column Format Incorrect	Check the values in the AdditionalRoles, AssignRoles, and UnassignRoles columns are in the required format.
FAILED. The importer (User ID "{user ID}") does not have permissions to add the User Role ID "{role ID}"	Ensure the user account importing the new Role ID has a system role with unrestricted access to the Role Permissions feature.

User Data Loader Field Reference

Import User Data

About the User Data Loader