Print I18n sorted by ID/tag

Classic Servoy
1

Is it possible to print the i18n table messages orderen by ID, so i get a Jasper Report / Excel sheet like this:

Key                    EN              NL           GE
text.head            Head            Hoofd          Kopf
text.bread           Bread           Brood          Brot

I need it to let it checked by some external

2

Nobody?

3

Hi Dirc,

I suggest you use Excel with ODBC and a pivottable.
And I am sure you can do this with Jasper too but requires the ‘coding’ of a report.
In any case this can’t be done with 1 simple query.

Hope this helps.

4

Just write a query on the i18n table, selecting the distinct keys with 3 subqueries getting the value per language and then output the dataset any way you like.

Paul

5

I wrote:

ROCLASI:
In any case this can’t be done with 1 simple query.

Paul wrote:

pbakker:
Just write a query on the i18n table, selecting the distinct keys with 3 subqueries getting the value per language and then output the dataset any way you like.

I guess I was wrong.
Of course the language keys have to be known beforehand since you have to hardcode them in the subqueries.

6

:-) well, if you can get a list of the languages you want in the report, then you can just add as many subselects into the select statement inside a loop, making the whole report 100% dynamic

Paul

7

A plugin was born here ^^