Applies to: Onsite Events
Some events may capture scores from an external source, such as a chip timing system, aquatics timing system, Concept 2, etc.
This is especially when you're capturing results from a large volume of athletes such as a 5K run and quickly upload those results into Competition Corner.
First you'll need to turn the import option on. Go to Scoring Setup and set Import Scores to Use
Next, export your Athlete list, by going to Reports and export your Athlete List. At minimum, you should include the following columns: Athlete/Team Name, Division, Gender, and ParticipantID.
You'll provide this 'master' list to the 3rd party software to capture the results. If you're working with a chip company, they usually import this list in and then assign a bib number to each athlete.
A few important notes:
It's very important that you provide the 3rd party company an export from Competition Corner to ensure they have an exact master list of your athletes.
The ParticipantID is the unique ID for each athlete, it's important this data point is provided with the results file in order to properly import the scores back to the correct athlete
Open the file and do a quality check!
Remove any DNF or DNS scores, those will not import into the system. You will have to manually DNF the athletes after the import
If you're importing a timed event, make sure the time is in a HH:MM:SS.mmm format, for example 5 minutes 10 seconds should be 00:05:10.000
If you're importing a non-timed event, such as distance, weight, calories, repetitions, make sure your results are all numbers
Once everything checks out, save the file in a CSV format.
Go to Manage Scores
Click Import Scores
Select the workout
Type the exact column name of the ParticipantID from the CSV file
Type the exact column name of the Athlete's Score from the CSV file
Browse for the CSV file containing the scores
Once scores are imported, the only way to reverse it is to individually clear the Athlete's score, so make sure you did your quality check before importing.
If you notice a mistake after your import, you can edit the score directly in the system or you can correct the discrepancy in your import file and re-import.
Common Error Codes:
ID="XXXX" already exists
Your file has a duplicate ID number, you will need to reconcile that in the source file before you attempt another import.
Invalid Time Format
Make sure the time is in the format of HH:MM:SSS.mmm