Managing Translations Using Salesforce Dataloader
Using Salesforce Dataloader, you can define or update in bulk the translations of strings supported by the ServiceMax Translation Workbench for any language. The language codes for the languages supported by the ServiceMax application OOTB are given in the table below. These codes are the same as used by Salesforce. Use these when defining or updating translations.
|
Language
|
Language Code
|
|---|---|
|
Chinese (Simplified)
|
zh_CN
|
|
Chinese (Traditional)
|
zh_TW
|
|
Dutch
|
nl_NL
|
|
English
|
en
|
|
Finnish
|
fi
|
|
French
|
fr
|
|
German
|
de
|
|
Hebrew
|
iw
|
|
Italian
|
it
|
|
Japanese
|
ja
|
|
Korean
|
ko
|
|
Portuguese (Brazilian)
|
pt_BR
|
|
Spanish
|
es
|
|
Swedish
|
sv
|
 |
For the complete set of language codes used by Salesforce, see Languages supported by Salesforce or Translation Workbench Export and Import Quick Start Guide.
|
Defining New Translations
To define new translations:
1. Go to ServiceMax Setup > App Administration > Translations.
|
|
This is required because when the Manage Translations screen is launched for the first time in an org by any user, the master list of all the existing translatable strings is loaded into the ServiceMax Tag object. Whenever any translatable strings are added/modified, this screen needs to be re-launched to load the new or modified strings into the ServiceMax Tag object.
|
2. Using Data Loader, export the master list of translatable strings from the ServiceMax Tag object by retrieving Language, Tag Key, Tag Text, and Tag Value fields of all records which meet the condition Language = ‘Master’. Do this by creating a NEW TASK of type EXPORT.
The SOQL Query for this is given below:
SELECT SVMXC__Language__c, SVMXC__Tag_Key__c, SVMXC__Tag_Text__c, SVMXC__Tag_Value__c FROM SVMXC__ServiceMax_Tags__c WHERE SVMXC__Language__c = 'Master'
|
|
If you select the fields and the filter condition from the Salesforce Dataloader UI to generate the SOQL Query automatically, select English as the Language field value in filter condition and then edit the SOQL Query to replace English with Master. If you copy the SOQL Query given above and paste it into the SOQL Query text box in the Salesforce Dataloader UI, delete and retype the single quote surrounding the Language field value Master before proceeding. This is to avoid query errors. The Tag Text field is included in the query for the review of the translation with the master text. This is because the translation needs to be entered in the Tag Value column which stores the master text, and the Tag Text field stores the first 255 characters of the master text.
|
3. In the exported .csv file, replace the value of all the records in the Language column with the language code of the required language, as per the table above. For example, to define new translations for the French language, replace Master with fr.
4. In the above .csv file, enter the translations in the Tag Value column, and then save the updated file.
5. Import the saved file, by choosing Insert as the Operation. Do this by creating a NEW TASK of type IMPORT.
Updating Existing Translations
1. Export the existing translations from the ServiceMax Tag object by retrieving Id, Tag Key, and Tag Value fields of all records which meet the condition Language = ‘’. Do this by creating a NEW TASK of type EXPORT.
A sample SOQL Query for retrieving the existing French translations is given below:
SELECT Id, SVMXC__Tag_Key__c, SVMXC__Tag_Value__c FROM SVMXC__ServiceMax_Tags__c WHERE SVMXC__Language__c = ‘fr’
|
|
If you select the fields and the filter condition from the Salesforce Dataloader UI to generate the SOQL Query automatically, select the required language as the Language field value in the filter condition, and then edit the SOQL Query to replace the language with the language code. If you copy the SOQL Query given above and paste it into the SOQL Query text box in the Salesforce Dataloader UI, delete and re-enter the single quotes surrounding the Language field value fr before proceeding. This is to avoid a query error.
|
2. In the exported .csv file, update the translations in the Tag Value column as required, and then save the updated file.
3. Import the saved file, by choosing Update as the Operation. Do this by creating a NEW TASK of type IMPORT.