Topic: Exporting translations to Excel compatible format

Topic type:

Kete 1.3 provides the ability to export a translation to an Excel compatible format.

Exporting to Excel compatible format

Kete 1.3 provides the ability to export a translation to an Excel compatible format (a specially crafted XML document that Microsoft Excel 2003/2007 and OpenOffice 3 can read and write to).

Note: In the case below, I demo exporting a Chinese translation (zh). If you want a different translation, then change 'zh' to the appropriate two letter country code.

To get started, make your translation file. You don't need to translate it all, just needs a copy of the english file, with an altered language key at the top. There is a rake task that does this. Run:

$ rake translate:create LOCALE_CODE=zh LOCALE_NAME=Chinese

Then you're good to go. Run the following rake task to export the translation.

$ rake translate:excel_2003:export LOCALE=zh

The new exported translation will then be available in tmp/zh.xml

Importing from Excel compatible format

There is a corresponding rake task for importing from Excel data (that has been exported to XML):

$ rake translate:excel_2003:import LOCALE=zh FILE_PATH=/path/to/excel-exported-xml-file

Discuss This Topic

There are 4 comments in this discussion.

Read and join this discussion

join this discussion

Creative Commons Attribution-Share Alike 3.0 New Zealand License
Exporting translations to Excel compatible format by Kieran P is licensed under a Creative Commons Attribution-Share Alike 3.0 New Zealand License