Importing Participants

You must import MileSplit Athlete IDs and team IDs before you can submit results to MileSplit. If those IDs are missing in RaceDay Scoring, the export file will not load in MileSplit.

Those IDs come only from MileSplit’s own entry file. Do not build the participant list from another spreadsheet if you need to send results back to MileSplit.

Import that CSV into RaceDay Scoring. The athlete ID is stored in External Reference ID on the participant. The team ID is stored in External Reference ID on the team. That is the same External Reference ID field used for RaceRoster, TFRRS, and DirectAthletics.

After the import, confirm those fields are filled. If either is empty, stop and fix the mapping before you race. You cannot add the IDs later from RaceDay Scoring.

After registration closes on MileSplit, download the entries CSV.

1. Use this selection on the MileSplit site.

2. On the next page, click Download Entries or the Entries tab. Both go to the same page.

3. On the right, under Download all Entries, click Download to CSV at the bottom of the list. That CSV is the file RaceDay Scoring expects.

MileSplit’s site may look slightly different from these screenshots.

After you download the CSV, you can open it in Excel to add columns. Do not change the columns MileSplit already included. Add a Team Type column when the race has more than one team classification. You can also add columns such as bib number.

Use these steps for every import:

1. Download the data from MileSplit.
2. If this is not the first import, delete the current data first. On Participants, open Actions and choose Delete All Participants. On Teams, open Actions and choose Delete All Teams.
3. On Participants, choose Import and select the CSV.

After you select the file, mappings should fill in automatically. AthleteID must map to External Reference ID. Team ID must map to Race Team External Reference ID. Extra columns such as Team Type and bib number map if you added them. Do not leave those ID mappings blank.

After the data is imported, you will see the athlete ID as External Reference ID on the Registration tab. Every athlete you will send to MileSplit needs a value here:

You will see the team ID as External Reference ID when you edit the team. Every team you will send to MileSplit needs a value here:

Reporting

There is a MileSplit report section for this export. It is available on Cross Country scored events.

If any race in the meet runs boys and girls together, set Separate Report Sections By Gender to Yes in the Scored Event team scoring settings:

Create a separate report for the MileSplit export. Add a MileSplit section for every scored event you want to send. If you have more than one team type, add a section for each team type. If Separate Report Sections By Gender is Yes, the app creates a male section and a female section for you.

Keep the Score column on those sections. The export needs it.

Export the file

On the Reports list, open Export on that report and choose MileSplit.

MileSplit Export opens. For each scored event, choose the MileSplit short name. RaceDay Scoring sends the matching event code in the results file. For a 2-mile race, choose 2 Mile so the file sends 2MILE.

The app tries to pick a short name from the scored event name or distance. Confirm each choice. If it cannot guess, the list shows Select a short name until you pick one.

Export stays disabled until every scored event has a short name. Then choose Export and save the file. The default name is MileSplit.txt. Upload that file to MileSplit.

Your short name choices stay until you restart the app.

If MileSplit rejects the file

• Use Export, then MileSplit, on the report that has MileSplit sections. Do not export from a regular Team Finisher List.
• Open a participant on the Registration tab and confirm External Reference ID is filled. Open the team and confirm External Reference ID is filled there too. If either is empty, AthleteID or Team ID did not map on import, and MileSplit will say the IDs are missing. Import the MileSplit CSV again before you try to submit results.
• Confirm the MileSplit short name for each scored event. For a 2-mile race, choose 2 Mile so the file sends 2MILE. A meter value will not match in MileSplit.
• Athletes and teams that never existed in MileSplit will not match. Add them in MileSplit first, then import again so they get IDs. Adding them only in RaceDay Scoring will not give you IDs you can submit.
• If the .txt already has those IDs and the right event codes, and MileSplit still rejects the file, contact MileSplit. RaceDay Scoring cannot fix their importer.