Tell us what you are trying to do?
I am trying to import Custom types instances from a source site w/ Elementor (hidden link) to a new development site (hidden link) :
- both sites have the same Toolset Custom Types structure, including Relationships
The items I am trying to import are 4 artworks (Oeuvres in French) as a test :
- they are in a many-to-many relationship with 2 other Custom Types : Expositions and Artistes
- in Sheet Editor, the columns holding these relationshipe refenrences are present, on both sides (source sheet and destination sheet)
- I also veryfied that the 4 Oeuvres I was importing were connected to their respective Artiste and Exposition
- they are all connected to same the Exposition instance : "ADG Exposition fondatrice 2017"
When I import these 4 Oeuvres, I get the following merror message : see attachment
The weirdest thing is that when I am importing Oeuvres connected to another Exposition, they import correctly, without that error message !
Is there a better way to transfer Toolset data with relationships than Sheet Editor ?
What pluging do you prefer for that type of operation ?
Is there any documentation that you are following?
Bulk Editing Toolset Content with WP Sheet Editor :
> Exporting Content to a CSV file
> Importing Content to a CSV file
Is there a similar example that we can see?
- see attachment
What is the link to your site?
Source site :
url : hidden link
Your access Data : username : support@toolset | password : Support_Toolset_$1
Destination site :
url : hidden link
Your access Data : username : toolset | password : Support_Toolset_$1
Hello,
According to our document:
https://toolset.com/course-lesson/how-to-import-content-into-wordpress-using-csv/
I don't find any detail about "Sheet Editor" plugin, which supports Toolset many-to-many relationships
In my opinion, you can try WP All Import plugin, and follow our document to setup the CSV files, and maintain Toolset post type relationships:
https://toolset.com/course-lesson/import-posts-from-csv-with-relationships-using-wp-all-import/
Hi Luo,
Thank you for your prompt response.
I think you are right, WP Sheet Editor, eventhough I had asked their support team about Relationships transfer integrity, seemingly does not conserve relationships properly.
But the issue remains that some of my Custom Types import quasi flawlessly with WP Sheet Editor, and others don't - as describes in my previous message.
Neveretheless, I am going to try with WP All Import plugin, and I have 2 questions :
1.- How about the Export from the source site : it seems that Ihave to use WP All Export for that
2.- The WP All Import - Toolset Add-on is quite expensive, and comes in 2 options :
--- the Toolset Types Import Package at $149 - one time fee
--- the Import + Export Pro Package at $299 - one time fee
Which one should I consider to export-Import Toolset Types & relationships ?
Best regards,
Francesco De Grandi
I have checked the WP All Import document:
hidden link
It can only import data, I don't see the export feature in above document, you can check it with their supports.
In Toolset side, you need to:
1) use the built-in Toolset > Export / Import features for exporting and importing Toolset setting structures
2) use the WordPress built-in export tool (wp-admin > Tools > Export) to export your site post/page contents, for example:
- Posts, Pages, posts in Custom Post Types
-- The taxonomy terms associated with each post
-- The custom field values associated with each post
-- The post relationships associated with each post
- Media library items
Then use the import tool built into WordPress (wp-admin > Tools > Import) to import that site content, but only after you have imported the Toolset structures listed above.
Hi Luo,
Thank you very much for bringing this issue back to basics :
- I did the export with the WP Export Tool
- I did thre Import with the WP Import Tool : it took me a little whle to do things in the right sequence, in order to maintain Toolset Associations. Now all is OK, only a few adjustments for the destination site's Taxonomies, Content tamplates, and related Media items.
No need for an expensive plugin ! And I did learn a lot...
Only one caveat :
- it seems that not all media export/import all at once - I have 13056 Images in the Media Library
- do you have any idea why ?
I had done already the step 1) you mention - see last line of the first paragraph of the initial message of this ticket.
And I am only exporting/Importing DATA, because I am developing a new site (hidden link) based on Gutenberg which has too use the same darta as the old site (hidden link) based on Elementor.
And this for 2 reasons :
1.- Elementor has become unfortunately a real nightmare of updates and bugs
2.- Toolset allows me to do much more with Gutenberg - like having more than 1 Single Template for a given Custom Type for instance - Gutenberg being th future of WordPress anyway...
I am relieved and now able to continue this development properly
Thank you again.
Best regards.
Francesco De Grandi
According to our support policy, we prefer one ticket one question, for the other new issues, please check the new thread here:
https://toolset.com/forums/topic/not-all-media-export-import-all-at-once/
My issue is resolved now. Thank you!
