Skip to main content

What to do with your import file warnings

Keeping your learner data in tip-top condition!

D
Written by Dave Branscombe

There are a few reasons why you might have arrived at this particular guide:

  • you’ve imported your learners directly from another source (usually your HR platform).

  • you’ve imported people directly using a CSV file you’ve created yourself.[Link to 127 - Importing lots of people quickly with a CSV file]

  • you’ve just received an automated email with some errors and warnings, and you’d like a gentle steer in the right direction.

When learners are imported into the system, we track the goings on in an error log. Here’s what you should know.

Go to your Learners menu and pick Import Learners:

Look for your previous imports, in particular those that have multiple logs showing. Pick View:

You’ll see a summary of the errors and warnings generated and on which lines of the CSV they file apply (so you can go back and fix the CSV file):

Here’s what the errors and warnings mean and what you should do next:

  • Null FirstName processed – your CSV file didn’t have any data for the learner’s first name. Whilst displayed as INFO, the learner’s data will not import until this is corrected. This must be corrected in the CSV file and uploaded again.

  • Null LastName processed – your CSV file didn’t have any data for the learner’s surname. Whilst displayed as INFO, the learner’s data will not import until this is corrected. This must be corrected in the CSV file and uploaded again.

  • No default UserType set. Record processing aborted. – your CSV file was missing the old UserType data from column 2. The learner’s data will not import until this is corrected. Update your CSV file with some data e.g. “Staff” and upload the CSV file again.

  • Org1Name not specified. Record processing aborted. – your CSV file is missing important location data. The learner’s data will not import until this is corrected. Update your CSV file with the correct location data for this person and upload the CSV file again.

  • Org1Name ({missing location stated here}) not found. Record processing aborted. – your CSV file has included location data which has not been added to the learning platform yet. The learner’s data will not import until this is corrected. Update the learning platform organisational data with the correct location data for this person and upload the CSV file again.

  • Invalid DOB processed. – your CSV has included the learner’s Date Of Birth but the date format is not in dd/mm/yyyy format e.g. 30/04/2026. Whilst displayed as INFO, the learner’s data will not import until this is corrected. Correct the date formatting in the CSV file and upload it again.

  • Invalid CompanyStartDate processed. – your CSV has included the learner’s Joining Date but the date format is not in dd/mm/yyyy format e.g. 30/04/2026. This is not a critical error, the importer will ignore the invalid date formatting and process the new starter and use today’s date as the joining date. Ideally you should correct the date formatting in the CSV file and upload it again.

  • Invalid LeavingDate processed. – your CSV has included the learner’s Leaving Date but the date format is not in dd/mm/yyyy format e.g. 30/04/2026. This is not a critical error, the importer will ignore the invalid date formatting and process the leaver and use today’s date as the leaving date. Ideally you should correct the date formatting in the CSV file and upload it again.

  • New jobType ({new JOB Code stated here}) created with default user profile. – your CSV has included a new Job Type that we’ve not seen before, so we created it for you automatically! Remember to update this new Job Type so that the correct learner profile, tools and reporting access is applied.

  • Unable to create and assign jobType. Record processing aborted. This will depend on how the importer was configured and it means that unfortunately the new job type was not created automatically and your new learner’s record was not created. The learner’s data will not import until this is corrected so add this new Job Type manually and then upload your CSV again.

Did this answer your question?