The new Validation Template can be downloaded from Club Admin Home> Administration> Club Import> Start New Import button> then click on the button 'Download Validation Template'
It is important that you check that you are using the latest version of this template as the template will be updated from time to time due to Athlete Coding (gymsport and level) changes. This is usually at the start of each calendar year.
Please follow these instructions to successfully import a file using this new template:
Step | Instructions | Link to detailed instructions | Notes |
1 | Click on 'enable editing' so you can edit the excel file. | More information on step 1 | This occurs as macros are attached to this template to make the buttons work. The Macros attached to this document are safe. |
2 | Click on 'enable content' so macos are enabled. | More information on step 2 | This occurs as macros are attached to this template to make the buttons work. The Macros attached to this document are safe. |
3 | Select 'yes' if you are asked to make the document a trusted document | More information on step 3 | This occurs as macros are attached to this template to make the buttons work. The Macros attached to this document are safe. |
4 | Import a previous upload file or from the Club Admin Portal> Reports> R. Club Import Export Report. IMPORTANT: PLEASE NOTE ONLY 1 EXPORT CAN BE IN THE TEMPLATE AT ONE TIME | More information on step 4 | IMPORTANT: PLEASE NOTE ONLY 1 EXPORT CAN BE IN THE TEMPLATE AT ONE TIME and the previous file must be in xlsx |
5 | Add individuals to sheet | More information on step 5 | This needs to be performed after the export, otherwise they will be overwritten. |
6 | Fix all the cells which are highlighted yellow. | More information on step 6 | |
7 | Update gymsport and level for your athletes | More information on step 7 | Gymsports and level are not mandatory but you need to ensure that new athletes have this information (otherwise the import will fail) and that this is correct for your athletes so they can enter competitions appropriate for their level. |
8 | Delete rows if required | More information on step 8 | |
9 | Create an import file | More information on step 9 | IMPORTANT do not open this file as the zeros from phone numbers will be dropped. |
10 | Use the Club Importer (Club Admin Home> Club Importer) to import your file. | More information on step 10 | IMPORTANT do not open this file as the zeros from phone numbers will be dropped. |
11 | Having difficulties? | generalsupport@gymnastics.org.au | Please contact us at generalsupport@gymnastics.org.au and send over your file(s) for us to review. |
For a detailed overview of each step and common issues that arise, please download and view the attached presentation.
Validation Template Error Messages & How to Resolve
Important: Please lodge a support ticket with your import file and a screenshot of the error message as an attachments if you cannot use the Validation Template.
Need more help? Please raise a support ticket.