Trying to export customers info for Emailing List

Forum Moderators: open

Message Too Old, No Replies

Trying to export customers info for Emailing List

I have a mysql db and phpmyadmin

akmac

9:46 pm on Dec 15, 2008 (gmt 0)

I've exported the customer table as a csv, but constant Contact can't get the info from the file.

I think I need to export just the names and email addresses from the table, but I can't figre out how to do this using phpmyadmin. Possible?

topr8

12:13 am on Dec 17, 2008 (gmt 0)

maybe you could run a query like:

SELECT names + ',' + emailAddress AS hopethisworks FROM tablename

and save it to file (i think there is that option with phpmyadmin)

akmac

9:21 pm on Dec 17, 2008 (gmt 0)

Thanks for your reply-I know in theory it should be simple, but I'm clueless as to how to write a query that would accomplish the desired result. I got a more helpful rep at constant contact and he took the whole table csv that I exported and extracted the correct info for me.

Helpless with some things, I am.