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 will need the following columns (the ones in red are mandatory columns):

Notes:

- An example of a CSV-file is attached to this article at the bottom of the page. 

- If you are using the PZLA uploading functionality, then use the CSV file directly from PZLA. 


EntryId - All athletes and relay teams are numbered sequentially for each meeting (see example below).

StartListId - All start lists can be numbered in groups with a unique number for each event list. This column is only relevant for mixed start lists.

RelayTeamName - The name of the relay team.

FullName - The athlete's full name. Note: 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 would like 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). You can find the abbreviations for all countries that are members of World Athletics at https://www.worldathletics.org/about-iaaf/structure/member-federations 

SchoolGrade - The athlete's grade (only for school meets in the United States). You can find the grade's codes below.

DateOfBirth - The athlete's date of birth which has to be in the format of YYYY-MM-DD. Note: 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).

EventStart - The start time of the event. This can be left blank and set after import in Roster Athletics. If added then the format has to be YYYY-MM-DD HH:MM:SS (e.g., 2020-02-14 15:55:00) 

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, Preliminary, Heat, Semi-Final, or Final. This can be changed 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 ".". The 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.



Remember to not use special characters in the CSV file (i.e., , /comma/, ; /semicolon/ or /quotation mark/).

 

After all of the athletes are saved in your Excel spreadsheet you will need to save it to a CSV format. Note: 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 start lists button and then choosing Roster format.



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 isn't an exact match, so check to make sure it is the correct athlete.

= There is a conflict so you will need to select the athlete that is the correct athlete to match with. If the correct athlete is not found, you will have to create a new athlete (or relay team). Action required by the user! See below.



Remember to resolve all conflicts and save the start list. Note: You cannot save the start list until all conflicts have been solved (i.e., selecting the correct athlete). 


You can create a new athlete or a new relay team by clicking on the iconfor adding a new athlete/relay team.


For example, you have uploaded a CSV start list with two relay teams named "Roster Relay", but one team is number 1 and the other team is number 2. Let's say for purposes of this example that there is only one "Roster Relay" relay team In the Roster database. Therefore, both of your teams will be matched to the existing "Roster Relay" team, resulting in a conflict. To resolve this conflict, you will have to create two new relay teams named "Roster Relay 1" and "Roster Relay 2". See the screenshots below. 




SPECIAL CASE for mixed gender competitions


If you want to upload an event which is mixed gender, you will need to add Male or Female for each athlete and give all athletes the same Start List ID (StartListId). In doing so, the start list will be uploaded as a mixed event. See the example below.



---------------------------------------------------


Use the following codes for events and age groups:


EVENT CODES (EventCode):


Event name = code for 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
5km=5K
10,000m=10000
10km=
10K
Half Marathon=HM
Marathon=Mar
1500m Steeplechase
=1500S
2000m Steeplechase=2000S
3000m Steeplechase=3000S
60m Hurdles=60H
80m Hurdles=80H
100m Hurdles=100H
110m Hurdles=110H
200m Hurdles
=
200H
300m Hurdles=300H
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
3000m Race Walking
=
3000W
5000m Race Walking
=5000W
10,000m Race Walking=
10000W
10km Race Walking
=10W
20km Race Walking=20W
50km Race Walking=
50W
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 CSV file


Multiple
Multiple age groups = Multi














Youth and senior
U8 = Meeting_8
U10 = Meeting_10
U12 = Meeting_12
U14 = Meeting_14
U16 = Meeting_16

U18 = Meeting_18

U20 = Meeting_20

U23 = Meeting_23

Senior = Senior


Master
M30 = Master_30
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




Remember that when you choose the Multi age group, you can select the individual age group of each athlete after importing the start list in the start list view.



GRADES (SchoolGrade):

School grade = code for the CSV file


Kindergarten = K

1st grade = 1

2nd grade = 2

3rd grade = 3

4th grade = 4

5th grade = 5

6th grade = 6

7th grade = 7

8th grade = 8

9th grade = 9

10th grade = 10

11th grade = 11

12th grade = 12

Freshman = FR

Sophomore = SO

Junior = JR

Senior = SR