Follow the steps below to export your members:
- From the MemberMouse menu, click on Managing Members.
- If you only want to export a certain group of members, use the advanced search area to filter the members down.
Once you have the list of members you want to export, click the button at the top of the screen. This will generate a CSV file that you can download which contains member data for the members currently listed.
Note: Only Administrators will see this button. Sales and Support employees don't have the ability to export members unless specifically granted that permission by the Admin.
The way to grant permission is to log in using the Admin account, go to General Settings in the MemberMouse menu and then click on the Employees tab. Choose the account that you want to be able to export from. Then go to the Additional Permissions area and check the box next to "Allow this employee to export data". For more information about the options on Employee Accounts, you can reference this article about creating an employee account.
Below is a list of all the fields contained in the export template along with a description of those values:
ID MM User ID | This will display the ID number that MemberMouse automatically assigns the email address at the time of signup. | |||||
First Name User's First Name | Displays the member's First Name as it has been registered in the MemberMouse system. | |||||
Last Name User's Last Name | Displays the member's Last Name as it has been registered in the MemberMouse system. | |||||
Email Email Address | Displays the member's email address they used to register on your site. | |||||
Phone Phone Number | Display the member's phone number. Phone numbers will be displayed in whatever format they were uploaded in. Example: 123-123-1234 or 12312312345 | |||||
Notes (2.3.2+) Notes field | Displays the full text entered into the 'Notes' field on the General tab of the member's profile. | |||||
Membership Level Current Membership Level | Displays the Membership Level that is tied to the member's account. | |||||
Bundles Associated Bundle Access | Displays the Bundles associated with the member's account, if any. | |||||
Bundle Expirations Expiration Date | Displays the expiration date for the Bundles, if any. | |||||
Membership Expiration Membership Level Expiration Date | Displays the Expiration Date in the following format: MM/DD/YYYY (i.e. 1/25/2017). If this field is blank, member's Membership is not currently set to expire. | |||||
Registered Registration Date | Displays the member's registration date. Registration date will be expressed as a date in the following format: MM/DD/YYYY (i.e. 1/25/2017). | |||||
Status Changed Last Update | Displays the last date that the status was changed in the following format: MM/DD/YYYY (i.e. 1/25/2017). | |||||
Status Current Standing | Displays the member's current status at the time of export. Possible statuses:
| |||||
Billing Address If on file | Displays the member's billing address. | |||||
Billing City If on file | Displays the member's billing city. | |||||
Billing State If on file | Displays the member's billing state. | |||||
Billing Zip Code If on file | Displays the member's billing zip code. | |||||
Billing Country If on file | Displays the member's billing country. Uses two-digit ISO country codes. | |||||
Shipping Address If on file | Displays the member's shipping address. | |||||
Shipping City If on file | Displays the member's shipping city. | |||||
Shipping State If on file | Displays the member's shipping state. | |||||
Shipping Zip Code If on file | Displays the member's shipping zip code. | |||||
Shipping Country If on file | Displays the member's shipping country. | |||||
Custom Fields Columns Will Only Show if on File | If you have custom field configured in MemberMouse, these extra columns will display the data in those custom fields. Note: When viewing the export data for a custom field that's a check box, the following values will be used to indicate checked or unchecked: "mm_cb_on" and "mm_cb_off." |