How to Import Member Data

About Importing Members via File:

• Step 1: Ensure your data is in the correct format
• Step 2: Select and upload (for preprocessing) the file containing your Member data
• Step 3: Add the Members (process the uploaded file)
• Step 4: Review the Audit log for errors

Step 1: Ensure your data is in the correct format

A single TAB-DELIMITED text file is to be uploaded using this process. This file should be created using MS Excel (save as...Text [Tab Delimited]) and must end in ".txt". The maximum size of the file is 4MB. This process will accept fields that are both surrounded by quotes and not.

DATA FORMAT: Please download the correctly formatted member import template attached above. The header record must be included, and the column names must be exactly as written in the template. The columns must also in the exact order as provided in the template. You do NOT have to include all of the columns. However, if you want to include a column in the middle of the template, you must include all of the columns prior to that. The only columns that are required are:first_name, last_name. 

Step 2: Select and upload the file containing your member data

Click the Browse...button to locate the file on your computer. Select the file and click the OK button. Once the dialog box closes, click the UPLOAD FILE button to upload the file and complete the process.

Please note: If the member already exists the member will not be added again.