Use Participants > Import to add people from a spreadsheet, or to update people already in the race.
The file can be a CSV or a TXT file.
Open the import
- Open the race.
- Open Participants.
- Click Import.
Choose the spreadsheet
The page heading is Add/Update Participants from a Spreadsheet.
Next to Select a Spreadsheet, choose the file.
RaceDay Scoring reads it and opens column mapping.
Spreadsheet Settings can stay as they are for a normal CSV.
- Turn on No Header Record only when the first row is a participant, not column names. RaceDay Scoring then labels the columns Column 1, Column 2, and so on.
- Automatically Detect Field Delimiter is on by default. The app uses whichever of comma, semicolon, or tab shows up most on the first row. Turn it off only when you need to type the delimiter yourself.
Map each column
The heading is Select and map columns from your spreadsheet to include in the import.
The page shows how many participants are in the file.
Each row is one spreadsheet column.
The sample under the column name is a value from that column. Use it to confirm you have the right field.
Set RaceDay Scoring field for each column you want to import.
- Name columns use First and Last. A spreadsheet heading such as First Name belongs on First. Last Name belongs on Last.
- The event column uses Registration Event.
- Auto-map matching columns fills rows the app recognizes. Clear all mappings removes every choice so you can start over.
- A note under a row means you should confirm that choice before you import.
When Add is checked, Add/Update Participants stays off until First, Last, and Registration Event are all set.
The note at the top lists whatever is still missing: “These fields are required when Add is selected.”
Set Date Format to match birthdays in the file: MM/DD/YYYY or DD/MM/YYYY.
Prevent duplicate bibs when adding new participants is on unless you turn it off.
A new row whose bib is already in the race is not added.
Add new people, or update people already in the race
Leave RunSignup Registration ID, RaceDay Scoring Participant ID, and External Reference ID empty when every row should be a new participant.
Add is checked, and Update is off.
Map one ID column when the spreadsheet should change people already in RaceDay Scoring.
Only one of those three fields can be mapped.
- RunSignup Registration ID updates participants whose registration ID matches. This import does not add anyone. Clear that mapping when you need to add people.
- RaceDay Scoring Participant ID updates rows whose participant ID matches, and adds rows that do not match. Add and Update are both checked. You can turn one of them off.
- External Reference ID works the same way for an ID from another registration system.
Team columns are Race Team and Race Team - Type.
Click Add/Update Participants when the columns look right.
Match values that are not in this race
RaceDay Scoring may ask you to match values before the import starts.
That happens when a name in the file is not already on this race.
The screen can ask you to match events, participants who have no event, corrals, team types, teams, gender, or giveaway options.
Choose the RaceDay Scoring value for each one, then click Continue.
On Map Events, a spreadsheet value such as “A” can be pointed at the event name in the race, such as “5k”.
On Map Teams to Team Types, you can click Add New Team Types, or Remove Teams and Continue if those teams should not be imported.
Start Import then shows how many participants are in the file.
Click Yes, Start Import.
After the import
CSV Import Complete shows how many participants were added and how many were updated.
If some rows could not be imported, the page says so and lists those rows.
The other rows are still imported.
Fix the spreadsheet or the column mapping, then run the import again for the rows that were skipped.
Open Participants to review the list.