Start a conversation

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