This support ticket is created hace 4 años, 2 meses. There's a good chance that you are reading advice that it now obsolete.
This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
Hoy no hay técnicos de soporte disponibles en el foro Juego de herramientas. Siéntase libre de enviar sus tiques y les daremos trámite tan pronto como estemos disponibles en línea. Gracias por su comprensión.
Tell us what you are trying to do? I'm trying to move a legacy database (Laravel/MySQL) to WP and Toolsets.
My main issue is importing the legacy data. There are many relationships, including M:M that rely on id's in the legacy data. Is there anyway to import this and map the data correctly?
For example, songs are M:M with transactions, submissions etc. Then there is the issue of taxonomy (lookup tables in Laravel talk). They also need to be imported, for example, a song can have more than one genre, or more than one mood.
I realize this is a long shot, but figured I'd ask.
Is there any documentation that you are following? No
1. Taxonomies related to the custom post are not imported at all, well they just create a new taxonomy with the id not the title.
2. I am importing 16,000 plus transactions, so adding the relations to the CSV is not feasible. I can run a query to do that, but I haven't tried it.
3. One thing I forgot to mention was there is existing data. The wordpress site was the front end for a music publisher, he has a backend that is on Laravel. It's virtually impossible to map the songs in wordpress, to the songs in the Laravel app. It's a downfall of wordpress, I understand not your issue really. WP really needs to join the 1970's and learn about normalized data. I'm not sure how bad the performance will be in any case with 20k plus records and no indexes worth a damn.
3. One thing I forgot to mention was there is existing data. The wordpress site was the front end for a music publisher, he has a backend that is on Laravel. It's virtually impossible to map the songs in wordpress, to the songs in the Laravel app. It's a downfall of wordpress, I understand not your issue really. WP really needs to join the 1970's and learn about normalized data. I'm not sure how bad the performance will be in any case with 20k plus records and no indexes worth a damn.
I completely understand, i've worked with laravel previously. Your entire database relationship will need to be changed in order to fit into wordpress's native database structure.
Usually when you have 20k plus records you can leverage it with cache. I've seen customers with quite large websites with relational data and their website was still responsive.
