Hi Martin,
Thank you for waiting.
Based on my tests and research, here are the steps that I'll suggest for the import of Event <---> Judges relationships.
Important note: Please make a complete backup copy of the website, before running this import.
1. Since your website already has the Events and Judges posts, you won't have to import them again. The process to join them in Event <---> Judges relationship, will consist of two pain steps:
a). Importing "Events Judges Intermediary Posts"
b). Importing "Judges" a special custom field value in "Judges" posts, which Toolset will be used later to recognize the relationships.
2. You can download the sample CSV files for this process from this link:
hidden link
To better understand this, let's suppose that we have the following events and judges posts, which need to be connected:
Event 4 <---> Judge D
Event 5 <---> Judge E
Event 6 <---> Judge F
Event 7 <---> Judge G
Event 8 <---> Judge H
Event 9 <---> Judge I
As a result of these required many-to-many relationships, we'll need respective Events Judges Intermediary Posts, which can be set to have the title in this format:
Events Judges: Event Title - Judge Title
i.e.
Events Judges: Event 4 - Judge D
Events Judges: Event 5 - Judge E
Events Judges: Event 6 - Judge F
Events Judges: Event 7 - Judge G
Events Judges: Event 8 - Judge H
Events Judges: Event 9 - Judge I
3. First, we'll need to create a CSV import file, which will add these "Events Judges Intermediary Posts" in the system. Since this post type also has a field "judge panel proper", the values of those custom fields can also be imported during this step.
Please refer to the file "intermediary.csv".
( screenshot: hidden link )
While importing this file through "WP All Import", please make sure to select the correct post type ( Events Judges Intermediary Posts ) and import them as new posts, since they don't already exist. Also map the file columns, so that the first column is used for the post's title and the second one is used for the custom field "wpcf-judge-panel-proper".
( screenshot: hidden link )
4. Once these intermediary posts have been imported, the next step would be to run an import into the child post ( judges ) so that a special custom field value can be added into them.
Please refer to the file "judges.csv".
( screenshot: hidden link )
The objective of this import is to add a custom field value to key "_toolset_associations_event-judge", for judges posts, which need to be linked to the respective event ( and the intermediary post ), in this format:
{!{Title of the event}!} + {!{Title of the intermediary post}!}
While importing this file through "WP All Import", please make sure to select the correct post type ( Judges ) and import to update the existing posts, since they do already exist. Also map the file's columns, so that the first column is used for the post's title and the second one is used for the custom field "_toolset_associations_event-judge".
( screenshot: hidden link )
5. Once, this import has been completed successfully, please go to "WP Admin -> Toolset -> Export / Import -> Associations" and you'll see the available relationships, ready to be imported, by Toolset Types.
( screenshot: hidden link )
I hope this helps and please let me know if you need any further assistance around this.
regards,
Waqar
