CMDBuild Forum

How to change language in reports and print cards

Old Versions
#1

Hi all,

We are using CMDBuild with Japanese language and it works fine on WEB UIs, but I could not find how to change language in reports and print cards.

We can modify static text in Jasper reports and it can print Japanese correctly, but lookup/reference attributes of each cards only output english.

Also print cards in excel/pdf only output english attributes.

Please let me know how to print data in _Translation table.

 

Regards,

Satoru Funai

#2

In the current implementation of the CMDBuild reporting system the printed information are retrieved from the SQL query in the language in which they are extracted.
If you want to print the lookup in a different language you have to put in joins the "_Translation" table using this condition:

"_Translation"."Element" = 'lookup.' || "LookUp"."TranslationUuid" || '.description' and "Lang" = 'jp' -- [or 'it' or 'fr', etc]

CMDBuild Team

#3
It means we need to modify functions of Postgresql for Japanized report (e.g. rep_locationswithassets() for LocationWithAsset report in Ready2Use), right?
Are there anyway to Japanize output from "Print Card" of "List View"?
 
Regards,
Satoru Funai
 
Previously Tecnoteca wrote:

In the current implementation of the CMDBuild reporting system the printed information are retrieved from the SQL query in the language in which they are extracted.
If you want to print the lookup in a different language you have to put in joins the "_Translation" table using this condition:

"_Translation"."Element" = 'lookup.' || "LookUp"."TranslationUuid" || '.description' and "Lang" = 'jp'               -- [or 'it' or 'fr', etc]

CMDBuild Team

 

#4

Yes, you have to modify the PostgreSQL functions.

For the second question, at this time the location of the two reports "Print Card" of the "List View" is not handled properly. We can not enter the correction in the 2.4.2 release now very close, it will be part of the next release.

 

CMDBuild Team