WP All Import’s integration with Toolset’s Types fields and post relationships makes it easy to import your data

October 18, 2018

You might have seen that the WP All Import plugin already supports Types Custom Fields. Now, we are pleased to announce that you can also import your Toolset post relationships using WP All Import.

Both features are available for free during the beta period of WP All Import’s Toolset Types Add-On plugin. The integration opens new opportunities for you to handle more advanced projects.

Why import data from CSV files?

Some WordPress users prefer to edit the data in Excel files, Google spreadsheets, Numbers for Mac and other similar tools rather than doing this directly on their WordPress site. This is especially the case when many fields are involved.

You export your spreadsheet to the CSV file format and then import the data into WordPress.

Editing data in a Google spreadsheet and exporting it to a CSV file
Editing data in a Google spreadsheet and exporting it to a CSV file

 

Most people, however, aren’t actually making their own spreadsheet, they’re importing data from somewhere else. In those cases, modifying the format of the XML/CSV is a pain, and sometimes it’s not possible because the import has to run on a schedule and the file can’t be manually edited.

And this is where you need a reliable tool to handle the content import.

In WP All Import plugin you can drag and drop any data, no matter how it’s structured/organized.

Using WP All Import plugins for importing CSV files to WordPress
Using WP All Import plugins for importing CSV files to WordPress

With its support for importing Toolset Types fields and now – post-relationship, you can handle more complex cases, including importing sites that have custom PHP and MySQL tables or migrating from Drupal to WordPress.

The benefits of WP All Import’s compatibility with Types fields and post relationships

We recommend using both WP All Import and WP All Import Toolset Types Add-On plugins for many reasons. Here are the most significant ones:

#1 Toolset Types fields support

Using a simple drag-and-drop interface, you can import data into custom fields that you created using the Toolset Types plugin. Check our documentation for more details.

Importing fields from CSV file and mapping into Types field with the WP All Import Toolset Add-On plugin
Importing fields from a CSV file and mapping into Types fields with the WP All Import Toolset Add-On plugin

#2 Handling post relationships in a flexible way

You already know that using post relationships makes building advanced sites and running them easier.

 

 

Creating relationships between custom post types in WordPress with Toolset
Creating relationships between custom post types in WordPress with Toolset

You can edit related posts in your spreadsheets by using the post IDs, slugs or titles. Each post can be edited in a separate cell:

CSV file. The Director column connects Movie and Directors tables
CSV file. The Director column connects Movie and Directors tables

Then, during the import, you simply drag and drop the post title into the Relationships section on WP All Import.

Relationships section on WP All Import Toolset Types Add-On
Relationships section on WP All Import Toolset Types Add-On

Note that you can not only import new posts with relationships but also quickly update existing ones.

You can learn more about how to import CSV files and maintain post relationships using the Toolset Types Add-On plugin.

WPML compatibility

You can also rely on it when you import data in multiple languages.

Check it out yourself

Find out how easy it is to now import custom post types with post relationships by downloading WP All Import’s Toolset Types Add-On.

The plugin is still in the beta phase but it was used for the How to migrate from custom tables into WordPress video and it worked very well.

The good news is that when it’s in beta, it’s free. So go ahead and check it out!

If you need sample CSV files, you will also find these in our WP All Import documentation.

Then get back to us to give us your feedback.

We are in touch with the WP All Import team and are working on additional features such as support for multiple instances and repeatable groups.

 

Comments 17 Responses

  1. I don’t think this is an announcement of any new functionality is it? The functionality looks identical to what already existed. I lost a full 2 days of my life trying to get WP All Import’s Tooset Types Add-on plugin to work and maintain relationships during import and eventually gave up.

    • Hello Charlie,
      what do you mean by “what already existed”? The version we’ve been using and testing was released in September, so it’s relatively new. It’s still in beta so there might be issues but all the cases covered in our documentation work. Do you have a support ticket maybe? I’m in touch with the WP All Import folks and can ask for their in-depth investigation of your case but I need to know what exactly you’ve tried and what is not working.

  2. This is very good news. I assume this add on will be available / included as part of a Toolset subscription?

    I had actually just done a massive migration over the weekend using the new relationships and had resorted to picking up a saved meta value in one of the WP All Import Action hooks and assigning the Toolset relationship with the API.

    The flexibility to be able to use a slug or post tile will save a massive amount of time. Currently my process involves importing date and then re-exporting the same data with the WP Post IDs in order to use THAT information in the next CSV to be imported.

    So, next question, something similar for WP All Export perhaps? I’m currently using WP All Export’s ability to produce a result from a custom function, passing the ID of the post being exported and looking up some detail about another post it’s related to…

    • Hello Dominic,

      This plugin won’t be available in your Toolset account since it’s not our plugin. The name of the plugin (WP All Import Toolset Types Add-On) implies that it’s a Toolset plugin but it’s WP All Import’s plugin developed by the http://www.wpallimport.com team. If you want to download the beta version, you can do it for free now but you need to register at their site.

      I’m impressed that you managed to handle the migration with using API but now, it’s no need. Actually, that integration was available for about a month now but we were still testing and sorting out some issues with the WP All Import team.

      Now, it’s a good opportunity for you to compare the new features for handling relationships with what you implemented.

      I don’t think there is something similar for WP All Export. In my migration video (5:30) to handle the export, I was using the phpMyAdmin tool to run some SQL queries and then its Export(CSV) feature. I don’t know the specifics of your case but maybe you can do the same? WordPress database can be accessed via phpMyAdmin as well.

      Thank you for your comment, Dominic.

      • I try and avoid running SQL myself and try to keep everything within WordPress. Some of the things I use this for are operational processes which need to be used by people less technical than me so really has to be in WP All Export.

        I will certainly be trying this out soon!

        • Thanks for sharing your reasons why it matters to you to have the features in the WP All Export. The more people report the need for such features the better chance that the WP All Import authors will consider implementing it.

  3. This seems to be an useful add-on.
    I’d also like to know how to export the relationship data with WP All Export.
    Can you explain how to export/import a set of different CPTs with relationships from one WP installation to another, using WP All Export/Import?
    Thanks.

    • Hello Daniel,
      you can move post types that use post relationships from one site to another by using Toolset plugins only and the classic WordPress Importer tool.

      Here are the steps:
      1. Toolset->Export/Import, Types tab -> Export Types data (you export the post types/fields/relationships definitions)
      2. Tools –> Export, you export the data
      3. On the new site, first, import the data definitions: Toolset->Export/Import, Types tab
      4. Then import posts via Tools –> Import (last option, WordPress)
      5. Finally, connect the posts. Go to Toolset –> Export / Import –> Associations and finish the operation there.

      • Hi Agnes,
        Thanks for the details.
        Is it possible to do this with WP All Export/Import as well?
        I’m looking for a way to automatically export/import (update) a subset from an installation that has a huge post collection with relationships.

        • I don’t think so. No integration has been done in the WP All Export. Only in WP All Import. But I will contact the authors of the WP All Export/Import to double check and if that’s the case I’ll ask if they have any plans.