OpenEMM Technical Support Forum

Hi,

I am looking for the best way to migrate the opt-in / opt-out data from an existing OpenEmm 2015R3 to a new OpenEmm 2019 system.
One way I can think of would be to do a CSV export of the status for each mailing list and try to import it - but is this the way you would recommend?
Working in MySQL/Maria DB could be a better solution, but I do not want to break the data integrity of the new system by doing this without a hint about the best way to use.
We can sync the users by Webservcies, but in our case the subscribed mailing lists are maintained only in OpenEmm, so this data needs to be migrated somehow.
Thanks!

Best regards,

Robert

I would use GUI export and import AND keep a copy of tables
- customer_1_tbl (holding the recipient's data)
- customer_1_binding_tbl (holding the recipient's subscription information)
- mailinglist_tbl (mailing list info)
of the old database - just in case to keep a copy of the original data in its original format.

Thanks - I'll do that.
I saw that a full CSV export also contains all the Opt In/Out information, and it is easier to use without corresponding (old) server, so the DB backup is just kept for the worst case.