Page 1 of 1

sql database

Posted: Wed Apr 30, 2008 2:44 pm
by shibadoo
as stated in the user guide, you either have to enter recipients manually or import them via a csv file. Isn't there a way to connect to an already existing mysql database?

we already have a client database in a mysql database. following the guide i would have to export and import the database every time i wan to send out an email/newsletter. would make more sense if openemm could connect to this existing db. is this possible?

Posted: Tue Jul 01, 2008 3:27 am
by henry_shadowjet
You'd find that OpenEMM's database is quite friendly. They are not that difficult to understand. Though I am new myself, from what I can see, you can edit table customer_1_tbl via MySQL. That table contains the customer details. Another table called customer_1_binding_tbl is to determine which mailing a customer will be assigned to.

So to answer your question, if you could make a script that will use your existing database, and import them into the OpenEMM database, that would work as well. ^^

I hope I was helpful.