Translations of UI, table names and values

[andreasneumann]

• GUI forms and plugin GUI will be translated with QtLinguist
• table names and value lists will be automatically exported from the main database (through Metadatabase) --> create a .ts file from the database
• Generate a view for export of the dictionary and the value lists

[m-kuhn]

For the database to .ts converter.

The end result should look like this for german (untested)

<?xml version="1.0" ?>
<!DOCTYPE TS>
<TS version="2.0" language="de" sourcelanguage="en">
<context>
    <name>database</name>
    <message>
        <source>english</source>
        <translation>german</translation>
    </message>
    <message>
        <source>english</source>
        <translation>german</translation>
    </message>
</context>
</TS>

Instead of a database export into another format and subsequent processing to XML (.ts) it might be possible to achieve this file (or a file that needs only a little adjustment) by using postgres xml functions.

[3nids]

The function to list translated elements has been committed.
https://github.com/qgep/QGEP/blob/master/datamodel/translated_elements.sql

[3nids]

COPY (SELECT * FROM qgep.translated_elements()) TO STDOUT WITH CSV;

[3nids]

duplicate #46 ?

[m-kuhn]

Possible approaches (taken from #46):

• Script to translate the project file
• Have support for project file translation in QGIS core
• Instead of saving a project file load the project with a plugin

[m-kuhn]

• Translation of the project file for the demo project
• In the long run, load the project with a plugin and handle translation there

[m-kuhn]

That's how qwat does form translation: https://github.com/qwat/qWat/tree/master/qwat_dictionary

[m-kuhn]

@kfischerar takes care that field names are also translated in the database.
We will then probably generate a .qm translation file from the database.

[3nids]

@andreasneumann wasn't it you that woud ask Stefan a translation table.

I would expect to get these columns

• table name
• field name
• field name in plain english
• field name in plain french
• field name in plain german
• field comment in plain english
• field comment in plain french
• field comment in plain german

Does it make sense?

[m-kuhn]

Database to .ts converter for database term translation.
For further translations, done on transifex https://www.transifex.com/projects/p/QGEP/