Comment to 'Export accounts with Profile Names'

Comment to Export accounts with Profile Names

· Baloo

· 2020-01-22T08:29:46+0000
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.
- See older replies...
- · Baloo
  
  · In reply to
  
  Cem
  
  · 2020-01-22T12:12:58+0000
  Good question Cem, I did not think about that, it is true that I tested here with only one profile per account.
- · Baloo
  
  · In reply to
  
  Cem
  
  · 2020-01-22T12:35:18+0000
  No, in the case of a multiprofile site this is not as simple, there will be a gap between the two tables ...
- C
  · caldopollo
  
  · In reply to
  
  Baloo
  
  · 2020-02-11T22:17:58+0000
  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'