You can use XLSX or CSV file to import athletes and competitions to our system.
There are 4 options with slightly different files format:
- Import athletes for one competition (category) at the stage page.
Import athletes and competitions list for whole discipline at the event page.
Import athletes database at the settings page of the event.
Import delegation to the accreditation system
To see some of it in action check out this video:
Continue reading for more information.
Import athletes for one competition at the stage page
Go to the Live scoring of any competition (category) and click Edit.
Click "Import from CSV or XLSX at the bottom of the page".
File format for this page:
You should not use headers in the first row of the file. Just fill in athletes data.
N | Column | Type | Description | Format | Example |
1 | Surname | required | Athletes surname | [string] | Bruce |
2 | GivenName | required | Athletes name | [string] | Willis |
3 | Representing | required | Team name. Can be country and club, separated with comma |
[string] or [string, string] |
RUS USA, Mega Tramp |
4 | DateOfBirth | optional | Date or year of birth. | [yyyy] or [yyyy-mm-dd] |
2002 2002-06-12 |
5 | Group |
optional |
Group number. If group does not exists import will create it. | [number] | 1 |
6 | Ranked |
optional |
If this participant will be ranked. Should be string. Default 'true'. | 'false' or empty | false |
7 | Team |
optional |
Team id. Number from 0..29. Required to combine executions to team results | [number] | 5 |
8 | NumberInTeam | optional | Number of athlete inside the team. For TRA usually 0..3. | [number] | 0 |
9 | Description | optional | Text field for additional information. For usage see this support article: «description» field for compulsory routines |
[yyyy] or [yyyy-mm-dd] |
2002 2002-06-12 |
10 | ExternalID | optional | Number that can be used to connect athlete with external system (i.e. FIG ID) | [number] | 77777 |
You can omit optional columns or some of the optional values. If you will omit some of the required values the athlete will be skipped.
Import athletes and competitions list for whole discipline at the event page
Go to the main event page of any competition (category) and click Edit.
Click "Import from CSV or XLSX at the bottom of the page".
File format for this page:
This is very similar to one above, only with addition of first column:
N | Column | Type | Description | Format | Example |
1 | Competition | required | Name of the competition or category where athlete will participate. If there is no such category new one will be created. Athlete will be inserted in the first stage of the competition. | [string] | G15-16 |
Import athletes database at the settings page of the event
Go to the settings page of the event.
Click "Import from CSV or XLSX at the bottom of the page".
This option is usefull to load your athletes database to use with autocomplete when registering athletes manually.
File format:
The fields and the description are similar to Stage page (but less columns are supported).
Import delegation to the accreditation system
Press edit and Choose file.
This import would not work for the events with mandatory photos. For some of the events options and values can be different.
File format:
N | Column | Type | Description | Format | Example |
1 | Surname | required | Athletes surname | [string] | Bruce |
2 | GivenName | required | Athletes name | [string] | Willis |
3 | DateOfBirth |
required |
Date or year of birth. | [yyyy] or [yyyy-mm-dd] |
2002 2002-06-12 |
5 | Sex |
required |
Person Sex (male or female) | 'male' or 'female' | male |
6 | Role |
optional |
The string identifying for the person role in the competition.
Default is gymnast ("G").
|
[string] from list from "descripion" |
J |
5 | Transport |
optional |
Transport category ('T1', 'T2', T3') as per FIG accreditations rules. Default is 'T3'. |
'T1' or 'T2' or 'T3' | T2 |
6 | VIP |
optional |
Is VIP. Default false. | 'true' or empty | true |