Icy Phoenix

Old Support Topics - Export Email Addresses To A CSV File

christmanrd [ Fri 23 Apr, 2010 21:53 ]
Post subject: Export Email Addresses To A CSV File

How do I export the email addresses to a csv file format?

Thanks,

Dave

Lopalong [ Sat 24 Apr, 2010 09:18 ]
Post subject: Re: Export Email Addresses To A CSV File

MySQL Forums?.

This assumes that your DB prefix is ip_ and that you don't have more than a 1000 users.

Go To

phpMyAdmin > YOUR DB > SQL > Run this Query Code:

Code: [Hide] [Select]

SELECT COUNT( * ) AS `Rows` , `user_email`

FROM `ip_users`

GROUP BY `user_email`

ORDER BY `user_email`

LIMIT 0 , 1000

> Query results operations > Export > CSV > GO

christmanrd [ Sat 24 Apr, 2010 11:58 ]
Post subject: Re: Export Email Addresses To A CSV File

Lopalong wrote: [View Post]
MySQL Forums?.

This assumes that your DB prefix is ip_ and that you don't have more than a 1000 users.

Go To

phpMyAdmin > YOUR DB > SQL > Run this Query Code:

Code: [Hide] [Select]
Code: [Show]
SELECT COUNT( * ) AS `Rows` , `user_email`
FROM `ip_users`
GROUP BY `user_email`
ORDER BY `user_email`
LIMIT 0 , 1000

> Query results operations > Export > CSV > GO

Thanks a bunch Lopalong. That is exactly what I needed.

Lopalong [ Mon 26 Apr, 2010 23:29 ]
Post subject: Re: Export Email Addresses To A CSV File

You're welcome, But you could tag it as "Solved" as Staff Members seem to be in short supply at the moment.

christmanrd [ Mon 26 Apr, 2010 23:45 ]
Post subject: Re: Export Email Addresses To A CSV File

Lopalong wrote: [View Post]
You're welcome, But you could tag it as "Solved" as Staff Members seem to be in short supply at the moment.

Done! Sorry.