Importing data for more the one post type, creating relationship using ID

This support ticket is created 4 years, 3 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
-	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Kolkata (GMT+05:30)

This topic contains 1 reply, has 2 voices.

Last updated by Minesh 4 years, 3 months ago.

Assisted by: Minesh.

Author

Posts

May 19, 2021 at 10:36 pm #2062249

joelW-4

I am still having issues with this, right now the tables are failing to import but I am beginning to have doubts that this will work at all.

Quick sample of what I am trying ot do is I have a database for a fishing club/group. There are a number of tables exported, one has membership information, ID, name and region information.

I have results as well, from tournaments, contains the members ID, how many fish they caught, weight, points and the tourny ID. We do not use the members name in that table, just their ID number.

I need to be able to import this data from these tables, and I need to link them together using the member ID. We are not hand entering this, we use wpallimport to import this information. Any time I reference the ID number for the relationship the import fails. and like I said, I have no idea if your toolset will handle this at all. Any tutorial information keeps on telling me to add the relationship info to the table to import, considering how many we have that is insane, we should be able to use the common ID to link /reference the 2 different tables and pull the needed information.

What am I missing here. Or did we waste money getting these add ons.

May 20, 2021 at 5:24 am #2062391

Minesh

Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hello. Thank you for contacting the Toolset support.

I'm not sure if you have checked the following Doc that illustrates how you can migrate custom tables to Types structure.
=> https://toolset.com/documentation/programmer-reference/how-to-import-a-database-into-wordpress/

As you shared, you are using the wpallimport plugin to import the content. I'm not sure how exactly you are importing the content.
=> https://toolset.com/course-lesson/how-to-import-data-from-a-csv-file-using-the-wp-all-import-toolset-types-add-on-plugin/
=> https://toolset.com/course-lesson/import-posts-from-csv-with-relationships-using-wp-all-import/

If import fails using WP ALL Import, I suggest you should contact the WP All Import plugin support as they will be the best person to review your structure and guide you with the best possible solution. If they will find issue with Toolset, we are ready to help and fix it.