Easy, easy, easy…
We all know the advantages of WordPress! It’s ridiculously easy to use, doesn’t require PHP or HTML knowledge, and all you need to start is to choose a plugin or template and click on it to install, which makes it a great choice for beginners.
The good news is that plugins like WPML or Qtranslate can be a major asset in handling the translation process of a website that is powered by our beloved WordPress. What is what, you say? Let me explain in the easiest possible way: WPML is a user interface of a Translation Management System.
Essentially, it allows you to run a multilingual website with a single WordPress installation, giving you a User Interface to handle all of your content translation in a single place – like WPML and other UI descriptions, screenshots and more.
The XLIFF format (Localization Interchange File Format) to be exact, is an XML-based format created to facilitate interoperability between different localization and translation tools. Cool, no? It is basically an ideal format for assisted translation tools.
Now the important part- what’s IN there? So, the XLIFF files contain the entire content marked for translation, which also includes the title, body and even any custom fields that have been enabled for translation.
To use the XLIFF translation interface, you need to have WPML’s Translation Management module activated. With the XLIFF module, you will be able to send XLIFF files as email attachments from the Translation Dashboard and when translations are complete, you can easily upload them.
Just look at this to imagine the process:
How does WordPress handle the translation process natively?
There are two ways the translation of a WordPress-based website is performed:
1) From the WordPress dashboard
To be honest, any experienced translator can perform translation from the dashboard in the text editor, working on posts, pages and slugs. The only problem with this method is that the translator is unable to use assisted translation tools, which would allow them to see texts in parallel, and to use of glossaries and translation memories. Also, they may have no knowledge variety of different HTML tags.
2) Through assisted translation tools.
It would be necessary to previously export the content using a format that is friendly for assisted translation tools such as CSV or XLIFF that we’ve been talking about. Translation of text strings can be performed by using POT (Portable Object Template) and PO (Portable Object) files that developers put at users’ disposal.
PhpMyAdmin: export and import CSV files
WordPress content can be translated from the admin panel but also through computer-assisted translation tools (CAT tools), as either CSV or XLIFF files (pages, posts and categories) or through PO files (text strings contained in themes or plugins).
CSV files comma-separated values are, on the other hand, a type of document that allows you to represent data in tabular form. Assisted translation tools ‘understand’ these files perfectly even if they contain HTML code.
WordPress uses PHP language as well as a database to store and retrieve information contained in a series of tables, each of which has a different mission.
For the management of MySQL databases, there is an excellent tool called phpMyAdmin that allows you to export and import the content in different formats: CSV, PDF, XML, Word, YAML, SQL and more.
For any normal WordPress user, it’s not really necessary to know the structure of the WordPress database. However, exporting and importing content through phpMyAdmin is pretty much essential to understand the functioning and structure of the tables in the WordPress database.
After successful translation, the CSV Excel file must be imported to the appropriate tables of the WordPress database using phpMyAdmin.
Another option that allows you to export and import content in CSV format is simply using a plugin. There are both free plugins (for example, WP CSV) and ‘freemium’ plugins (WP Ultimate CSV Importer Plugin which also has a free version) available that allow the export and import of CSV files.
Although it may not sound like a piece of cake – it pretty much is!
The WordPress experience is exactly the place where plugins come in and make the translation of your website continuous, manageable and – perhaps, the most importantly – much easier. And you have much more control and insight over all of your (un)translated content.