Technical Blog Post
Abstract
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
UID
ibm11113969