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


40m=40
50m=50
55m=55
60m=60
80m=80
90m=90
100m=100
200m=200
300m=300
400m=400
600m=600
800m=800
1000m=1000
1500m=1500
One Mile=Mile
3000m=3000
Two Miles=2M
5000m=5000
10,000m=10000
Half Marathon=HM
Marathon=Mar
2000m Steeplechase=2000S
3000m Steeplechase=3000S
60m Hurdles=60H
80m Hurdles=80H
100m Hurdles=100H
110m Hurdles=110H
400m Hurdles=400H
High Jump=HJ
Pole Vault=PV
Long Jump=LJ
Triple Jump=TJ
Shot Put=SP
Discus Throw=DT
Weight Throw=WT
Hammer Throw=HT
Javelin Throw=JT
4 x 100m=4x1
4 x 200m=4x2
4 x 400m=4x4
4 x 800m=4x8




EVENT STAGE (EventStage):


Possible values:

Qualification

Preliminary

Heat

Semi-Final

Final




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


Master
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



School
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