Start a conversation Sign in
Start a conversation
  1. Gymnastics Australia
  2. Knowledgebase
  3. Clubs

Validation Template: Fix all the cells which are highlighted yellow

Before you can create an upload file, you need to fix all the yellow cells highlighted in the template.  Please refer to the below table on how to fix these yellow cells:


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.


 

Go back to Validation Template page.

Need more help?  Please raise a support ticket.

Choose files or drag and drop files
Helpful?
Yes
No

  1. Joshua Iacobozzi

  2. Posted

Comments