WPML Import: Import Data in different format files with CSV Importer plugin

WPML plugin in WordPress allows you to run a multilingual website for your business. With WPML you can translate post, page, custom post, taxonomies and themes.

But when you are planning to cover all the country it takes time, right?

To simplify this WP ultimate CSV importer plugin lets you upload content in different types of file formats. Here in this blog, we explained the step-by-step process of uploading files, mapping the fields, and import data with WP Ultimate CSV Importer. 

wpml-data-import-upload-different-format-files-in-various-methods.jpg

Import CSV, XML, Text and Zip files with WP Ultimate CSV Importer 

WP Ultimate CSV importer supports XML file import, text file import, and zip file import in addition to the CSV file import. 

import-xml-zip-text-file

How to import file?

Import process includes the following steps:

  • Upload File.
  • Mapping Section.
  • Media Handling Section.
  • Import Section.
  • Import Verification.

UPLOAD FILE

The plugin supports multiple types of file format import and schedule. It supports XML, zip, text and CSV file format. Initial step to import this file is to upload the required file.  The upload process is the same for all the four file formats. There are four different ways to load these files. Required files can load by browsing the file from the computer, FTP, external link, or server.

Upload File (from the computer)

Click the “Browse” button to load the required file from the computer. The drag and drop method can also be used. Instead of using the Browse button.

Upload using FTP/SFTP

To load using FTP/SFTP provide the details such as host name, path, FTP username, FTP password, and port number.
Sample value:
Hostname: smackcoders.com or 54.213.74.129
Path: /var/www/posts.csv or /var/www/posts.zip
FTP username: smackcoders
FTP password: smackpassword
Port number: 21 (by default it is 21)

Now click on the “Download” button to download the file from the FTP server.

Upload from an external link

To load from an external link provide the URL path of the required file. You can include the Google sheets link here. Example: http://hostname/path/post.xml

Choose a file in the server

Select the required file from the directory list. After loading the file, Choose ‘New item’ option if you want to import new data in WordPress.

Select ‘Existing items’ to update the fresh content on WordPress. Next, choose the Post type from the dropdown and click ‘Continue’. It gets redirected to the mapping section. 

Mapping

CSV mapping View Mapping fields rightly helps you import the content on the correct field location. You can map here the CSV headers with WP fields.

1. In the mapping section, the basic fields grouped under “Core Fields”. The default WordPress fields grouped under default WP fields and other custom fields, the fields of supported plugin grouped separately under each plugins name. For example, if the ACF plugin is activated, WP fields of ACF displayed under ACF CUSTOM fields. ACF field enabled under Custom Taxonomy is an added feature in this version.

2. If the WP fields and file headers are the same then it will auto-mapped, if not, map it manually.


3. The mandatory fields should map and it cannot leave blank. Post title(post_title) is mandatory for all the modules.

4. In WooCommerce variation, the Product ID and Parent SKU are mandatory. For WooCommerce orders, the Order ID is mandatory. In WooCommerce coupons, Coupon ID is mandatory. Woocommerce refunds, Refund ID is mandatory.

5. Specify the static or dynamic/formula content of WP field name within curly braces ( {} ). For static, providing {post_status}, the value of post_status will be assigned. Here multiple WP field names can be concatenated by plus(+). Example, {post_title}+{post_author}+{post_status}. The ‘ + ‘ symbol will create a space in between the content so need not give space manually.

6. In dynamic/formula, basic arithmetic operators such as +, -, *, /, % are supported. Specify the WP field name in curly brace( {} ) and separate by operators. Example, {product_quantity}/{product_discount}.

7. To save the mappings as a template click on “Save this mapping as Template”. Enter the
name in which the template need to be saved.
The template page consists of a list of already created mapping templates. This is shown if you have saved the mapping already and if you’ve chosen the ‘Existing items’ option after you upload the file.


Click on the “Continue” button to proceed further.

Import Multilingual WPML data without logging into your WordPress

Rather than maintaining all your values in a CSV file, bring all into a Google Sheet. Start reflecting all the changes you do in Google Sheet get automatically mirrored in WordPress.
 
1. Navigate to the Upload From URL section in WP Ultimate CSV Importer. Use the Google Sheet URL here and click on Continue.

2. Now choose the post type from Import Each Record As dropdown and click on Continue.

3. Relate your CSV and WordPress fields. Once save your mapping template and click on continue. The template will be saved automatically once you’ve navigated to the next section.

4. In the 4th step, enable Do you want to schedule this import? Checkbox. Choose the Date, Frequency, and Time to run the import automatically at the back end.Finally, click on Schedule.

5.Once done, you can just make your changes in Google Sheets, it will automatically get reflected in your website without any manual intervention.

XML mapping view:

The file headers drop-down content is different from the CSV file import. The mapping headers are prefixed with post_xxx-items–>node–>

Sample:
i) For post title it is like post_title – items–>node–>post_title
ii) For post content it is like post_content – items–>node–>post_content

Text file mapping view:

The text file mapping view is the same as that of the CSV file mapping view.

ZIP file view:

The zip file is a folder that contains a number of XML, CSV or text files. Their view is same as that of the file imported.

Media Handling

Media Handling lets you upload external images in bulk. You can import images included on your post, page, WooCommerce, or any other post type. If you want to use this section, just enable the ‘Download external images to your media’ option.

wp-ultimate-csv-importer-import-acf-fields-information.png

IMPORT SECTION

To import the file directly or immediately into WordPress, select the “Import” button. This Import Configuration Section comes up with advanced options like rollback, enabling maintenance mode to ensure safety import data on WordPress.
1. To detect and skip duplicate content, enable the ‘Do you want to handle the duplicates on existing records?’ option.
2. Use the ‘ Enable safe Prestate Rollback (Backup before Import)’ option. If you want to revert the previous state of the website if in case any problems arise while importing.
3. Use the ‘Do you want to SWITCH ON Maintenance mode while import?’ option to notify the visitors that your website is under maintenance.

Perform Scheduling:

You can also schedule your data import right from here. For that, enable the ‘Do you want to Schedule this Import? Option. Then provide the Schedule date, Schedule time, Schedule Frequency, and Time Zone. Choose the frequency as per the requirements.

IMPORT VERIFICATION

Once you click on the ‘Import’ button, please wait for the Import to be done completely. You will see the ‘Import Successfully Completed’ message if the records are imported successfully.  Click on the ‘View Log’ button to verify the Import. You can verify the import in both ‘Web View’ and ‘Admin View’.

An Illustration, Let’s consider publishing a blog post about Audi Car Q7 in 4 different languages. It includes a set of Toolset Types Repeatable field group to specify the model variants like mileage, fuel type, and price.

  • Parent Group Name – Audi
  • Repeatable Field Group Name – Models
  • Fields in the Repeatable Field Group – Name, Mileage, Fuel Type, Price, Image
How to prepare your CSV file?

You can prepare your own CSV based on your requirements. The CSV values are needed to be in the standard WordPress format. To know more about the CSV values, refer to our CSV Importer user guide. Let’s start with adding the header fields,

  • post_title, post_content, post_excerpt, post_date, post_category, post_tag, post_author, post_slug – Basic post fields.
  • relation_slug – Add the Repeatable group slug. Generally, the slug is automatically generated as you enter your group name. For multiple Repeatable Field Group mentions the slug values in Comma(,) separation.
  • car_name, car_mileage, car_fueltype, car_price, car_image – Fields used in Toolset Types Repeatable Field Group.

To import this post in multiple languages,

language_code – Specify your language code here.

To relate your translated post to your default post,

translated_post_title – Mention the post title name.

Now let’s add the values.

  • post_title, post_content, post_excerpt, post_author, post_slug – Add you own text values here.
  • post_date – Follow the default WordPress format yyyy/mm/dd
  • post_category – Mention your category name.

Here I’m going to choose two different categories(i.e. Multiples categories – Car, Audi) → Mention these values using “|” separator. So CSV Value is Car|Audi

And there is also a nested category Q7 under the category Audi. Mention uses a hyphen and greater than symbol (->) – Audi->Q7. Learn more about post category import.

  • post_tag – Mention the tag name. To add multiple tags, use comma(,) separator → Car, Audi, Q7.
  • relation_slug – You can get this from your Toolset Types Plugin.
  • Repeatable field Group field values – Use the exclamatory(!) symbol.
  • car_name – Q7 45 TDI Quattro Technology! Q7 45 TDI Design Edition! Q7 40 TFSI Quattro Premium Plus!Q7 40 TFSI Quattro Technology.
  • car_mileage – 14.75!14.75!13.55!13.5, car_fueltype –Diesel!Diesel!Petrol! Petro
  • car_price – Rs.85.18L!Rs.81.99L!Rs.73.73L!Rs.81.0
  • car_image – image_url!image_url!image_url!image_url, language_code and related_post_title – add your language code and parent post title of your translated post.
End Tips

Now you’ve created your own multilingual website. That’s it? Definitely not, you need to make your content ever fresh with periodic updations – updating each and every website content in multiple languages. 

  Hope you find this article useful, let us know your thoughts and comments via email [email protected]. To know more about the complete features of WP Ultimate CSV Importer please pay a visit to our product page. 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.