Migrating the Opt-in / Opt-out data from 2015R3 to 2019?

Use this forum for questions regarding installation, upgrading and configuration of OpenEMM

Moderator: moderator

rodig03
Posts: 45
Joined: Thu Sep 18, 2014 1:27 pm

Migrating the Opt-in / Opt-out data from 2015R3 to 2019?

Post by rodig03 »

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
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Migrating the Opt-in / Opt-out data from 2015R3 to 2019?

Post by maschoff »

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.
OpenEMM Maintainer
rodig03
Posts: 45
Joined: Thu Sep 18, 2014 1:27 pm

Re: Migrating the Opt-in / Opt-out data from 2015R3 to 2019?

Post by rodig03 »

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.
Post Reply