Column Number
|
Column Header
|
Is this field mandatory?
|
Recommended column format in Excel
|
Notes
|
1
|
LastName
|
Yes
|
Text
|
- Leading spaces in name must be removed – otherwise this creates a new record.
- No commas
- Character limit: 20 characters
|
2
|
FirstName
|
Yes
|
Text
|
- Leading spaces in name must be removed – otherwise this creates a new record.
- No commas
- Character limit: 20 characters
|
3
|
MiddleName
|
No
|
Text
|
- Leading spaces in name must be removed – otherwise this creates a new record.
- No commas
- Character limit: 30 characters
|
4
|
Email
|
Yes
|
Text
|
- Must be a valid email address eg. Needs to have a @
- No commas
|
5
|
BirthDate
|
Yes
|
Date
|
- Must be formatted DD/MM/YYYY
- Cannot be a date in the future (exceeds today) or too far in the past (over 90 years ago)
- Athletes over 90 yrs should use the bulk renew or individual athlete registration form.
|
6
|
Gender
|
Yes
|
Text
|
- Must be either F (female) or M (for male)
- We are currently working on a non-binary option but this is not available until future system upgrade. Workaround TBC
|
7
|
WorkPhone
|
No
|
Text
|
- Can be a mobile phone e.g. 04112223333
- Needs to only be numbers (spaces and special characters are dropped the by system)
- Must be 10 digits e.g. 0386989718
- Must include area code if landline e.g. 0386989718
- Must be exported as text column so 0 does not get dropped by Excel.
|
8
|
HomePhone
|
Yes
|
Text
|
- Can be a mobile phone e.g. 04112223333
- Needs to only be numbers (spaces and special characters are dropped the by system)
- Must be 10 digits e.g .0386989718
- Must include area code if landline e.g. 0386989718
- Must be exported as text column so 0 does not get dropped by excel.
- Recommend copying mobile phone into this field if empty
|
9
|
Mobile
|
No
|
Text
|
- Needs to only be numbers
- Must be 10 digits eg. 0411222333·Must be exported as text column so 0 does not get dropped by excel.
|
10
|
Address1
|
Yes
|
Text
|
- Character limit: 40 characters
- No commas
|
11
|
Address2
|
No
|
Text
|
- Character limit: 40 characters
- No commas
|
12
|
City
|
Yes
|
Text
|
- Please enter suburb in this field.
- No commas
|
13
|
State
|
Yes
|
Text
|
- States must be in the format eg. ACT, NT, NSW, QLD, VIC, TAS, WA
|
14
|
PostalCode
|
Yes
|
Text
|
- Must be 4 numbers eg. 2611
- Must be exported as text column so 0 does not get dropped in NT postcodes
|
15
|
EmergencyContact
|
No
|
Text
|
- Character limit: 30 characters
- No commas
|
16
|
EmergencyNumber
|
No
|
Text
|
- Can be a mobile phone e.g. 04112223333
- Needs to only be numbers (spaces and special characters are dropped the by system)
- Must be 10 digits e.g 0386989718
- Must include area code if landline e.g. 0386989718
- Must be exported as text column so 0 does not get dropped by Excel.
|
17
|
GuardianAddress
|
No
|
Text
|
- Character limit: 40 characters
- No commas
|
18
|
Gymsport1
|
Yes
|
Text
|
- This corresponds to the Athlete Coding Guide which is released in December annually by Gymnastics Australia.
- All athletes need to have 1 gymsport and level (athlete code) defined in order to be imported.
- Codes which are either not in the current Athlete Coding Guide or incomplete will be registered as undefined and in the bad data reports tab.
- Athletes can now have up to 3 different Athlete Codes (Gymsport and Level) defined on the same line.
- If your system does not record Athlete Codes, we recommend you have only the header and the Club will need to complete this information before importing.
- Must be exported as text column so 0 does not get dropped by excel in some levels.
|
19
|
Level1
|
Yes
|
Text
|
- This corresponds to the Athlete Coding Guide which is released in December annually by Gymnastics Australia.
- All athletes need to have 1 gymsport and level (athlete code) defined in order to be imported.
- Codes which are either not in the current Athlete Coding Guide or incomplete will be registered as undefined and in the bad data reports tab.
- Athletes can now have up to 3 different Athlete Codes (Gymsport and Level) defined on the same line.
- If your system does not record Athlete Codes, we recommend you have only the header and the Club will need to complete this information before importing.
- Must be exported as text column so 0 does not get dropped by excel in some levels.
|
20
|
Gymsport2
|
No
|
Text
|
- This corresponds to the Athlete Coding Guide which is released in December annually by Gymnastics Australia.
- All athletes need to have 1 gymsport and level (athlete code) defined in order to be imported.
- Codes which are either not in the current Athlete Coding Guide or incomplete will be registered as undefined and in the bad data reports tab.
- Athletes can now have up to 3 different Athlete Codes (Gymsport and Level) defined on the same line.
- If your system does not record Athlete Codes, we recommend you have only the header and the Club will need to complete this information before importing.
- Must be exported as text column so 0 does not get dropped by excel in some levels.
|
21
|
Level2
|
No
|
Text
|
- This corresponds to the Athlete Coding Guide which is released in December annually by Gymnastics Australia.
- All athletes need to have 1 gymsport and level (athlete code) defined in order to be imported.
- Codes which are either not in the current Athlete Coding Guide or incomplete will be registered as undefined and in the bad data reports tab.
- Athletes can now have up to 3 different Athlete Codes (Gymsport and Level) defined on the same line.
- If your system does not record Athlete Codes, we recommend you have only the header and the Club will need to complete this information before importing.
- Must be exported as text column so 0 does not get dropped by excel in some levels.
|
22
|
Gymsport3
|
No
|
Text
|
- This corresponds to the Athlete Coding Guide which is released in December annually by Gymnastics Australia.
- All athletes need to have 1 gymsport and level (athlete code) defined in order to be imported.
- Codes which are either not in the current Athlete Coding Guide or incomplete will be registered as undefined and in the bad data reports tab.
- Athletes can now have up to 3 different Athlete Codes (Gymsport and Level) defined on the same line.
- If your system does not record Athlete Codes, we recommend you have only the header and the Club will need to complete this information before importing.
- Must be exported as text column so 0 does not get dropped by excel in some levels.
|
23
|
Level3
|
No
|
Text
|
- This corresponds to the Athlete Coding Guide which is released in December annually by Gymnastics Australia.
- All athletes need to have 1 gymsport and level (athlete code) defined in order to be imported.
- Codes which are either not in the current Athlete Coding Guide or incomplete will be registered as undefined and in the bad data reports tab.
- Athletes can now have up to 3 different Athlete Codes (Gymsport and Level) defined on the same line.
- If your system does not record Athlete Codes, we recommend you have only the header and the Club will need to complete this information before importing.
- Must be exported as text column so 0 does not get dropped by excel in some levels.
|
Joshua Iacobozzi
Comments