Page 1 of 1

Getting email list from DB?

Posted: Thu Nov 04, 2010 3:37 am
by rj
I have about 400 registered users with emails. I recall a few years ago not being able to get them and move them into a editor from admin, but I did get them to come up in phpadmin I think. I just tried that again and didnt manage it. I need to see them in a list on screen so I can copy and paste them rather than have to open each user in admin to get it. Any ideals?
Thanx
RJ

Re: Getting email list from DB?

Posted: Thu Nov 04, 2010 9:50 am
by garvinhicking
Hi!

Use phpMyAdmin to export your "serendipity_authors" database table, choose "CSV" or "XLS" as export format, put them into your Excel/OpenOffice and there you can do whatever you need to. :)

Regards,
Garvin

Re: Getting email list from DB?

Posted: Thu Nov 04, 2010 6:00 pm
by rj
thanx!!

RJ