Validation Template: Fix all the cells which are highlighted yellow

Views:

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.