notyetgames / po-excel-translate

Use excel files to update translations from po (portable object) files

Translating via spreadsheets

Not all translators are comfortable with using PO-editors such as Poedit or translation tools like Transifex. For them this package provides simple tools to convert PO-files to xlsx-files and back again. This also has another benefit: it is possible to include multiple languages in a single spreadsheet, which can be helpful when translating to multiple similar languages at the same time (for example simplified and traditional chinese).

The format for spreadsheets is simple:

• If any message use a message context the first column will specify the context. If message contexts are not used this column will be skipped.
• The next (or first) column contains the message id. This is generally the canonical text.
• A set of columns for any requested comment types (message occurrences, source comments or translator comments).
• A column with the translated text for each locale. Fuzzy translations are marked in italic.

IMPORTANT: The first row contains the column headers. xls2po uses these to locale information in the file, so make sure never to change these!

Comparison

NOTE: Original code of this was taken from https://github.com/wichert/po-xls

Advantages of this implementation:

• sane defaults
• the first row and first columns are freezed so that you can always see the source string you want to translate
• customizable options like width/wrap/protected ranges/fonts
• can use the exporter/importer from another python project, you just import the library after installing it:

from pathlib import Path
import po_excel_translate as poet

# po2xls
po_files_to_convert = [
	poet.PortableObjectFile("ro-example.po")
]

poet.PortableObjectFileToXLSX(
	po_files=po_files_to_convert,
	comment_types=[poet.CommentType.SOURCE],
	output_file_path=Path("ro-example.xlsx")
)

# xls2po
poet.XLSXToPortableObjectFile(
	locale="ro",
	input_file_path=Path("ro-example.xlsx"),
	output_file_path=Path("ro-example.po")
)

Install

From repository

pip install .

From pypi

pip install po-excel-translate

Portable Object (.po) to spreadshseet (.xlsx)

Converting one or more PO-files to an xls file is done with the po2xls command:

po2xls nl.po

This will create a new file messages.xlsx with the Dutch translations. Multiple PO files can be specified:

po2xls -o texts.xlsx zh_CN.po zh_TW.po nl.po

This will generate a texts.xlsx file with all simplified Chinese, traditional Chinese and Dutch translations.

po2xls will guess the locale for a PO file by looking at the Language key in the file metadata, falling back to the filename if no language information is specified. You can override this by explicitly specifying the locale on the command line. For example:

po2xls nl:locales/nl/LC_MESSAGES/mydomain.po

This will read locales/nl/LC_MESSAGES/mydomain.po and treat it as Dutch (nl locale).

You can also use the -c or --comments option with one of those choices: translator, extracted, reference, all to add more column in the output.

Spreadshseet (.xlsx) to Portable Object (.po)

Translations can be converted back from a spreadsheet into a PO-file using the xls2po command:

xls2po nl texts.xlsx nl.po

This will take the Dutch (nl) translations from texts.xls, and (re)create an nl.po file using those. You can merge those into an existing po-file using a tool like gettext's msgmerge.

po-excel-translate's Issues

VERSION file not found on Python 3.6 after install

Error on Python 3.6
I used pip install po-excel-translate to install.

xls2po fr-FR ./messages.xlsx ./fr-FR.po

Traceback (most recent call last):
  File "c:\users\XX\appdata\local\programs\python\python38-32\lib\runpy.py", line 192, in _run_module_as_main
    return _run_code(code, main_globals, None,
  File "c:\users\XX\appdata\local\programs\python\python38-32\lib\runpy.py", line 85, in _run_code
    exec(code, run_globals)
  File "C:\Users\XX\AppData\Local\Programs\Python\Python38-32\Scripts\xls2po.exe\__main__.py", line 7, in <module>
  File "c:\users\XX\appdata\local\programs\python\python38-32\lib\site-packages\click\core.py", line 1128, in __call__
    return self.main(*args, **kwargs)
  File "c:\users\XX\appdata\local\programs\python\python38-32\lib\site-packages\click\core.py", line 1053, in main
    rv = self.invoke(ctx)
  File "c:\users\XX\appdata\local\programs\python\python38-32\lib\site-packages\click\core.py", line 1395, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "c:\users\XX\appdata\local\programs\python\python38-32\lib\site-packages\click\core.py", line 754, in invoke
    return __callback(*args, **kwargs)
  File "c:\users\XX\appdata\local\programs\python\python38-32\lib\site-packages\xls2po.py", line 19, in main
    XLSXToPortableObjectFile(locale=locale, input_file_path=Path(str(input_file)), output_file_path=Path(output_file))
  File "c:\users\XX\appdata\local\programs\python\python38-32\lib\site-packages\po_excel_translate.py", line 419, in __init__
    with open(os.path.join(root_dir, "VERSION")) as version_file:
FileNotFoundError: [Errno 2] No such file or directory: 'c:\\users\\XX\\appdata\\local\\programs\\python\\python38-32\\lib\\site-packages\\VERSION'

After check file c:\users\XX\appdata\local\programs\python\python38-32\lib\site-packages\VERSION does not exist.
Commented line 419 of "po_excel_translate.py". Works like a charm.

Note : po2xls works without this fix.

Thank you for your work !

Add option to move untranslated strings to the top of the excel file