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?
sql database
Moderator: moderator
-
henry_shadowjet
- Posts: 24
- Joined: Wed Apr 09, 2008 8:24 am
- Location: Sydney, Australia
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.
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.