WordPress.org

Ready to get started?Download WordPress

Forums

WP-Members
Export Members (Especially Custom Fields) (5 posts)

  1. Nono
    Member
    Posted 2 years ago #

    Hi Chad.

    I need help generating a list of users with custom fields like company, complete name, etc. A SQL statement or a list of related fields in tables would be appreciated.

    Thank you.

    Regards,
    Nono

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

  2. Chad Butler
    Member
    Plugin Author

    Posted 2 years ago #

    Hi Nono - sorry for the delayed response. I didn't see this until now...

    It's probably more complicated to pull from the database directly than it is to just use the export users feature within the plugin. The user export will give you a CSV file. It will also mark any exported users so that later you can just get a list of users that haven't been exported since the previous export.

    If you were to do it directly with a SQL statement, you would need to come up with a JOIN for the usermeta table where the extra fields are stored. The plugin just loops through the fields and grabs the data via get_user_meta.

    Hope that helps.

  3. Nono
    Member
    Posted 2 years ago #

    Hi Chad. Thanks for your reply.

    I used a plugin to export a CSV but it only had user name and email address and the client was ok with that but requested that maybe company name, etc could be extracted too.

    In the meantime someone developed a plugin that exports custom fields generated by yours:

    http://wordpress.org/extend/plugins/wp-export-users-plus/

    I am going to install this on the new site I am putting up to test it out.

  4. Chad Butler
    Member
    Plugin Author

    Posted 2 years ago #

    WP Export Users Plus sounds interesting and I'll take a look at it, but I was referring to above was the WP-Members internal user export process. So my question is were you unaware that the plugin already had a user export process built-in? The reason I ask is that this feature has been part of the plugin for over a year, so if people are unaware of it, maybe I need to document the plugin features better.

    The bulk user management panel (found under Users > WP-Members) allows you to export all users, or just the users exported from the previous export. This will include all of the fields that you have set up with the plugin.

  5. Nono
    Member
    Posted 2 years ago #

    Hello Chad.

    I am using an old version, 2.3.2 to be exact, that didn't have the feature. You might ask why it was not upgraded? Hehe. There was custom code and it is a live site for videos.

    I grabbed the latest version for a new project and it seems I won't need to hack your code like before. Since you have basically included all/most of the functionality I need. (But I apologize if I ever I would.)

    Also, I see the Export option now in the users list. So I guess I won't be needing the plugin I mentioned above.

    Thanks.

    P.S. You blogged about the release of 2.6.6 but WP still lists 2.6.5?

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags