[Resolved] parent post not recognized in associations file when title contains ampersand

[Author]

Posts

[davidm-13]

Hi,
I've loaded all parent posts and now I'm loading the child posts. In the _toolset_associations_relationship-slug field I have the parent post title. All works OK - child posts connect with their parent post, except in the case that the parent title contains an ampersand then on the associations upload page the child post is flagged as parent missing - see screenshot.
I've tried substituting the "&" in the parent title field on the child post with "& amp ;" - without spaces
but it's still flagged as parent missing.
Any ideas how I can connect these parent and child posts?

Thanks
David

[Christian Cox]

Hi, in this case I would try using the parent post's GUID instead of post title. The GUID can be found in the post table of the database, and usually looks like a full URL.
https://toolset.com/documentation/user-guides/importing-content-from-csv-with-post-relationships/

[davidm-13]

Hi Christian, Thanks for this.
Would I place the parent posts GUID in the same _toolset_associations_relationship-slug-name field as I placed the parent post title? Do I need to indicate that this is a GUID and not the post title?
Do I need to delete and reload all the child posts, or is it possible to just update the child parent associations file? If so could you give me the CSV file column header names and the file name I need to replace.

Thanks
David

[davidm-13]

Hi Christian,
The screen shot is a preview of the parent posts.
Is the permalink column the GUID field I use instead of the Title?

[Christian Cox]

If you've already imported some items, some of this depends on the software you're using to do the import. What plugin are you using? It might be best for me to work with a copy of your database so I can run some tests before giving you the best information. Can you export your database as a SQL file, so I can work from the same baseline?

[davidm-13]

Hi, used ws migrate db plugin to export database, what should I do with it?
Please could you answer my question if permalink in the screenshot above is the GUID field I need to replace post title in the toolset associations field of child posts?

Thanks
David

[Christian Cox]

You can post the database dump file on Dropbox or Drive or some other file sharing service, then post a download link for me here in the forums. All links you share in the forum are hidden from public view for your privacy.

Permalink and GUID are not always identical, especially if you use some permalink structure other than the default URL parameter. The field you are looking for is actually called "guid" in the database. Look in the wp_posts table to find a post's GUID. Screenshot attached.

[davidm-13]

My issue is resolved now. Thank you!
Hi Christain, I deleted and reloaded the the child posts with the permalink in the toolset associations field. Seems ok - no missing parents.
I used the wp all export plugin to download the permalink and didn't see any GUID field there.
Thanks
David