Recipient Import on SQL

[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.

[maschoff]

Could you please what you mean by "SQL" in your context?

[sylvester]

i mean from MSSQL database. can i retrieve data from there? if can, how?

[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.

[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?

[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.