My office mass mail regularly using PHPList. Off course this means there´s a MySQL database which is used by PHPList to, among other things, store contacts information.
Also we have a server serving Zimba Network Edition, with several accounts each one with its set of contacts.
So, we have a problem here, which is, we have basically two sets of contacts, the ones stored in Zimbra, and the ones stored in MySQL PHPlist´s database.
We would like to have an unique contact database, easy to manage from Outlook or Zimbra web interface, and we would also like to retain the ability to mass mail some of our contacts.
Off course, we have the approval of our customers to send those mails, we don´t spam.
So… Can this be done with Zimbra? Can we replace PHPList with Zimbra? or at least can we make PHPList use zimbra´s contacts? is there a proposed solution for this? Your help would be very much appreciated.
I’m not sure what the tables are called, but why couldn’t you just write a stored procedure in mysql, automate it via cron and have that stored procedure copy your zimbra contacts into your phplist database nightly/hourly/etc… you can transform data in any way you may need and it’s automated with no changes to zimbra or to phplist…
just a thought….
1st time Zimbra Administrator
Release 6.0.2_GA_1912.RHEL5_64_20091020145322 RHEL5_64 NETWORK edition.
RHEL 5.3 – After complete and utter Ubuntu 8.0.4 failure.
AMD Dual Core 2216 x2
16GB of RAM
425 GB (6 disks) of RAID 10 storage
3ware + Seagate SATAs