Import emails from database of another mailing system

Solutions for other phpList version 2 users
Forum rules
Please do not ask questions here, this is for Solutions you have discovered or come across.

Import emails from database of another mailing system

Postby Dexter01 » 6:10pm, Wed 08 May, 2013

I have a large database of emails (in MySQL) and 4 groups that the contacts belong to. I would like to convert data to phplist by simply using a few SQL queries that would copy data from my tables to phplist's tables.

Is there a tutorial how to do it?

(I would find it out in the source code what are the relevant database tables but it's not so easy as I hoped so)

Thanks!
Dexter01
phpList newbie
 
Posts: 2
Joined: 6:05pm, Wed 08 May, 2013

Re: Import emails from database of another mailing system

Postby Dragonrider » 8:07pm, Wed 08 May, 2013

Without delving into MySQL, why not try exporting from your existing DB into a CSV file, opening that within a text editor, seeing what headings are used for your email list and creating these as attributes in phpList, then import your CSV file into phpList, having made a back up of your phpList db first of course.
My sites:- http://wharfedalefestival.co.uk, http://ilkleygardeners.org.uk, http://emergencyaid.net, http://dragonrider.co.uk
Latest phpList version is now 3.0.12 (3 February 2015) and requires a minimum of MySQL 5.0 and PHP 5.3.x
Dragonrider
Moderator
 
Posts: 3460
Joined: 6:58am, Sun 02 Jul, 2006
Location: Ilkley, West Yorkshire, United Kingdom


Return to Answers, Howtos, Tips & Tricks

Who is online

Users browsing this forum: No registered users and 1 guest

cron