UBB.Developers Forums UBB.threads 7 Development How Do I? Dump e-mail adresses to csv or txt

Hi, I am starting an mailinglist for my members but I don't want all members to have to sign up for it.
How can I dump the e-mail addresses in the ubbthreads database to the screen, to a CSV or txt file so I can import it into the mailinglist?
I tried myphpadmin but I was only able to dump all user data, and I just need the e-mail addresses.

Regards,

Ron.

That would be a good thing to request for 6.1, due to all the changes being made for the emailing members function. Just have it print out the list of members who haven't opted out.

Dump the hole table with phpmyadmin and open the csv-file in Excel. You can delete the unwanted columns easily and save the file in csv-format again.

I tried that but then you get a lot of garbage in your list.

what kind of garbage?

Well, when I tried and erased all other fiels, in the e-mail field sometimes was the loaction of the member or one of my optional fields. I guess the fields where not seperated properly by excel.

Regards,

Toxic[Q]

I'm attaching a simple PHP script for dumping all the email addresses to a text file, one address per line.

If you need it tweaked slightly, let me know.

Edit: updated attachment to fix typo.

Thanks Dave, might make a nice small modification once any tweaks are finished

Cool! Thx!

Hi there,

I installed the script on my server in the same directory where my IIP index.php script is located.

how do I execute it so that it creates the email list?

I tried accessing in my browser with http://.... but I get an error that it can't fopen(email_list.txt, 'w') or something like that.

am I doing something wrong.

is there not an easier way of exporting names and email addresses so I can do email broadcasting from my newsletter program?

thanks,

KC

[]Dave_L said:
I'm attaching a simple PHP script for dumping all the email addresses to a text file, one address per line.

If you need it tweaked slightly, let me know. <img src="/threads/php/images/graemlins/smile.gif" alt="" />

Edit: updated attachment to fix typo. [/]

It's probably a permissions problem. Try creating the file email_list.txt ahead of time, and ensure that its permissions are set so that it's writable by the script.

Don't leave the email_list.txt file there, because anyone can read it from a browser.

A safer method would be to locate the file outside the web root, and put the full path in the line: