phplist

[robbie93]

Hey guys!  I just installed phplist,  does anyone know how to import all members emails from smf to phplist?  I am having trouble figuring this one out and have done a searchy and couldn't find anything 

[MrPhil]

There is no mechanism in SMF to dump the members list into a CSV. Anyone want to write a utility to do this?

As for a quick and dirty solution, go into phpMyAdmin and dump (export) just the smf_members table. Consulting the table definition (e.g., install_1-1.sql), use a text editor to remove the fields you don't want (of course, leave the emailAddress and probably the realName fields). Wrap the fields in " and separate by commas. I think PHPlist wants a first row added which as the field names. Get rid of the INSERT INTO line and any other such overhead, leaving you with just

Code Select Expand

"realName","emailAddress"
"John Smith","[email protected]"
"Jane Doe","[email protected]"
etc. PHPlist should be able to use that kind of file.

If you're going to do this often, it would be worth writing a Q&D PHP script to pull out the desired data and create the CSV file all in one shot.

[robbie93]

Thank you for your reply,  would I have to do this everytime a member joined though?

[MrPhil]

Unfortunately, yes. Once you have the initial list (CSV file), it might be easier to manually update it every time a member joins or quits (provided you get notification). Or, bite the bullet and cobble up a PHP script to open your database, select the fields, and write out a file that you can directly use with PHPlist.