Re: [poedit-users] ordering the translations?

G'day Kae

Vaclav wrote:

> Here's a tip how to make this much easier: download Translate Toolkit
> from translate.sf.net and use its po2csv and csv2po command line tools.

I agree with Vaclav on the use of the Toolkit if you're a project 
manager trying to balance a number of languages.  I do it myself (I'm an 
admin at pootle.locamotion.org and some of the stuff needs to be done 
offline by me).

Allow me to hijack this thread with instructions on using the Toolkit.
http://translate.sourceforge.net/wiki/toolkit/index

If you send only the untranslated stuff to your translators, then I 
suggest you do the following (using the Toolkit):

1. Use pofilter to get the untranslated strings from the original PO file.
2. Use po2csv to create a CSV file (can be opened in Excel).
3. Send the Excel file to the translator.
4. Get the Excel file back from the translator.
5. Use csv2po to recreate the PO file (and visually check to see if the 
encoding is correct -- Excel tends to mess things up sometimes)
6. Use pomerge to merge the translations back into the original PO file

The commands are:

1. pofilter -t isfuzzy -t untranslated original.PO untranslated.PO
2. po2csv untranslated.po untranslated.po.csv
5. csv2po translated.po.csv translated.po
6. pomerge -t original.po -i translated.po -o mergedfile.po

These tools can also be run on directories with subdirectories instead 
of PO files.

> Use po2csv to understand what kind of CSV files csv2po expects, then
> massage your spreadsheet into this form and export it as CSV.

Basically it must be three columns, with source and target in columns B 
and C, and the character encoding must be right also (and it's a pity 
that neither Excel nor OOo Calc seems to get this right 100% of the 
time).  CSV is actually a very dangerous format if you're not careful.

Samuel

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08