Help! Mautic unusable - Contact data scrambled

@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