Thank you for reaching out! Your steps for migrating Amelia's data are generally correct. However, the link between Amelia customers and WordPress users does not transfer automatically during this process. Unfortunately, there is no automated way to re-link them, so this would need to be done manually.
Let me know if you need any further clarification!
We usually do not support direct MySQL queries, as most of our users prefer managing configurations through the interface rather than running database commands. However, if this solution works for you, that's great! Let us know if you need any further assistance.
Dear support,
I want tot export the current Amelia data to my test-environment. I use the steps to export/migrate Amelia in this article: https://tmsplugins.ticksy.com/ticket/3420551/
My steps are:
1. Install and activate the Amelia plugin
2. Import the users to this new site using the plugin 'Import and export users and customers' by Javier Carazo.
3. Delete all the Amelia tables from the database.
4. Import the Amelia tables
It all looks ok, but the link between the Amelia customers and the Wordpress users is gone.
Are these steps ok, or do I miss something? Is there a quick way to re-link the Amelia customers to the imported Wordpress users??
With regards,
Jurgen
Dear Jurgen,
Thank you for reaching out! Your steps for migrating Amelia's data are generally correct. However, the link between Amelia customers and WordPress users does not transfer automatically during this process. Unfortunately, there is no automated way to re-link them, so this would need to be done manually.
Let me know if you need any further clarification!
Kind Regards,
Uros Jovanovic
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Manually?? We live in 2025 Uroš! I allready fixed it using a MySQL query...
Hello Jurgen,
We usually do not support direct MySQL queries, as most of our users prefer managing configurations through the interface rather than running database commands. However, if this solution works for you, that's great! Let us know if you need any further assistance.
Kind Regards,
Uros Jovanovic
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables