WPML Export and Import

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client needs to export text from a page created with Bricks Builder, translate it using a spreadsheet, and then import it back in.

Solution:
1. If you can export the Bricks Builder content using WP ALL Export into a CSV file, you can manually add the translated content to this file.
2. Import the main file into the other site first to ensure the default content appears there.
3. Add translations to the CSV file and configure parameters to link the default content with its translations. Refer to our guide for details: Preparing Import Files for WPML Export and Import.
4. Import the file with translations to the site and navigate to "WPML > Export and Import" to run the import process.

Creating a spreadsheet file for each post or page with sentences separated as in the translation editor is not feasible. Content in the spreadsheet is presented in one line per ID for efficiency and maintainability.

If this solution is not relevant to your case, because it might be outdated or not applicable, we recommend opening a new support ticket. We also highly recommend checking related known issues at WPML Known Issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If you need further assistance, please contact us in the WPML support forum.

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Tagged: Exception

This topic contains 3 replies, has 2 voices.

Last updated by Milan.Milicev 1 year, 2 months ago.

Assisted by: Prosenjit Barman.

Author	Posts
April 16, 2024 at 10:38 pm #15528394
Milan.Milicev	I have a website and I'm using Bricks Builder. I also have WPML import and WP All Import & Export installed. Is there a way for me to export all of the text from a page that was made with Bricks, translate it using a Spreadsheet and import it back in?
April 17, 2024 at 9:54 am #15530623
Milan.Milicev	Is there a way to export each to a spreadsheet like it's separated in this translation editor?
April 17, 2024 at 10:48 am #15531094
Prosenjit Barman WPML Supporter since 03/2023 Languages: English (English ) Timezone: Asia/Dhaka (GMT+06:00)	Hello There, Thanks for contacting WPML Support. I understand your requirements. Although I'm not certain if WP ALL Export/Import directly supports Bricks Builder, if you're able to export the Bricks Builder content using the WP ALL Export plugin into a CSV file, you can manually add the translated content to this file before importing it to another site. After that, you can use the WPML Export Import plugin to link the translations with the original content. Before proceeding, there are some important considerations: - If you manage to export a CSV file from Bricks Builder, you should first import the main file into the other site. This ensures that the default content appears there with all the necessary information. - After the initial import, you'll need to add the translations to the CSV file. Additionally, it's crucial to configure certain parameters to ensure the default content is properly linked with its translations. Please refer to this guide for details on what needs to be configured: https://wpml.org/documentation/related-projects/wpml-export-and-import/preparing-import-files-for-wpml-export-and-import/#creating-spreadsheets-with-language-columns - Once your import file containing the translations is ready, import it to the site. Then, navigate to "WPML > Export and Import." Here, you'll find a button to run the import. Clicking this button will initiate the import process. After completion, both the default and translated contents will be properly connected. However, if you're considering creating a spreadsheet file for each post or page, with sentences separated as they appear in the translation editor, that won't be feasible. As far as I, the content in the spreadsheet is presented in one line per ID to reduce the size of the spreadsheet and better maintainability. I hope you can understand. If you need further assistance or clarification, feel free to let me know. I will be happy to help. Best regards, Prosenjit
April 17, 2024 at 10:52 am #15531096
Milan.Milicev	Ok, thank you for your help and clarification.