[Resolved] Import posts for many-to-many relationships with fields attached

[Author]

Posts

[alessandroD-7]

Hi

I need to import data for many-to-many relationships with fields attached to the relationship.

I've 2 custom post types:
- "Utenti"
- "Praticanti"

Where 1 "Utente" can have many "Praticante" and 1 "Praticante" can be associated to many "Utenti".
In the relationship I've 2 fields:
- "Data Inizio"
- "Data Fine"

I've an .cvs (or excel) file where I've:
- the POST_ID of the "Utente"
- the POST_ID of the "Praticante"
- "Data inizio" as date in unix timestamp format
- "Data fine" as date in unix timestamp format

I've read here but it doesn't help:
https://toolset.com/course-lesson/import-posts-from-csv-with-relationships-using-wp-all-import/

Can you help me?

Regards
Alex

(If it helps in wordpress I've installed WP-ALL-IMPORT PRO.)

[Luo Yang]

Hello,

Yes, you are referring correct document.

Two things need to pay attention to:
1) You need to install two plugins:
- WP All Import – freemium
- WP All Import – Toolset Add-on – premium
https://toolset.com/course-lesson/import-posts-from-csv-with-relationships-using-wp-all-import/#what-to-install

2) See section "Example #3 – many-to-many relationships" of above document:
https://toolset.com/course-lesson/import-posts-from-csv-with-relationships-using-wp-all-import/#example-3-many-to-many-relationships

In the second csv file, it needs to add multiple columns "Event 1" + "Event 2"... each grid value should be the title of related post title, see screenshot:
https://toolset.com/wp-content/uploads/2018/09/artis-cvs-rel.png