When importing participants it is possible to receive an error message if something in your import file is incorrect. Below is a list of possible error messages with explanations and possible fixes.
Unknown column
- A column in your Excel file does not exist as a data field in your event file. You should change the column name in the Excel file to match the data field in your event file. If the data field doesn't exist, you can create a custom field in Main Window > Participants Data > Additional Fields.
- Check your import file for hidden columns. In Excel, it is possible to hide columns from view. When importing these columns are still visible. Look at the column lettering and see if a letter is missing. This will indicate a hidden column.
- Check the spelling of the column name in your import file to make sure it matches the field in RR12 you are trying to import.
- ADVANCED. You can check the box labeled "Automatically create additional fields for unknown columns". This will generate additional fields for any unknown columns. WARNING! This is not recommended as it can create unwanted data fields because of simple typos. Use cautiously!
File contains more than one participant assigned to Bib 100, which is not allowed. Please correct this problem and import again.
- This indicates you have more than one of the same bib numbers in the Bib column. The above example shows a duplicate of bib 100.
- In your Excel file, check the Bib column for duplicates. It helps to sort your file by the Bib value.
Error: Invalid col name: My Data
- This error indicates a column name that is invalid. The above example shows the field called "My Data" as invalid.
- Column names (Aditional Field names in RR12) can not contain spaces or special characters.
Bib Existing
- This error happens when you are trying to import a list of participants and mapping on a value other than Bib.
- This error indicates that one of the participants being imported has a Bib value that already exists in the event file and the mapping value does not line up.
- For example, Bib 100 exists in the event file with a mapping value of 1. You try to import bib 100 under a mapping value of 2. Bib Existing error will be thrown.