Instead of adding athletes one at a time, you can add several (or all) athletes at once by using the Import CSV tool. You will find the tool in the left-hand-side of the Details page.
You can create the CSV file by organizing your athletes in an Excel spreadsheet. You need the following columns (the ones in red are mandatory columns):
- Example CSV-file attached to this article (in the bottom of the page).
- If you are using the DOMTEL uploading functionality, then use the CSV file directly from Domtel.
EntryId - All athletes and relay teams are numbered sequentially (see example below) for each meeting.
StartListId - All start lists can be numbered in groups with a unique number for each start list. Only relevant if mixed start lists.
RelayTeamName - The name of the relay team.
FullName - The athlete's full name. NB: If FullName is filled out, then FirstName and LastName are no longer mandatory.
FirstName - The athlete's first name.
MiddleName - The athlete's middle name.
LastName - The athlete's last name.
Gender - The athlete's gender (the only options are Male or Female). If you want to add a mixed relay or mixed gender competition, please see below.
CountryCode - Three-letter abbreviation of the country (e.g., USA, FRA, CHN, SWE).
DateOfBirth - The athlete's date of birth which has to be in the format of YYYY-MM-DD. NB: The Date format is very important! You can use Excel's formatting functionality.
YearOfBirth - The athlete's year of birth in four digits (e.g., 1995).
TilastopajaId - The athlete's ID for the Tilastopaja Database.
RelayId - If a RelayTeamName is added, then you can add the names of the individual runners on the team. Each individual name needs to have a number referring to the EntryID next to the Relay team name (see example below).
EventCode - Event code. See a list of event codes below. You can also write your own event codes and then match them with the Roster Athletics event codes after the import.
EventStage - Add event stage, which can be Qualification, Heat, Semi-Final, or Final. This can also be set after the import.
AgeGroup - Athlete's age group. Available age groups are listed below.
ClubName - the name of the club or school for which the athlete is competing.
TeamName - the name of the team (if it is a team competition)
BibNumber - Bib or start number for the athlete.
PersonalBest - The athlete's personal best. Dividers between cm and meter have to be a ".". Same goes for dividers between seconds and 1/100s. Dividers between hours and minutes and between minutes and seconds have to be a ":".
SeasonBest - The athlete's season's best.
After all of the athletes are saved in your Excel spreadsheet you will need to save it to a CSV format. NB: It is very important that you save the file in the UTF-8 CSV format.
You can now add the saved CSV file by clicking on the Import CSV button.
After the import you will see three different marks next to the names of the athletes:
= athlete already exists in the Roster Athletics database and an exact match has been found
= athlete matches with an athlete in the database, but it isn't an exact match, so PLEASE check it is the correct athlete.
= There is a conflict, where you need to select which athlete is the correct athlete to match with. You might have to create a new athlete (or relay team). Action required from the user! See below.
Remember to solve all conflicts and save the start list. NB: You cannot save the start list until conflicts have been solved (i.e., selecting the right athlete). You can hereafter find it under Start lists.
If a conflict doesn't have two or more options, then you will have to create a new athlete or a new relay team, which is done by clicking on the icon for adding a new athlete/relay team.
E.g., you have uploaded a CSV start list with two relay teams named "United States," but one team is number 1, and the other team is number 2. In the Roster database there (in this example) only exists a "United States" relay team. Hence both teams will be matched to this existing team. To solve this conflict, you will have to create two new relay teams, namely "United States 1" and "United States 2". See screenshots below.
SPECIAL CASE for mixed gender competitions:
If you need to upload an event which is mixed gender, then make sure to add Male or Female for each athlete, give all athletes the same Start List ID (StartListId). This way the start list will be uploaded as a mixed event. See example.
Use the following codes for events and age groups:
EVENT CODES (EventCode):
Event name = code for the the CSV file
|4 x 100m||=||4x1|
|4 x 200m||=||4x2|
|4 x 400m||=||4x4|
|4 x 800m||=||4x8|
EVENT STAGE (EventStage):
AGE GROUPS (AgeGroup):
Age group = code for the the CSV file
Youth and senior
U16 = Meeting_16
U18 = Meeting_18
U20 = Meeting_20
U23 = Meeting_23
Senior = Senior
M35 = Master_35
M40 = Master_40
M45 = Master_45
M50 = Master_50
M55 = Master_55
M60 = Master_60
M65 = Master_65
M70 = Master_70
M75 = Master_75
M80 = Master_80
M85 = Master_85
M90 = Master_90
M95 = Master_95
M100 = Master_100
1st grade = School_1
2nd grade = School_2
3rd grade = School_3
4th grade = School_4
5th grade = School_5
6th grade = School_6
7th grade = School_7
8th grade = School_8
9th grade = School_9
10th grade = School_10
11th grade = School_11
12th grade = School_12