Tips and Tricks HQ Support Portal › Forums › WP eMember › eMember – Export members to include ID
- This topic has 19 replies, 8 voices, and was last updated 5 years, 2 months ago by clearscopedesign.
April 24, 2013 at 10:28 am #8990apeterkaSpectator
Can the export member function include the Member ID field? I need a unique identifier within the export as many names in our membership are very similar or the same. I can export the entire member list, but the Member ID isn’t among the exported information.
eMember v8.5.7April 24, 2013 at 1:09 pm #55279PeterMember
You can use the email address field to identify the members (email addresses should be unique).
If you want more details from the members table you can export it using PHPMyAdmin.
Look for the table called wp_eMember_members_tbl.
If you aren’t familiar with PHPMyAdmin, please see this link:
Also, we will take your feedback and look into adding the member ID option in the current eMember’s export feature.November 16, 2015 at 3:07 pm #55280
I had the same issue and now that I’ve got the id via PHPMyAdmin, I don’t have the expiry date.
The columns expiry_1st and 2nd are empty and I need it + ID to create member cards.
Can you help me ?November 16, 2015 at 4:09 pm #55281wzpModerator
Trying to use the eMember “ID” number in the real world is a bad idea. The “ID” number is actually the MySQL database index number; that is specific to that particular WordPress installation. If you move your site, or even restore it from a backup, there is no guarantee the index (ID) numbers will be the same.November 16, 2015 at 6:46 pm #55282
I know it’s not the best idea but for the moment that was the “best” compromise. What could be the solution then ? Thanks !November 16, 2015 at 10:58 pm #55283
You won’t be able to get a expiry date from the members DB table. The expiry date is dynamically calculated from the membership level that the user belongs to. It is not just a simple date.
If you have the member’s ID then you can call the following function of eMember plugin which will calculate the expiry date:
$eMember_id = '2';//The member's ID
$expiry_date = emember_get_expiry_by_member_id($eMember_id);November 23, 2015 at 8:14 pm #55284
Thanks for the answer and sorry for mine late,
I’ve found the solution which is to not use the ID for external functions. You’re right, it does not make sense.
I wanted to thank again the forum and the creator of this plugin, it is very helpful and it works well.
Bye !February 20, 2017 at 7:35 pm #55285RAWMasterMember
I would also very much like this member id feature to export. I am using the emember extended profile and have created two custom fields that the phpMyAdmin does not print. I end up exporting from the module and php, then manually combining the two for a complete report.
Do you have another method that I could use instead?
Thank you.February 21, 2017 at 12:10 am #55286
Are you referring to the CSV export feature in the following interface of the plugin?
WP eMember -> Members -> Member Lists -> Export All Members Data
You want that CSV export to also contain the members ID value (the numeric value that the system assigns when a member record is created)?February 21, 2017 at 11:40 am #55287RAWMasterMember
Thank you for replying, yes that is what I’m looking for.February 22, 2017 at 3:42 am #55288
okay, I will add it to the plugin and send you an updated copy.July 20, 2017 at 6:16 am #55289ChrisWPMember
Hey, Would it be possible to get an update on whether this has been implemented yet? Using the current version of the plugin and it does not seem to be giving ID’s?July 21, 2017 at 2:19 am #55290
This change was implemented in the plugin. If you load a fresh copy of the plugin now you will get it.July 31, 2017 at 10:23 am #55291ChrisWPMember
Hi Admin – is that Version v9.1.4, because I have that and I did a download, but there is no Member ID field in the CSV file. Do I need to do something else?
regardsAugust 1, 2017 at 1:10 am #55292
I mad this change recently. Do the following and you should get it after that:
- You must be logged in to reply to this topic.