Change texts on Fat Client

Sometimes you need to change the translation on the Fat Client. This article helps you to customize the Fat Client surface.

This article is based on this WIKI entry (section 5.3 Localization):

http://wiki.produmex.name/doku.php?id=implementation:wms:custom_view#localization

Please note that the WMS update will overwrite this modification, take care to save the customized localization file.

Example

In this example we will change the following:

• The text of the ‘Reception’ button to ‘Receiving’
• The title of the ‘Select logistic carrier’ to ‘Select a pallet type’

Before	After

Identify the language code

At first check your language code in the Organizational Structure, General tab. In this example this is (3).

Identify the text

You need to find text, in this case this is the ‘Reception’ and ‘Select a logistic carrier’

You can find the text in two ways.

Search the text with query

You can search the button key from the database with this query. If you don’t want to type the entire text, feel free to use the % symbol in the ‘LIKE’ clause.

SELECT
   "PMX_LOKY"."AppTypeCode",
   "PMX_LOKY"."LocKey",
   "PMX_LOVL".LangCode,
   "PMX_LOVL"."Value"
FROM "PMX_LOVL"
JOIN "PMX_LOPR" ON "PMX_LOVL"."ParentKey" = "PMX_LOPR"."InternalKey"
JOIN "PMX_LOKY" ON "PMX_LOPR"."ParentKey" = "PMX_LOKY"."InternalKey"
WHERE 1 = 1
   AND "PMX_LOVL"."LangCode" = 3 -- Language Code
   AND "PMX_LOVL"."Value" LIKE 'Reception' -- Button or Title text
   AND "PMX_LOKY"."AppTypeCode" = 'SLIM_SCR'

SELECT
   "PMX_LOKY"."AppTypeCode",
   "PMX_LOKY"."LocKey",
   "PMX_LOVL".LangCode,
   "PMX_LOVL"."Value"
FROM "PMX_LOVL"
JOIN "PMX_LOPR" ON "PMX_LOVL"."ParentKey" = "PMX_LOPR"."InternalKey"
JOIN "PMX_LOKY" ON "PMX_LOPR"."ParentKey" = "PMX_LOKY"."InternalKey"
WHERE 1 = 1
   AND "PMX_LOVL"."LangCode" = 3 -- Language Code
   AND "PMX_LOVL"."Value" LIKE 'Select a logistic%' -- Button or Title text
   AND "PMX_LOKY"."AppTypeCode" = 'SLIM_SCR'

As you see the second query gave back more than one rows, you can choose the right ‘LocKey’. In this case this is the ‘MSG_TITLE_SELECT_LOGISTIC_CARRIER’

Search the text in the Localization.XML

You can find the texts in the ‘ImportLocalizationKeys.xml’ file.

You can find the xml file in the Installation Package under the ‘Localization’ folder.

Open it with a text editor and find the text (‘Reception’ and ‘Select logistic carrier’). If you used the query from the previous section, you can find that localization key too. It useable to use the Localization key, because the word ‘Reception’ appears several times in the file.

You need to find the XML entry <PmxLocalizationValue> with your language code (3).

Modify the localization file

Simply overwrite the text with the new desired text.

Import the modified localization XML file

To import these modifications you need to run the ImportTool that you can find in the following path:

c:\Program Files\Produmex\Produmex Tools\Produmex.Sbo.Logex.Tools.ImportTool.exe 

1. Set the connection
2. Set the import type as 'Localization'
3. Browse the file
4. Import

Create custom localization XML file

You can create your own custom localization XML file. I suggest this way, because the WMS version upgrade overwrite the custom localizations.

You need to query the Localization Key with that SQL query I provided it earlier. Please pay attention to LocalizationKey, LocalizationValue and LanguageCode.

Here is the the copyable XML structure.

<?xml version="1.0" encoding="UTF-8"?>
<TestRoot>

   <PmxLocalizationKey>
      <Canceled>False</Canceled>
      <LocalizationKey>MSG_BUTTON_RECEPTION</LocalizationKey>
      <ApplicationTypeCode>SLIM_SCR</ApplicationTypeCode>
      <LocalizationProperties>
         <PmxLocalizationProperty>
            <Canceled>False</Canceled>
            <LocalizationProperty />
            <ExtensionCode>CONVSTR</ExtensionCode>
            <LocalizationValues>
               <PmxLocalizationValue>
                  <Canceled>False</Canceled>
                  <LocalizationValue>Receiving</LocalizationValue>
                  <LanguageCode>3</LanguageCode>
               </PmxLocalizationValue>
            </LocalizationValues>
         </PmxLocalizationProperty>
      </LocalizationProperties>
   </PmxLocalizationKey>

   <PmxLocalizationKey>
      <Canceled>False</Canceled>
      <LocalizationKey>MSG_TITLE_SELECT_LOGISTIC_CARRIER</LocalizationKey>
      <ApplicationTypeCode>SLIM_SCR</ApplicationTypeCode>
      <LocalizationProperties>
         <PmxLocalizationProperty>
            <Canceled>False</Canceled>
            <LocalizationProperty />
            <ExtensionCode>CONVSTR</ExtensionCode>
            <LocalizationValues>
               <PmxLocalizationValue>
                  <Canceled>False</Canceled>
                  <LocalizationValue>Select a pallet type</LocalizationValue>
                  <LanguageCode>3</LanguageCode>
               </PmxLocalizationValue>
            </LocalizationValues>
         </PmxLocalizationProperty>
      </LocalizationProperties>
   </PmxLocalizationKey>

</TestRoot>