File-Based Player Contributions
- David DiStasio
- Jonathan Cohen
Overview
For bulk load of existing players who require USTA accounts, USTA offers the ability to assign a USTA number (UAID) in a csv file.
In a CSV file, each row contains an ordered sequence of column headings or values separated by commas. The commas are used to maintain file structure. Each comma in the first row (which contains the column headings) delimits a column heading and a place in the ordered sequence of columns. Commas in subsequent rows also maintain the sequence of ordered columns, so the first value in every subsequent row represents a value in the first column, the second value in every subsequent row represents a value in the second column and so on. Unlike standard sentence punctuation, there is no space after a comma.
Most values are encased in double quotes. The exception is the single-character value, such as a 1 or a 0 (zero). Enclosing the value in double quotes allows complex values such as those that contain commas to be used within a field without breaking the file structure. For example, a field that contains a series of items, such as court surfaces, might have a value like this:
"hard, clay, grass".
Please escape any special characters such as embedded quotes with a '\' (backslash) before including it in any field in the file. See Special Characters
New accounts created by partners are not visible in usta.com until the player goes in and claims their account.
File Name Convention
Player files use the following naming convention
players-[SOURCENAME]-[YYYYMMDD].csv
Where:
SOURCENAME: The contributor name assigned by USTA.
YYYYMMDD: Effective date of contribution
Column Definitions
The following table lists the fields and formats.
Player consent to USTA Terms Of Use must be collected by the contributor and submitted at true for all player contributions.
Please note the difference between address_countryIso (indicates residence) and competition_nationality_countryIso (indicates flag when integrated with international play activity).
Field | Required/Optional | Identifying | Format |
|---|---|---|---|
firstName | Required | Yes | Must be 2 or more characters |
lastName | Required | Yes | Must be 2 or more characters |
dateOfBirth | Required | Yes | YYYY-MM-DD |
gender | Required | Yes |
|
Optional | No | x@y.com | |
address_address1 | Required | No | Must be 2 or more characters |
address_address2 | Optional | No | Must be 2 or more characters |
address_city | Optional | No | Must be 2 or more characters |
address_state | Optional | No | Must be 2 characters |
address_zipcode | Required | No | Must be 2 or more characters |
address_countryIso | Required | No | |
competition_nationality_countryIso | Required | No | |
isAcceptedUSTATerms* | Required | No | True/False*
|
Example
PLAYERS-ACTIONSPORTS-20220620.csv
Where:
SOURCENAME: ACTIONSPORTS
Effective Date: 2022-06-20
firstName,lastName,dateOfBirth,gender,email,address_address1,address_address2,address_city,address_state,address_zipcode,address_countryIso,competition_nationality_countryIso,isAcceptedUSTATerms
Steven,Haas,2000-01-01,M,haas@abc.com,1 Oak Way,,Spokane,WA,20605,USA,BES,TRUE
Ace,Kumar,2006-12-31,M,kumar@abc.com,203 Main St,,Spokane,WA,20605,USA,IND,TRUE
Pam,McSporty,1980-09-12,F,pmcsporty@abc.com,90 Hale Ave,,Spokane,WA,20605,USA,USA,TRUE
Tula,Spiros,2003-11-28,M,spiras@abc.com,3012 Industry Rd,,Spokane,WA,20605,USA,USA,TRUE
Â
Â