The import file must be a (Coma separated values) CSV file where the first line of the file contains column names. The order of the columns is not important, but if a name is incorrect, the entire file will be rejected outright without checking the content of the individual records.
For all intents and purposes, the number of records in the file should not exceed 1000. Larger files should be broken into smaller files.
|
Column Name |
Description of Contents |
Required? |
|
lastname |
Last name of athlete |
Yes |
|
firstname |
First name of athlete |
Yes |
|
nationality |
Citizenship of the athlete. Only one nationality is possible per athlete in the import file. Must specify 2-character ISO standard codes for countries (e.g. CA for Canada; EE for Estonia, etc.) or the 3-character IOC-code.
Codes are available here |
Yes |
|
sport_nationality |
Sport nationality of the athlete. Only one sport nationality is possible per athlete in ADAMS. This is the country for which the athlete competes internationally. Must specify ISO standard or IOC standard country codes as with nationality, above.
Codes are available here |
Yes |
|
gender |
Accepted values: M, F, or X |
Yes |
|
dateofbirth |
Format is dd/mm/yyyy (e.g. 26/07/1975) |
Yes |
|
sport |
Only one sport is accepted per athlete record in import file. Specify IOC sport code (e.g. AQ for Aquatics).
Codes are available here |
Yes |
|
discipline |
Only one discipline is accepted per athlete and it must properly match with the specified sport (e.g. DV = Diving). A discipline that does not match a sport will cause the file to be rejected.
Codes are available here |
Yes |
|
if |
International Federation. This is only mandatory when the organization performing the import is not an IF (e.g. a NADO). If the importing organization is an IF, then automatically the respective organization will be populated. |
Yes |
|
rtp |
Enter the athlete's registered testing pool I = International N= National D= Other |
No |
|
competition_level |
The competition level of the athlete (athletes who are not part of the RTP, but still participate in an international or national or recreational/master competition event) I = International N= National D= Other |
No |
|
sport_event |
The sport event's code or a free text. |
No |
|
address_label |
This is the label for the address - free text, eg. "home", "mailing address". If the address label is not specified, the subsequent address details (email, street, etc.) will not be imported. |
No |
|
|
No format validity check is made. The email address, if specified, is stored in the athlete contact details. |
No |
|
street |
Street address of the athlete's mailing address. |
No |
|
city |
City of the athlete's mailing address. |
No |
|
region |
Region of the athlete's primary residence (R1). If provided, must be specified using the correct 5- or 6-character ISO code. The ISO list of valid regions is provided here. |
No |
|
country |
Country of the athlete's primary residence (R1) specified using ISO or IOC standard codes.
Codes are available here |
No |
|
postal_code |
Postal code of athlete's mailing address. No validity or formatting checks are made. |
No |
|
home_phone |
Athlete's home telephone number. (e.g. +44 208 555-2222). |
No |
|
mobile_phone |
Athlete's mobile telephone number. No validity or formatting checks are made, but the number should be specified using international format. |
No |
|
final_accreditation |
Major Event Accreditation ID |
No |
|
if_id |
International Federation ID |
No |
|
nado_id |
National Anti-Doping Federation ID |
No |