Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

How to Easily Export Member Details with Membership Level and State

by

Tips and Tricks HQ Support Portal › Forums › WP eMember › WP eMember F.A.Q/Instructions › How to Easily Export Member Details with Membership Level and State

  • This topic has 1 reply, 2 voices, and was last updated 13 years, 9 months ago by amin007.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • August 6, 2011 at 10:23 pm #3999
    lkinca
    Member

    This is not a question, but rather a tip (since I’ve gotten a lot of help in this forum). It is useful for people who want to ‘export’ their entire member list including the membership level and state. This is a huge help for many reasons, including if you want to upload your list to an email system like MailChimp or others that allow you to segment your list.

    There is a tutorial in the docs for doing this export through PHPMyAdmin, but some people just are not comfortable with it (and it can be dangerous to mess around PHPMyAdmin if you don’t know what you are doing). So this is for folks who want a safe – and I think faster – way to get this data.

    The trick is to use a FireFox addon called Table2Clipboard. (Google Table2Clipboard – it will come up first). After installing Table2Clipboard:

    1. First change your emember settings to display the maximum number of rows possible.

    2. Next, view the full member list.

    3. Right click on the member table and select ‘Copy entire table’ under the Table2Clipboard menu.

    4. Go to Excel and right click in cell A1 then choose ‘Paste Special’.

    5. Select the option to ‘Paste as Text’ and boom…there is all of your data.

    Table2Clipboard is my default work around anytime an export tool on any site doesn’t work the way I want it to and the eMember ‘number of rows to show’ setting allows most folks to do this with just one copy and paste but if your list does get paginated, you can just cut and paste twice, three times, etc.

    Hope it helps!

    August 7, 2011 at 2:21 am #35271
    amin007
    Participant

    Thank you for sharing this method of member details exporting technique. The tutorial on exporting member details using PHPMyAdmin can be found here:

    http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Registration
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Shopping Cart Plugin
  • Simple Download Monitor

Copyright © 2025 | Tips and Tricks HQ