Blog
Podcast
Support
Customer Login
The option to export members from the MemberMouse database is available to all Employee Accounts with Administrative rights. This tool allows you to export filtered lists in CSV format from the Manage Member area using any of the available filters.
The CSV export can be used for:
- Accounting and bookkeeping
- Reporting
- Imports to 3rd party software
- Migrations
- Bulk alteration of user data
- Long-term storage of member data
- And much, much more
One of the most frequent and practical applications of the export tool is to use the exported data for bulk alterations of member data. This can involve adding data to member accounts, modifying dates, adjusting membership levels, adding bundles, and more. For a comprehensive guide on how to update members using the import process, please refer to this article: Import Members with the Import Wizard
How To Export Members and Their Data
- From the MemberMouse menu, click on Manage 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 Export Members 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.
Available Fields In The Export Template
| 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. |
| Displays the member's email address they used to register on your site. | |
| Username | Displays the member's username they used to register on your site. Often it is the same as the users email address |
| Phone | Display the member's phone number. Phone numbers will be displayed in whatever format they were uploaded in. Example: 123-123-1234 or 12312312345 |
| 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: 1 = Active 2 = Canceled 3 = Locked 4 = Paused 5 = Overdue 6 = Pending Activation 7 = Error 8 = Expired 9 = Pending Cancellation |
| Billing Address If on file | Displays the member's billing address. |
| Billing Address Line 2 If on file | Displays the member's billing address line 2. |
| Billing City If on file | Displays the member's billing city. |
| Billing State If on file | Displays the member's billing state. |
| Billing Zip 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 Address Line 2 If on file | Displays the member's shipping address line 2. |
| Shipping City If on file | Displays the member's shipping city. |
| Shipping State If on file | Displays the member's shipping state. |
| Shipping Zip 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 fields 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.” |
Troubleshooting Problems During Export
- Non-employees will not see the export button. If you need to export but do not have access, an administrator will have to edit the employee account to the administrator level or check the option to permit exports within that employee's account.
For more information about the options on Employee Accounts, you can reference this article about creating an employee account.
- If the export hangs and does not complete, it may indicate admin-side errors, needed updates, non-UTF8 characters in the export, or a lack of server resources. Please submit a ticket so our team can determine the problem and find solutions for you.
- If the export completes but does not produce a file, your popup blocker could be the cause.
EN 
ES 
DE 
FR 
PT 
