eMember – Export members to include ID

[apeterka]

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.7

[Peter]

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:

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

Also, we will take your feedback and look into adding the member ID option in the current eMember’s export feature.

[croissance]

Hello,

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 ?

[wzp]

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.

[croissance]

Hi,

I know it’s not the best idea but for the moment that was the “best” compromise. What could be the solution then ? Thanks !

[admin]

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);

[croissance]

Hello !

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 !

[RAWMaster]

Hello,

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.

[admin]

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)?

[RAWMaster]

Thank you for replying, yes that is what I’m looking for.

[admin]

okay, I will add it to the plugin and send you an updated copy.

[ChrisWP]

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?

[admin]

This change was implemented in the plugin. If you load a fresh copy of the plugin now you will get it.

[ChrisWP]

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?

regards

[admin]

I mad this change recently. Do the following and you should get it after that:

https://support.tipsandtricks-hq.com/forums/topic/re-install-or-load-a-fresh-build-of-the-plugins

[Author]

Posts