@mzagmajster I tried a lot of different angles here and followed your suggestions above as well.
I was able to upload the csv into a new_leads table, then truncate data from leads table and copy data over from new_leads table, leaving structure the way it was. On the front end this cleaned up the data A LOT, however it’s not fixed yet. Contact IDs are (mostly) consistently in the incorrect column, despite their being in the correct column in the DB…
I guess I made one or more mistakes in the data migration and or tampering with the generated_email_domain column.
In the effort to solve this issue rapidly, I have created an opportunity:
I need help on this. I’ve spoken with a Mautic developer who can’t manage the MySQL side, and a MySQL expert who doesn’t know Mautic… I’m stuck here.
EP