The new Club Importer Template can be downloaded from Club Admin Home> Administration> Club Import and then click on the button 'Download Latest Club 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 Importer> Export page.
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|
|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|
|10||Use the Club Importer (Club Admin Home> Club Importer) to import your file.||More information on step 10|
|11||Having firstname.lastname@example.org||Please contact us at email@example.com and send over your file(s) for us to review.|
Need more help? Please raise a support ticket.