Skip Navigation

[Resolved] Migrating tables with many to many relationship with intermediary

This support ticket is created 3 years, 10 months ago. 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.

Sun Mon Tue Wed Thu Fri Sat
9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 - - 9:00 – 13:00
14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 - - 14:00 – 18:00

Supporter timezone: Africa/Casablanca (GMT+01:00)

This topic contains 1 reply, has 2 voices.

Last updated by Jamal 3 years, 10 months ago.

Assisted by: Jamal.

Author
Posts
#1958893
Capture1.PNG

I am preparing data from my custom database to import into WordPress using WPAllImport and want get advice on whether my plan is sound. I started with the following article on Many-to-Many Post Relationships
https://toolset.com/course-lesson/many-to-many-post-relationships/

I applied my data to your example found in the article with the following result:
https://toolset.com/wp-content/uploads/tmp/Capture1.png

The Resource could be one of three types, Lesson Plan, Classroom Resource, or Learning Activity, but I'll use the Lesson Plan for my example because the relationships work similarly for all three resource types. This relationship diagram shows the 3 tables involved in the many-many relationship.

#1960071

Hello and thank you for contacting the Toolset support.

You will also need to Toolset Addon for the WP All Import plugin. Check this article, it explains how to import the different relationships in Toolset https://toolset.com/course-lesson/import-posts-from-csv-with-relationships-using-wp-all-import/

I hope this helps. Let me know if you have any questions.