WP Ultimate CSV Importer supports three multilingual plugins.
- qTranslate X import
Import for WPML Multilingual
With WP Ultimate CSV Importer import multiple language data uninterruptedly in a single CSV file into your WordPress multilingual site. Importing and exporting of your WordPress multilingual site’s Post, Pages, Custom Post, WooCommerce, MarketPress, WP eCommerce, Categories, Tags and Custom Taxonomies in any languages are possible. If you not yet purchase WPML plugin, click here to purchase now.
Prepare your CSV
First of all, prepare a proper CSV to import the content into your website.
- In your CSV, the first row should be headings of fields that are used for mapping.
- To import your translated content into WordPress, add two extra fields ‘language_code’ and ‘translated_post_title’ in your CSV file, instead of using these header names you can give your desired names. In the ‘language_code’ field, mention the language code of your default and translated post.
- The other field ‘translated_post_title’ is to relate the translated post with the default post(the post you’re translating in multiple languages). Mention the heading of the default post(post_title) in the ‘language_post_title’ field.
Start importing data with WP Ultimate CSV Importer
- In your WP Ultimate CSV Importer plugin, navigate to the ‘Import/Update’ section.
- Upload your CSV file in any of the four methods of Import.
- After uploading, choose your post type from ‘import each record as’ dropdown.
- If you are importing the CSV as new, then check the ‘New Items’. Otherwise use ‘Existing Items’ to update the already existing content.
- Click Continue.
- In the mapping section, map the fields of WP fields related to the CSV headers. The plugin automatically maps the fields if WP fields are similar to CSV headers.
- In WPML Fields map the language_code, and translated_post_title fields.
- Save the mapping by providing a name in ‘Save this mapping as’ field, so that you can use it as a template in the future.
- Select continue.
- Use the media handling section, if you want to import any external images. You can avoid creating duplicates by enabling the options like ‘use media images if already available’ and ‘permission to overwrite existing images’.
- Map the necessary image fields here.
- Continue and in the importing section, you can schedule your import to be done later or you can import instantly using the ‘import’ button.
- To schedule, check the ‘Do you want to Schedule this import?’ option and provide the schedule date, frequency, time zone and time. Then select ‘Schedule’.
- Now click on the ‘import’ button to import the content on the website.
Wait for a few seconds, the import will be completed. Visit the post in your WordPress to make sure your import has done successfully.
Exporting your multilingual data
To export your WPML multilingual website data, tap the ‘Export’ menu in WP Ultimate CSV Importer.
- Choose the WordPress module that you want to export. You can see the records count shown in the top right corner.
- Select continue. Note if the selected module has no records to export then you can’t proceed to the next step.
- Add the file name to export.
- In the Advanced settings choose the export type. WP Ultimate CSV Importer allows you to export in four different file formats such as CSV, XML, XLS, and JSON.
- You can split and export your data if your website has a bunch of data to export. Check the ‘Split the Record’ option and give the value. For example, if you give the split value as 100, the first 100 records will be in 1st CSV and the next 100 records in 2nd CSV and so on. Note that, by default, the export will be done in CSV format.
- Advanced filters like export with auto delimiters, export with a specific status, etc., are used to filter and export the required data. WP Ultimate CSV Importer provides the possibility to schedule your export. Follow the steps in the link and export your content from WordPress.
WPML Fields to add in your CSV
|WPML fields||Description & CSV Values||CSV Sample values|
|language_code||Mention the code of the translated language||ar|
|translated_post_title||Provide the default post_title from where the post translated||Anne of Green Gables|
1. How to prepare a CSV file?
The CSV file needs to be in UTF-8 format. You can export the existing content as a CSV file for you to have an exact sample of your data. You can also refer the documentation on how to prepare CSV file or download free samples from Sample CSV blog.
2. How can I validate my CSV to confirm UTF-8 standard?
You can upload your CSV file in http://csvlint.io/ and validate it.
3. How can I debug my file if I found any errors with the format or column mismatch?
The CSV file prepared with Microsoft Excel may have column mismatch errors or some kind of formatting issues. In this case, you can upload the CSV file prepared in your Google drive and again download it as a CSV file.
4. Can I have different header names for the WPML fields in my CSV file?
Yes, you can. WP Ultimate CSV Importer doesn’t have a restriction in naming your CSV headers. You can give your own name and in mapping, carefully relate the CSV headers mentioned in CSV to its corresponding WordPress fields.
5. Does the plugin allow import of CSV/XML from external URLs?
Yes, the plugin allows you to upload your CSV or XML file from publicly accessible external URLs such as from Google sheets. You can schedule the import process and make any changes in your Google sheet to get those modifications automatically updated on your website with no manual interference.
The FTP import can help you upload the CSV/XML file stored in different servers.
6. Which Ultimate CSV Importer editions support WPML multilingual import?
- WP Ultimate CSV Importer Pro supports import, update, schedule and export of WPML CSV/XML files. And it costs $199 with lifetime FREE support & upgrade.
- WP Ultimate CSV Importer – also offers a separate package named ‘WPML Importer’ supports import, update and schedule of both CSV & XML files. It costs $149 and comes with lifetime FREE support & upgrade.
7. Does the plugin support import of translated taxonomies?
Yes, the plugin do support import of translated taxonomies too along with any Post Type import.
qTranslate X Import
qTranslate X Import Sample CSV File
qTranslate X lets you import dynamic multilingual content. You can import the individual fields of your CSV in multiple languages by specifying the language code in the corresponding field with the syntax [:en].
For example, If you need the Title of the page in Japanese, you can specify as [:ja]Title. It’s output will be タイトル(title)