Error Messages that appear to help diagnose why an import has failed
If you import in date and there is existing data (a duplicate), you mapped across the dates incorrectly, there is a duplicate column name, or a required field data is missing the import will fail or some records will not be imported. The following steps show you the messages that appear based on the problem.
"Error please ensure all columns names are unique". A column name is duplicated on the file you are importing and the system will specify which columns they are
If you selected an incorrect date format an "Error with date in column Date" will appear. NO records will be imported
If you see this message, it means you selected an incorrect date format when you were matching the dates in your csv file to a date format in the system. Import the original file again, and ensure you Test the Date field before you import (as shown below).
Test the date format before you import
"Required Item was Blank" tells you that a Required field is not entered and NO data will be imported
When a field in an Event Form is set on a "Required field" you cannot save the form unless you have entered data into this field. Subsequently, if you try and import in new data and a Required field cell is blank, you will not be able to import in any data. All cells in a field that is a Required Field (in this example it is 3RM Back Squat) need to be filled. You may need to fill down the data if you are importing in data with a table in it, or if you do not have the data, ask your system builder to check whether this field should be set to required. You will not be able to import in any data from that sheet unless you have all of the required field cells with data in them.
A duplicate already exists on the system. Any data which is NOT a duplicate will be imported.
A duplicate already exists on the system and you haven't ticked "Import data that appears to be a duplicate of an existing record?" then any duplicate data will not import.
The Error report here says that "A duplicate already exists" and the record is shown. However, 3 out of the 5 records that were imported were imported in successfully as they were not duplicates.
You can click on "Download Import Results to get a list of any duplicates that were NOT imported (as shown in the image in the step below).
If any other error messages appear or you are not sure about why the import failed please write in your questions here or contact your distributor.