Is there a plugin for exporting BP Extended Profiles into a CSV file?

HI Support,

Very much need to export the profiles that have been collected in the community so that we can make an information graphic.

Can anyone please tell me of how I can do this ?

  • Alexander
    • DEV MAN’s Mascot

    Hi @smarthart,

    I've looked into this, and could not find an easy solution for getting this data. The best thing I could find was using this plugin:

    It allows you to export entire tables as CSV. The problem is that all this data is stored in relational tables, not in a single table. So even though you'll have access to the data, you'll need to sort and organize it before it will be useful.

    The data for the fields themselves can be found in this table: wp_bp_xprofile_data

    I'd recommend that you sort that table by user_id, which will give you the username followed by all it's profile fields. You can reference what field_ids refer to by checking the "wp_bp_xprofile_fields" table.

    Thanks for being a WPMU DEV member. Let us know if we can be of any further assistance.
    Best regards,

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.