PDA

View Full Version : Problem with Generate Mailing List


wampforum
07-12-2011, 10:31 AM
Hi folks,
hope someone can help as I have been nabngin my heda all morning on this! I am trying to create a list of user emails and name to import to mailchimp. I tried the generate mailing list option but it will not seperate data - just displays as one column regardless of linebreaks, commas anything.
Any I ran an SQL query that gave me the details fine but its only showing me 618 results - I have 1160 members on my site so why are they not showing on the generate mailing list or SQL results? I get the same issue if I run the query via phpadmin - usertable shows 1160 entries but only produces 6128 on query

The SQL I ran was:
SELECT email FROM user

Also anyway of pulling real names into the SQl query?

cheers

Brett

--------------- Added 1310482763 at 1310482763 ---------------

OK I have sorted things!

stephen1976
07-12-2011, 02:44 PM
Do you know how to down loaded the emails address from vbulletin. I just the email address from my database CSV forexcell if you do could you tell me how, that would help me as I using phplist.

Have you looked at phplist! for yourself

Badshah93
07-12-2011, 03:55 PM
Do you know how to down loaded the emails address from vbulletin. I just the email address from my database CSV forexcell if you do could you tell me how, that would help me as I using phplist.

Have you looked at phplist! for yourself

Admincp -> Users -> Generate Mailing Lists

stephen1976
07-12-2011, 05:31 PM
So how do i make that met these requirements

http://docs.phplist.com/ImportUsersInfo

Really need help with this i am sinking!!!

Badshah93
07-12-2011, 05:41 PM
if you want list of email address seperated by comma then

go to Admincp -> Users -> Generate Mailing Lists

Text to separate addresses by: , and click on go

stephen1976
07-12-2011, 05:45 PM
got that bit then how do i then save them into a compatable file.

Badshah93
07-12-2011, 06:25 PM
i think you need to paste all email id which u got from generate mailing list (seperated by comma) in a txt file and then import it.

wampforum
07-12-2011, 06:46 PM
I couldnt get the email addresse's seperate in the generate mailing list but did using the SQL query - then just copy and paste into excel

stephen1976
07-12-2011, 06:59 PM
thanks that works as i spoted their mistake in the instructions, thanks for your help. going to take a while to import 50,000

artificestudios
08-06-2011, 07:29 PM
Is it possible to get more than just the email address? I want member name as well?