Skip Navigation

[Resolved] No relationships recognized during test import

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)

This topic contains 7 replies, has 2 voices.

Last updated by Nigel 5 years, 10 months ago.

Assisted by: Nigel.

Author
Posts
#1197350

BV

I am trying to import tables from my previous CMS. I prepared all necessary types. Then I bought WP Ultimate CSV Importer Custom Fields PRO version. Then I was reading it's manual and prepared CSVs of 2 tables in necessary format.

All fields importing correct. But relationships between 2 tables (Regions-o2m-Countries) doesn't recognizing at all. I'm uploading first child table, then parent. I use titles for relating, because my IDs system is different (in old CMS I have different tables for each of content types, so IDs can be same as what I see isn't works for WordPress).

Here is archive with types export file + 2 CVSes I'm importing, pls tell me what's wrong with them: hidden link. First need to import directory_countries.csv, then directory_regions.csv.

#1197655

BV

My issue is resolved now. Thank you!

#1197668

BV

Hi!

WP Ultimate CSV Importer plugin support told that Custom Fields PRO version doesn't support relationships. I bought extension to the full PRO version. But problems still persists.

#1197675

Nigel
Supporter

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

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

Hi there

Let me take a look. I'll need to set up a test site with relationships and some dummy data to import. (I have some other users asking similar questions, though not about the WP Ultimate CSV Importer plugin, and I will need to get set up with a copy of that to check it is working as expected.)

I can look at your CSV files, but I need to remind myself of what the general steps are with my own test, first.

You have been following the documented steps, yes?

https://toolset.com/documentation/user-guides/how-to-import-content-into-wordpress-using-csv/import-csv-ultimate-csv-importer-plugin/

#1197682

BV

Yes, I was reading both your and Ultimate Importer manuals and experimented with 2 CSV by very different way:
- different order of import
- updating of existing records during import
- tried to enter references by id manually

BTW you can experiment on your host with my data easily - I provided full toolset types export + my 2 CSVs with data.

#1197823

Nigel
Supporter

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

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

Hi Maxim

I had a similar ticket where I was helping someone import related posts where they were not using the commercial plugins with Types relationship support, and I got it working without problems.

Then I tried to do more-or-less the same, but with the Ultimate CSV Importer Pro plugin.

It worked when I tried to import data in a one-to-many relationship.

It didn't work when I tried to import data in a many-to-many relationship.

That took me quite a long time to set up and I was quite thorough, I don't think I did anything wrong, but I need to get a colleague to try the same and see if they can get it to work. (This doesn't come up very often, it could be that it used to work and now does not, for some reason, but I need a second person in the team to confirm my findings.)

It's likely to be Monday before I get confirmation from someone else, I will let you know.

In the meantime, if you are curious about the alternative you can check my reply here: https://toolset.com/forums/topic/what-is-current-recommended-way-to-to-import-csv-parent-and-child-posts/#post-1197804

#1197824

BV

Hi, my problem was resolved - suppose it was related to the thing that limited version of plugin was activated before full version. I restored old version of db and it started to work.

#1197825

Nigel
Supporter

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

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

OK, good to know, you had a better experience than I did 🙂