This guide will show you how to import your junior members into the applicable membership package(s). Please find an example junior import spreadsheet by using the information in Step 5 . You can use this spreadsheet to import, you will just have to clear the dummy data.
Please Note: We have included tips for populating your data in the our template, this has be added to the bottom of the article.
Create a junior package. You should create a package for all junior memberships available at your venue, e.g. Junior Under 18's 2021, Junior Under 10's 2021.
Within the Membership Module, select a package that you want to import your members into.
Click 'Import members'.
Skip to Step 5 for importing via a spreadsheet
To import from an existing package, use the drop-down box (as in screen image below) to select the package you wish to import from e.g. Junior 2018, these members will then appear within your Junior 2019 package as 'Pending' until their membership is paid.
You may also want to tick the box for 'Active members only' to prevent lapsed members also being added from a previous package.
To import from an external file, select 'Browse' to choose the file you wish to upload, and then click the 'Import' button.
Please Note: If you choose to 'Import from an external file', then download the template and enter all your junior member's details
Once the file has successfully imported go back into the membership package by clicking 'Membership' and choosing the package from the list.
NOTE: For Date of purchase memberships, the start-date inputted on the spreadsheet template will now be detected (previously the current day / imported date was the 'start-date'), we are pleased to have updated this.
Back in the membership package, you will see all the junior members who are now within the package.
If you select the tab (above the filter options), you will also be able to switch from 'Members' to 'Main Contacts' and send them emails, payment requests and invites.
Tips for inputting your data to the template spreadsheet correctly:
Importing from an External File:
With our junior import file, we require an adult contact to be associated with each junior. These adult contacts should be included in a separate row on the junior spreadsheet. If there is more than one child with the same adult contact, it's okay to just include the adult contact once.
Even if the adult has their own separate membership, they should still be included on the junior spreadsheet. To ensure that a duplicate contact isn't created for the Adult, please use the same First Name, Last Name and Email that is associated with the adults account within your system.
Each person on the spreadsheet should have there own unique Contact ID. The Contact ID of the adult contact should then be put in the Primary Contact ID field of the juniors and the adult to link the junior's and adult together.
The Contact ID, Primary Contact ID, First Name and Last Name fields are compulsory on the Junior Import Sheet.
Contact ID is the unique membership number which you give to each member. It can be a number, letter or symbol.
Feel free to populate the rest of the document with as much or as little as you would like. You are able to edit members information once they have been imported. The cost, payment and date fields should be filled in on the row of each junior. The adult contact will receive all payment requests and invitations.
Please Note: Do not remove any columns or change the wording of each column. If you do not have the data, just leave them blank.
Within your email column, emails must be valid and contain an '@' sign. Please also keep an eye out for full stops, as this can cause an error when importing.