Results 1 to 4 of 4

Thread: Mass mailing with Zimbra

Hybrid View

  1. #1
    Join Date
    Nov 2009
    Posts
    2
    Rep Power
    5

    Question Mass mailing with Zimbra

    Hi there.
    Mi name is Nicolás, I´m currently the network administrator of a small IT bussiness.
    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.

    Thank You
    Nicolás Bardier

  2. #2
    Join Date
    Jan 2009
    Posts
    35
    Rep Power
    6

    Default

    Quote Originally Posted by nbs View Post
    Hi there.
    Mi name is Nicolás, I´m currently the network administrator of a small IT bussiness.
    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.

    Thank You
    Nicolás Bardier
    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....
    1+ Year on Zimbra

    Release 6.0.6_GA_2330.RHEL5_64_20100505193959 RHEL5_64 NETWORK edition.

    RHEL 5.3 - After complete and utter Ubuntu 8.0.4 failure.

    Hardware Information:
    AMD Dual Core 2216 x2
    16GB of RAM
    425 GB (6 disks) of RAID 10 storage
    3ware + Seagate SATAs

    Virtual Server as emergency system using rsync.

  3. #3
    Join Date
    Nov 2009
    Posts
    2
    Rep Power
    5

    Default

    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....
    Thanks, but í´m kind a newbie with Zimbra, how do I get zimbra contacts using mySQL clients? how do i export those contacts to a sql server?

    Thanks a lot

  4. #4
    Join Date
    Jan 2009
    Posts
    35
    Rep Power
    6

    Default

    Quote Originally Posted by nbs View Post
    Thanks, but í´m kind a newbie with Zimbra, how do I get zimbra contacts using mySQL clients? how do i export those contacts to a sql server?

    Thanks a lot
    My assumption is that the contacts are already in the mysql server...but I may be wrong???? Not sure there...but if they are, seems to be pretty simple to move over. If not...then I am not sure...
    1+ Year on Zimbra

    Release 6.0.6_GA_2330.RHEL5_64_20100505193959 RHEL5_64 NETWORK edition.

    RHEL 5.3 - After complete and utter Ubuntu 8.0.4 failure.

    Hardware Information:
    AMD Dual Core 2216 x2
    16GB of RAM
    425 GB (6 disks) of RAID 10 storage
    3ware + Seagate SATAs

    Virtual Server as emergency system using rsync.

Similar Threads

  1. Zimbra spam system
    By rajahd in forum Administrators
    Replies: 9
    Last Post: 04-16-2008, 07:25 PM
  2. Major Issue - 5.0RC2 NE to 5.0GA NE failed
    By DougWare in forum Installation
    Replies: 7
    Last Post: 01-06-2008, 08:56 PM
  3. Can't start Zimbra!
    By zibra in forum Administrators
    Replies: 5
    Last Post: 03-22-2007, 11:34 AM
  4. dspam logrotate errors
    By michaeln in forum Users
    Replies: 7
    Last Post: 02-19-2007, 11:45 AM
  5. Fedora Core 3, Clean Install - Not working!
    By pcjackson in forum Installation
    Replies: 17
    Last Post: 03-05-2006, 06:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •