Getting email list from DB?

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
rj
Regular
Posts: 477
Joined: Sun Sep 10, 2006 2:53 pm

Getting email list from DB?

Post 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
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Getting email list from DB?

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
rj
Regular
Posts: 477
Joined: Sun Sep 10, 2006 2:53 pm

Re: Getting email list from DB?

Post by rj »

thanx!!

RJ
Post Reply