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

email

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

Was this article helpful?
0 out of 0 found this helpful