caldopollo
 added a discussion 

Hi all.

I would like to export members (including Profile Names) from my site to a CSV format / Excel. I now can easily export Accounts through phpMyAdmin in cPanel, but the list does not include Profile Names. Is there a way to do this?

Thanks for your help.

  • 180
Comments
  • You can export the following two tables, sys_accounts and bx_persons_data. Then you open the two tables in excel and you copy / paste the column "name" of the table "sys_accounts" in "bx_persons_data", I just did it seems to be ok from start to finish.

    0 0 0 0 0 0
    • Baloo  if there are more than one profile for a member is it still possible to merge like described?

      0 0 0 0 0 0
      • Good question Cem, I did not think about that, it is true that I tested here with only one profile per account.

        0 0 0 0 0 0
        • No, in the case of a multiprofile site this is not as simple, there will be a gap between the two tables ...

          0 0 0 0 0 0
          • I think I found an easier/accurate solution (YouTube video name below - I can't include links). I basically ran a query in phpMyAdmin combining the two tables, then exported the results. Hope it helps.

            'MySQL tutorial 15 - joining 2 tables'

            0 0 0 0 0 0
            Not logged in users can't 'Comments Post'.

            UNA - Social Media Software Framework

            Close