Enabling multi-language support - a simplified set of instructions

Body

The first step to using multiple languages with Maximo is to ensure that the multilanguage pack is installed.

The Tpae Solution installer is typically found in c:\ibm\smp\bin
Language packages are in found by default in c:\ibm\smp\pmp

To install the language pack you wish to use, I have provided an example of the command below using the Solution installer

c:\IBM\SMP\bin>solutionInstaller.bat -action install -pkgpath c:\ibm\smp\pmp\PAE_Lang_Pkg_7.5.0.6_Es.zip -dbpwd maximo -dbuser maximo -license accept

Rebuild and redeploy the maximo ear once the installation is complete

Then run the following command to export all data you wish to translate.  See additional documentation for what will and will not be automatically be translated.  In this example, we want the automatically translated synonymdomain values which will be translated and stored in the L_SYNONYMDOMAIN table:

c:\IBM\SMP\maximo\tools\maixmo\TDToolkit.bat -export

This exports all data to be translated from translatable columns and stores them in files located here:

c:\IBM\SMP\maximo\tools\maximo\xliff\export

Next, use the following command to translate and load the language files using the language you wish to use:

c:\IBM\SMP\maximo\tools\maximo>TDToolkit.bat -ADDLANGES

Where -ADDLANG is the command to add the desired language, and ES is the language code.

To find the correct language code you wish to use, use the following sql query:

select languagename,maxlangcode from language

For the Spanish language code, the MAXLANGCODE to use is shown below:

LANGUAGENAME    MAXLANGCODE
Español                    ES



After updating your records, verify the results using the following sql statements:


select domainid, maxvalue, value, synonymdomainid from synonymdomain where domainid='SRSTATUS'


The results will show a list of available statuses as shown below;

DOMAINID    MAXVALUE    VALUE     SYNONYMDOMAINID
SRSTATUS    HISTEDIT      HISTEDIT       241
SRSTATUS    QUEUED      QUEUED        233
SRSTATUS    NEW            NEW              234
SRSTATUS    INPROG       INPROG         235
SRSTATUS    PENDING     PENDING       236
SRSTATUS    RESOLVED  RESOLVED    239
SRSTATUS    CLOSED      CLOSED         240

Use the synonymdomainid value to compare what is in the L_SYNONYMDOMAIN table using this command using the resulting synonymdomainid value for the OWNERID in the next statement as shown below:

SELECT DESCRIPTION,OWNERID,LANCODE FROM l_synonymdomain WHERE ownerid in ('241','233','234','235','236','239','240')

The results look like the following translated values:

DESCRIPTION            OWNERID    LANGCODE
En cola                       233           ES
Nuevo                         234            ES
En progreso                235            ES
Pendiente                   236            ES
Resuelto                     239            ES
Cerrado                       240            ES
Editado en historial      241            ES

Restart Maximo

Additional reference materials:

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20Maximo%20Asset%20Management/page/Multi-language%20capabilities?section=Multi-languagecapabilities-AddalanguagetableintheDatabaseConfigurationapplication

http://www-01.ibm.com/support/docview.wss?uid=swg21588326

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM+Maximo+Asset+Management/page/Attribute+and+domain+functions