Page 1 of 1
Recipient Import on SQL
Posted: Fri Jun 15, 2012 1:35 pm
by sylvester
can i take the recipient list from SQL? there are nearly 500 thousands entries.
thanks in advance for your answer. have a nice day.
Re: Recipient Import on SQL
Posted: Fri Jun 15, 2012 2:16 pm
by maschoff
Could you please what you mean by "SQL" in your context?
Re: Recipient Import on SQL
Posted: Fri Jun 15, 2012 2:56 pm
by sylvester
i mean from MSSQL database. can i retrieve data from there? if can, how?
Re: Recipient Import on SQL
Posted: Fri Jun 15, 2012 3:07 pm
by maschoff
Sure. You can find the database schema doc of OpenEMM here:
https://sourceforge.net/projects/openem ... rsions%29/
customer_1_tbl contains profile information of recipients. This table also holds all user-generated columns (see table customer_field_tbl). Assignments to mailing lists are saved in customer_1_binding_tbl.
Re: Recipient Import on SQL
Posted: Fri Jun 15, 2012 3:36 pm
by sylvester
i mean we have a database. in this database the recipients change in daily basis someone else changes it. when i will start mailing i need to update this. can i do this updating automatically while i am mailing? i mean can i establish a MSSQL database connection at that time?
Re: Recipient Import on SQL
Posted: Fri Jun 15, 2012 4:02 pm
by maschoff
OpenEMM runs only on MySQL and can not access an other DBMS in realtime out-of-the-box. But you could write a script to synchronize some database content daily between your M$ SQL DB and OpenEMM's MySQL DB.