[Resolved] importing parent and child posts using associations file

[Author]

Posts

[davidm-13]

Tell us what you are trying to do?
Hi, My plan is to use Toolset > Import > Associations after creating a csv file to establish the parent child relationship.
Then to use CSV Importer plugin to first import all Child posts then the parent posts. Is this a correct method? If not what would you recommend.
Is it the post title that creates the link between parent and child posts? If I wanted to use GUID how would I do that? Is the order files are uploaded important? - What is the right order.
Is there any example of a Associations csv file ready for impor?

Is there any documentation that you are following?
https://toolset.com/documentation/user-guides/importing-content-from-csv-with-post-relationships/
https://toolset.com/documentation/user-guides/how-to-import-content-into-wordpress-using-csv/import-content-csv-importer-plugin/
Is there a similar example that we can see?

What is the link to your site?
hidden link

[Shane]

Hi David,

Yes the relationship would first need to be created before importing the relationships with our importer.

If you take a look here you can see they are using the post title as the relationship connector.
https://toolset.com/documentation/user-guides/importing-content-from-csv-with-post-relationships/#an-example-of-how-a-csv-would-look-like

- Is it the post title that creates the link between parent and child posts?
Yes it is the post title that you need to use.

- if I wanted to use GUID how would I do that?
Currently i'm not seeing where this is possible.

- is the order files are uploaded important? - What is the right order.
Is there any example of a Associations csv file ready for impor?

No the order of the import shouldn't matter so long as the CSV format is correct according to our documentation then it will work.

Thanks,
Shane

[davidm-13]

Thanks for this Shane,
in https://toolset.com/documentation/user-guides/importing-content-from-csv-with-post-relationships/
it says:
"Instead of using the title of the post you can also use the GUID. This is helpful for the case you do not have unique titles."
Which means I'd Have to load all posts, to create a GUID and then download it, how would I do that?

[Shane]

Hi David,

Yes you are absolutely correct.

Not seeing where there is an example of the GUID but i would place it in the same relationship column in the CSV file that would hold the post title of the relationship.

So instead of using the title you just use the ID of the post.

Thanks,
Shane

[davidm-13]

OK, so I need to load all the parent and child posts first, then download all their GUID's, input them into then associations file, then upload the associations file.
How do I download the GUIDs and the post title.

Thanks
David

[Shane]

Hi David,

You can actually use this plugin below to export the data you need.
https://wordpress.org/plugins/wp-all-export/
Thanks,
Shane