Import Member Database
Import Member Database
Simply export your clients (and/or prospects) from whatever software you currently have into an Excel or equivalent file.
Reformat this information using the template format below. If you are not importing information that corresponds to that column you must still leave the column in place and leave it empty. Double check your information is formatted properly before proceeding.
Do not fill in the referral field with anyone that is not on your member data list
Make sure there are no blank lines in your format
Make sure that the referred by column contains only NAMES of the members who are ALREADY in your Member Manager site - Any other submissions in this column will result in improper importing
Column | Information |
A | Member ID |
B | Login |
C | Password |
D | First Name |
E | Last Name |
F | |
G | Phone |
H | Cell |
I | Gender (format: Male or Female) |
J | Address |
K | City |
L | State/Province |
M | Country (format: US or CA) |
N | Zip/Postal code |
O | Birthday (format: MM/dd/yy or MM/dd/yyyy or MM.dd.yy or MM.dd.yyyy) |
P | Finished |
Q | Important health information |
R | Work phone |
S | Work email |
T | Client since |
U | Occupation |
V | Referred by ( you can't import this column) |
W | Reminders |
X | Emergency contact 1 |
Y | Emergency phone 1 |
Z | Emergency contact 2 |
AA | Emergency phone 2 |
AB | Prospect (format must be yes or no and is case sensitive) |
Once you have your file set up here are the next steps:
Save this as a tab delimited file in Excel
Go into your Member Manager site.
Click Admin
Click the browse button and search your computer until you find the file that you want to import (Again, make sure that the columns are formatted correctly).
Click Import