I'm receiving an error when trying to bulk import
Posted by Marney Shepherd on 18 February 2016 08:44 AM
Getting an error when importing data? Take a look below for some answers to our most common queries.
The majority of error messages encountered during the bulk import process are as a result of missing mandatory data fields or incorrectly formatted data. This type of error is very informative as it will advise you the row number which is affected and also what information is required, examples are:
Row 25 - Birthdate not entered
Row 41 - no level entered
Row 120 - gender not entered
Row 121 - transfer/multi-athlete required (indicating this athlete exists at another club and you either need to transfer or complete a multi-athlete form)
If you receive an error message that indicates "Cannot find spreadsheet column" as per the below, this means your excel file does not have the header row included. You can copy and paste this from the blank template if needed. All imports must have the header row as this is how the system ensures your data is in the correct order.
Cannot Find Spreadsheet column: FirstName
Cannot Find Spreadsheet column: LastName
Cannot Find Spreadsheet column: MiddleName
One of the least common errors is a more general error as per the below. This usually appears when there are "extra columns", "extra rows" or "hidden" formatting. This can result from a copy and paste process from other data sources, sometimes if you clear data, rather than deleting the entire rows, or if you have highlighted or formatted data which confuses the import process.
The following error has occurred while processing your request:
There are a two steps to take if you receive this error, which will resolve the majority of issues.
1. Highlight the entire excel file (click in the top left corner), then ensure you select "no fill" in the cell highlighting tool, white fill can confuse the import.
2. Click on the row number immediately below your last row of data. Hold down the shift key, press "end" then the "down arrow" on your keyboard. This will highlight all rows in the excel file below your rows that contain data. While everything is highlighted, right click on your mouse and select delete. This deletes any potential hidden data or formatting in your file that is not within your data rows itself.
3. Click on the cell Z1. Hold down the shift key, press "end" then the "right arrow" on your keyboard. This will highlight all rows in the excel file beside your columns that contain data. While everything is highlighted, right click on your mouse and select delete. This deletes any potential hidden data or formatting in your file that is not within your data colums itself.
If you still experience any import issues, please submit a support ticket including the file you are trying to upload and a copy/screenshot of the error message you are receiving and our support team will take a look and provider further assistance.