IBM Support

Custom labels are not translating even after loading new translated values in to Language table (L_MAXATTRIBUTE).

Technical Blog Post


Abstract

Custom labels are not translating even after loading new translated values in to Language table (L_MAXATTRIBUTE).

Body

Why are my custom labels are not translating even after loading new Translated values in to Language table (L_MAXATTRIBUTE) ??

 

Issue details:

1)       We changed our profile language to PT and changed the label as specified by IBM in Application Design.
2)       The labels are showing correctly if we change our profile language to PT
3)       The issue is , the labels are showing in Portuguese even if we change the profile language to English.

 

Initial suggestions are :

You can translate tabs and fields in Application Designer.

To do this, Login to Maximo with Portuguese language.

Open the application in  Application Designer and edit all the labels needed.

Save it and test. Maximo stores the translated labels in L_MAXLABELS.

 

In this case we solved the issue after we found out that the user updated the MAXLABELS table with portuguese content aside from the L_MAXLABELS one. That is because :

> Translated label for the current language as defined in L_MAXLABELS
> Labels for the base language as defined in MAXLABELS table

 

Once he corrected the data in MAXLABELS table, the english message now looks good and the portuguese profile looks fine too.

 

The first thing to remember with Maximo is that you install it, and in so doing you create a Base Language.
The Base Language is recorded in the MAXVARS table. To find the Base Language use this SQL
SELECT VARVALUE FROM MAXVARS WHERE VARNAME='BASELANGUAGE';


It will provide a 2 character code for the Base Language in use  e.g.    EN   for English,  DE for German  etc


For additional Languages :
Installation of Base Language and also of additional languages creates rows in the LANGUAGE table.
To list all languages active on the system issue this SQL


SELECT LANGUAGENAME,MAXLANGCODE from LANGUAGE WHERE ENABLED='1';

Note - Issue the above SQL without the 'WHERE ENABLED='1' and you will get a list of all languages that are enabled or not.

Installing an  additional language will cause a number of tables to be created or updated which have the prefix ‘L_’

These are the tables that store the actual translation text entries.
There will be one of these L_ translation tables for each existing table which has translations available
e.g.  L_ITEM will hold the translations for the ITEM table
e.g. L_MAXLABELS will hold the translations for the MAXLABELS table

 

Maximo stores labels in multiple places. When you add a label to a field, tab or section in Application Designer, Maximo stores this in the application XML in the MAXPRESENTATION table and in the MAXLABELS table. For fields, labels are stored in Database Configuration, in the Titlefield of the attribute (MAXATTRIBUTE table). 

 

Labels in multiple languages :

 

To translate tabs and fields log in to Maximo selecting another language on the login page. Open the desired application in Application Designer and edit the labels of the tabs or sections. Maximo stores the translated labels in L_MAXLABELS table.
For fields, use Database Configuration to translate the title and description for an attribute while logged in with the other language selected. Maximo stores the translated labels in L_MAXATTRIBUTE.

When you are using multiple languages, the process of finding each label is slightly more complicated. This is the order in which the labels are searched:
1.    Translated label for the current language as defined in L_MAXLABELS table
2.    Label for the base language as defined in MAXLABELS table
3.    The application XML stored in MAXPRESENTATION table
4.    Translated title of the field for the current language as defined in L_MAXATTRIBUTE.TITLE table
5.    Title of the field for the base language as defined in MAXATTRIBUTE.TITLE table


How it works with multiple languages:


You can translate tabs and fields in Application Designer. To do this, select the other language on the login screen and log in. Open the application in Application Designer and edit the labels of the tabs or sections. Maximo stores the translated labels in L_MAXLABELS.

For fields, use Database Configuration to translate the title and description for an attribute while logged in with the other language selected. Maximo stores the translated labels in L_MAXATTRIBUTE.

 

See ya

 

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11112733