Import Errors - Causes and Solutions

These guidelines are organized by the sequential stages of the Import Profiles process:

Tip: Be sure to correct data changes in your student information system, LDAP server, and any other data sources to avoid inconsistencies.

Make sure you saved the roster file to .CSV (comma delimited) format.
If still an issue: Try copying all rows of your roster file into a blank spreadsheet file, because your original file could be corrupted.

In your roster file, make sure:

Required columns are completely filled.
User names avoid invalid characters.

Example: mary+jones (+ is invalid)

Invalid characters are listed on the first tab of the template.
The date format is correct:

Example: 01-01-2000 (dashes should be slashes—1/1/2000)

Import errors you might see: "Date of Birth must be a valid date"
All columns and the top heading exactly match the template you downloaded on the MAP homepage.

Example:

Import errors you might see: It varies, but involves several incorrect values (like "Value is too long"), because your data does not follow the expected column order.

Tip: For persistent import errors, you can try removing the heading (row 1) and re-importing.
Information is not repeated by accident.

Example:

Import errors you might see:
- "User Name cannot be the same for more than one Instructor ID"
- "Last Name must be the same for this ID"

Tip:

Group errors:

Example: Ethnic group name is "Caucasian" in the roster file, but "White" in the MAP custom name preferences

Solution: Either correct the incoming records, or request a change in the MAP preferences by contacting your System Administrator or Assessment Coordinator.
Individual errors:

Example: Student name is "Fredrick Smith" in the roster file, but "Fred Smith" in the existing MAP records

Solution: When prompted in the import process, either accept the existing record's spelling, or update the existing record, or choose to create a new, unique record.

Related Links