It is possible to enter participants individually, but it is a lot easier to upload them from a previously prepared spreadsheet. So let us zoom in on how to upload participants.
How to prepare your spreadsheet?
You can have a spreadsheet with any column name and order, but if you would start from scratch, it is recommended to choose the following column names:
|Bib*||First Name*||Last Name*||Gender||Category*||Tags||Club||Country|
Remember that in RaceGorilla:
- Bib numbers do not have to be unique, except when used in combination with the keypad entry at the finish (It is recommended in general to have unique bib numbers). Bibs can also contain characters.
- Gender has to be either male, female or mixed
- The category must exactly match the category in you RaceGorilla Competition
- Tags can be anything you choose to make an extra indication of a participants status, such as U23, HC, or Suit or Skin. If a junior goes into the elite race using a swimsuit you can separate the two tags by a semicolon: U19;Suit.
- Country must exactly match the list of countries in RaceGorilla (in English)
In the RaceGorilla dashboard
The RaceGorilla dashboard can be entered using the same login and password as used when entering the app.
After opening your competition you’ll see the settings screen and a menu to the left.
By default your competition is in of the type “Demo”. Demo mode offers full functionality up to 10 participants. This should be enough for you to practice using the software. More about these setting can be found in the dashboard tutorial and at the pricing page.
Uploading the participants
As stated earlier, the category names of your upload file have to exactly match the categories in your RaceGorilla competition. So you’ll first have to set the categories. By default the categories Men and Women are used in most pre-set formats.
After setting the categories, go to participant list. In the upper right corner you can choose upload participants.
Then its up to you whether you want to upload a fileo or just copy paste a selection of participants.
As an example You can just copy paste this table including the headers:
|Bib||First Name||Last Name||Gender||Category||Tags||Club||Country|
|9||Michiel||Stock||mixed||Women||Red Sox||United States|
After pasting the table into the designated area and tapping next to accept the data. You have to assign each column of your data file to the correct RaceGorilla data format. As the columnheaders already match the RaceGorilla columnames, in this case it is a matter of assigning the correct column by tapping save. The team name could be skipped. if you want as it is empty.
After tapping “verify data”, a screen is shown indicating the number of records that will be imported. Here is to show what happens when a certain item does not match:
The category Pre-runners is unknown to the RaceGorilla. You can still submit the data and only 8 participants will be imported. The best solution is to go back to add the Pre-runners category and upload the file again. If you want you can edit here and assign the pre-runners to either Men or Women category.
Uploading a file works largely similar to the copy paste process. You can upload .CSV, XLS, XLSX. Be aware that only the first sheet of the excel file is imported and that all rows / columns containing data are being imported (if the data is correct)