Localization Solution of the Moment Series Part 1
In the first part of our “Solution of the Moment” series our localization solutions architect Jakub describes a new automation tool he created which saved a project both time and money.
1. The localization solution challenge
One of our customers uses Multilizer 5 as their localization software, which stores translation documents in a custom file format (MPR). Until now, we did not have an easy way importing these files into memoQ, our primary CAT tool. The preparation process included copying and pasting translatable strings to separate Excel sheets manually, then putting back translated content to the Multilizer project file in the same way. This slow and tedious workflow had to be repeated for up to 7 languages, with 5-10 separate Multilizer projects per one hand off. Needless to say how time consuming both pre- and post-processing tasks were, not to mention the increased risks of making mistakes during performing them manually.
2. The solution
We have created a simple Python script that supports ‘lossless’ transfer of translatable contents between Multilizer and memoQ using XLIFF format as carrier. This automation tool can be used for a variety of tasks – from small projects to the localization of a full scale CMS: it extracts the translatables from the received Multilizer file, creates XLIFF files per target language that can be directly imported to memoQ. In post-processing it puts the localized content back into the Multilizer MPR file. Additionally the tool allows processing multiple MPR files at once, and also supports extracting already translated strings from the MPR file to XLIFF. This feature comes handy in validation scenarios.
3. The Benefits
Utilizing this script significantly decreased the time spent with pre – and post-processing. Average preparation times decreased from 2 hours to less than 30 minutes per hand-off. Post-processing now takes only around 2 hours instead of 8 that used to take up a whole workday of an engineer. Also, since manual operations are ruled out in the new workflow, it became easier to assure expected quality levels. Automated processes are more robust and repeatable, furthermore they lower the chances of human errors. Developing automation tools is a one-time investment that soon earns its price by shortening and simplifying workflows which is desirable for the company and the client alike.