Importing your Members

• How to Import Your Members
• How to Import Secondary Members
• How to Import via Custom Import/Fields
• How to Update Existing Member Fields via Reimport

FAQ's

1. What if My Data Contains Errors?
2. What if some of my Members Don't have an Email Address?
3. How Can I Import More Information on My Members?

How to Import Your Members

To import your members, you must be logged in with site administrator, or membership administrator access.

Navigate to the Membership tab in the top navigation, then select Member Import from the left-side navigation.

 

There are two types of fields in the system: standard demographic fields (as shown in the screenshot below) and custom fields.

Standard demographic fields are the default fields available in the system. All Member Jungle subscriptions have the ability to import these fields.

Custom fields can be created via the fields added into the membership form (see Customising and Managing Your Membership Forms) to collect additional details from members based on your specific requirements. To import your custom fields for your members, you will need to discuss adding this functionality with our team.

If you have custom fields, please see our instruction article here.

The Member Import page provides instructions to assist you with your import. Please refer back to this information to help ensure your data is correctly formatted, and that your import is successful.

 

Please hover your mouse over the 'i' icon to view the tooltip.

To get started, please see steps below:

1. Download the CSV Template.  To download the template, you will need to select the membership level you would like to import members into.
Please note that member imports are completed per membership level, as your membership form fields may vary for each level. 

 

The CSV file contains headings for all of the fields added and created in your membership form. For more details, please see here: Managing Your Membership Forms

2. Fill in your Membership Data. Transfer your members’ data into the template. Most fields are optional and do not need to be completed before importing; however, there are some mandatory fields that must be completed:

1. first_name

2. last_name

3. email (if your members don't have an email address see the section below)

The fields that you do not complete will remain empty in the membership data for those members. Once you have completed your import data, save it as a CSV file. 

You must complete the membership_product column with the exact name and spelling of the membership product you wish to import your members into. Otherwise, the member will be added to the default membership product selected during the import process.

3. Import your data.

1. Membership Level – Select the membership level you want your members to be imported into.

2. Default Membership Product – This field is required, however it will use the information provided in your data if you specify the membership product for each member. If the column in your CSV is left empty, the default membership product selected will be applied to those members.

3. Membership Expiry Date – This is an optional field, however can be used to apply an expiry date for members within your data who have this column blank. If your members have an expiry in the data, the import will use this information instead. 

   If you have Life/Perpetual members, then you can leave this field and the member data field blank and the member will be imported with a perpetual membership.

4. Update Existing Accounts – If the file contains existing members, select if you would like their details to be updated with the data in the import file, by selecting Yes, in the checkbox. Please refer to this section for more details.

5. Ignore Empty Fields – If you select "Ignore", then any fields left blank in your import file will remain empty in the membership data for those members, or unchanged if you are updating existing members.
   If you select "Leave Blank" and also select to update existing members, it will remove any demographic information from the members profile that is left empty in the member data and includes the relevant heading.

6. Import File Date Format – From the dropdown menu, select the date format that matches the dates in your CSV file.

7. Import File – Upload the CSV file you would like to import.
   
   

Once done, click 'next'.

4. Confirming Data. Standard demographic fields are matched by default. Please feel free to review.

To match a column from your file to a field, click the dropdown option and select the appropriate field.

Once done, click 'process file'.

If your data is formatted correctly, you will be taken to a screen where you can confirm that the member import is correct.

Click the import button.

Click the acknowledge button.

You have completed importing your members!

Update Existing Accounts or Members/Matching Fields

You can use the import functionality to update existing membership accounts only, including membership levels and products, join dates, expiry dates, and standard demographic fields.

Additionally, this feature is useful for making bulk updates to your members’ accounts.

The process of updating existing accounts is similar to importing your members. However, when you select the “Update Existing Accounts” option, you will have additional options to update specific fields.

Please note that not all options should be selected, as some fields are used for matching existing member records.

If you need to update all the options listed below, you can perform a second import to update the remaining fields. Select updates that apply only.

What if My Data Contains Errors

If your data contains errors, the system will show the specific line and the reason for the error.

Based on your screen, you should see either two or three buttons, depending on whether only part of your data contains errors or if the entire import has errors.

From the screenshot above, there is one line causing the error. You have the option to download the error line and proceed with the import while excluding the error line, or restart the entire import process.

 

What if some of my Members Don't have an Email Address?

You cannot run a member import without an email address and adding a bogus address will cause issues with spam. We do understand that in some cases, members will not have an email address, so here's a workaround that we support.

You will need to use a legitimate and easily identifiable email address like "noemail@myclub.com.au" where "myclub.com.au" is your domain name, e.g. noemail@soccernewcastle.com.au.

Please avoid using fake or invalid email addresses, as some system-generated emails are always sent ( e.g., welcome email). Using fake addresses can increase the risk of your sending domain being blocked or marked as spam.

Firstly, populate the import spreadsheet with your "noemail" address for members who require it. Use the same address for all members who don't have an email address. You can then run through the rest of the import steps above.

As the email address is one of the identifiers, you will need to supply a username in your data in order for the system to differentiate the various members with the same email address.

Once the import is done, you need to exclude the "noemail" address from system communication. This will stop any emails being sent from the system. You can exclude this address in General Settings under SETTINGS (in the Membership module).

Just enter the email address in the Add Excluded Email Address area and click the icon.

You should now see your address in the list of excluded emails.

Scroll down and click to save the settings.

How Can I Import More Information on My Members

If you have fields that are not listed below, they are considered custom fields. You will need the Custom Import functionality enabled in your system to import these fields.

Members who are already in the system cannot have data added to these custom fields for the same membership level. So ensure you import your members with all of their custom data from the start.

Please note that this functionality is not available in all packages. Feel free to submit a support ticket if you need assistance.

For more details about Custom Import, please see here: Custom Data Import