WordPress.org

Ready to get started?Download WordPress

Forums

WP-Members
[resolved] Inconsistent Data in User Meta Table Dump (2 posts)

  1. pmagony
    Member
    Posted 1 year ago #

    Hello,

    I hoping someone can help me out... when I output the user meta table as an excel file, not all the meta_keys are being exported for each user_id.

    For example, one user_id may have Company Name & Account No fields, while another may not. One may have an activate field, while others do not.

    Why is the data inconsistent? Shouldn't ALL users have the same meta_keys?

    Our goal is to dump, populate the data via Excel which is faster, and re-import.

    Thanks!

    http://wordpress.org/extend/plugins/wp-members/

  2. Chad Butler
    Member
    Plugin Author

    Posted 1 year ago #

    Your question is in regards to the plugin, so are you using the plugin's export process, or is this a direct db dump? The way you worded your question, it sounds like you are outputting the table directly?

    If that's the case, there will not be meta keys for which there has never been data entered. For example, in the case of activate field, this isn't set upon registration. So if the user has recently registered, and has not been activated, there is no meta key for this. If the user has not entered data for a field that may not be a required field, there would be no meta key for that field for that user. That would be the case if Company Name and Account No fields are not required - if there's no data entered, there is no meta key.

    There is a user export process within the plugin. That would provide you a cleaner export than accessing the db directly.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic