how to merge one to many relationships into many to many relationships

This support ticket is created 5 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
-	7:00 – 14:00	7:00 – 14:00	7:00 – 14:00	7:00 – 14:00	7:00 – 14:00	-
-	15:00 – 16:00	15:00 – 16:00	15:00 – 16:00	15:00 – 16:00	15:00 – 16:00	-

Supporter timezone: Europe/London (GMT+00:00)

Tagged: Post-relationship

This topic contains 3 replies, has 2 voices.

Last updated by Nigel 5 years, 10 months ago.

Assisted by: Nigel.

Author

Posts

February 7, 2019 at 1:32 pm #1197263

charlie

Tell us what you are trying to do? I have five tabele (bandiere, stemmi, gonfaloni, sigilli, altre immagini) related to one table (collaborazioni) in a relationship one to many. This table is also connected with collaboratori , also in one to many relationship. I want to have with 5 relationships with many to many link beetween bandiere, sigilli ... and collaboratori.
I tried to have a view from which I exctracted a csv file with only collaborazioni_intermediary id_bandiere_collaboratori (such as in fig, 2). But i don't know how to import with all import plugin for toolset

Is there any documentation that you are following?

Is there a similar example that we can see?

What is the link to your site? hidden link

February 8, 2019 at 7:35 am #1197656

Nigel

Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+00:00)

Hi there

Sorry for the wait for a reply, the queue has been busy.

Can I clarify. Your question is about how to import the data into relationships you have already set up using Types (so you have, is it, 5 many-to-many relationships with collaborazioni, plus a one-to-many relationship between collaborazioni and collaboratori)? Or did you need any help setting up the relationships?

If you intend to import the data with the WP All Import plugin, they have an add-on for imported data into Types relationships, for which we have a guide here: https://toolset.com/documentation/user-guides/how-to-import-content-into-wordpress-using-csv/how-to-import-data-from-a-csv-file-using-the-wp-all-import-toolset-types-add-on-plugin/

Did you try that already?

February 8, 2019 at 4:41 pm #1197915

charlie

I have read that "Many-to-many relationships that use the intermediary post type are not supported by the WP All Import plugin. If you need this kind of support please let us know".
So how can I do? I have a csv file perfectly extracted from previous data types bandiere and types collaboratori. And I have an intermedary id. The relation ship bandiera_collaboratore Bandiere [*] << bandiera_collaboratore >> Collaboratori [*]
I think it could be so easy to import but it's very hard.

February 8, 2019 at 8:31 pm #1198012

Nigel

Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+00:00)

It is apparently possible with the Ultimate CSV Importer Pro plugin, though when testing this for someone else today I struggled to get it to work, though the client eventually was able to.

However, you can achieve this with a free CSV import plugin and the built-in Toolset tools, which I described to a third client trying the same earlier today: https://toolset.com/forums/topic/what-is-current-recommended-way-to-to-import-csv-parent-and-child-posts/#post-1197804

Do you want to try that and let me know how it goes?