Localization of Content Management System (CMS) Websites
In this edition, we will be wrapping up our series on website localization with a discussion of Content Management System, better known as CSM. However, before we go into the localization process itself, allow me to provide a brief introduction of how this type of system works.
CMS is a set of tools installed on a server that are combined for the purpose of assisting with the administration, modification, publication and maintenance of online content, from simple websites to the most complex portals.
may contain several resources and features, including
There are several CMS tools available, yet only a few offer multi-language support. Before a CMS can be considered ready for localization, it must allow for proper identification of the language of the text to be entered in each page.
Let’s see how the differences between the CMS models interfere with website localization:
This means that the system is prepared to deal with multiple languages for each page. In this case, the same body text, title and subtitle of a page will have several entries in the database, one page for each registered language. See the example in the database table below:
To translate the content of this type of website, it is necessary to extract the texts together with the page identifier (pag_num), category and language into a translation-friendly file format. This process helps the localizer to reinsert the text into the database after the text has been translated into the target language.
In such cases, SQL language is normally used to extract and reinsert the text. While inserting the text, the new database entries will have the acronym of the new language in the “language” field, which in this example is Brazilian Portuguese (pt_BR).
The example below demonstrates how to insert text in Argentine Spanish (es_AR) into page 1:
SQL> insert into text_table set (page_num, category, text, language) values (1, “title”, “Bienvenidos a nuestro sitio Web!”, “es_AR”);
SQL> insert into text_table set (page_num, category, text, language) values (1, “subtitle”, “Línea de productos cosméticos”, “es_AR”);
CMS Not Ready for Localization
Although it takes more engineering time to successfully complete extraction and insertion, systems that are not developed for this purpose can still be localized.
The engineering team of the localization company should contact the client company’s webmaster or website developers to analyze how CMS operates. Hence, they will be able to evaluate the best method for extracting and reinserting the translated texts.
In this case, although extraction can be automated, reinsertion of the translated text will be done manually through the very interface of the CMS. This is because the system cannot detect that the text being entered is the translation of an already existing page, only in another language. As a result, it is necessary to generate a new page ID for each localized page.
This insertion procedure can also cause other problems such as the need to create a new menu that points to the new IDs of the translated pages. See the difference between the two types of CMS in the tables below:
CMS Not Ready for Localization:
Regardless of whether the CMS has been developed for localization or not, if it is not possible to have direct access to the database table where the texts are stored, the extraction process may become more complicated. In the worst case scenario, this would have to be a manual process, adding to the effort and increasing the time required to complete the process.
Of those systems that do not allow direct access to the database, very few have their own tool for exporting text to a file (whose extension is usually .xml or .csv). However, even those CMSs that have extraction tools rarely offer the means to enter translated content. Either the absence of an extraction tool or a device to re-enter text makes the localization process equally difficult.
At any rate, website localization with CMS tools vary from case to case and system characteristics must always be evaluated before determining the costs and the time required for localization. If you plan to create a website using CMS tools, please bear in mind the issues described above and feel free to contact Ccaps so that we can help you evaluate the best way to get your project started.
This article was originally published in Сcaps Newsletter (http://www.ccaps.net)
Please see some ads as well as other content from TranslationDirectory.com: