1. Implementation Guide
  2. Globalization
  3. Manage Languages

Manage Languages

Within Merchandising, languages are used to define and display translations of text. A default list of languages is loaded into Merchandising on initial installation, however modifications can be done to the list to add new values, remove values that are not used, and update descriptions. These updates can be made through spreadsheet download and upload processes, which are accessed through the main Merchandising task list under Foundation Data > Download Foundation Data and Foundation Data > Upload Foundation Data.

To add or update languages, you will select the template type of Administration from the Download Data screen and then the template Languages. Click the Download button and when prompted, choose to either open the .ods file that is generated or save the file and open it separately in the spreadsheet application of your choice. Once opened, there will be two sheets that can be modified - Languages and Language Translations.

Add a Language

To add a new language, start in the Languages tab, and, in a blank line in the template, select the action type of Create. Next enter a unique language identifier (up to 6 digits), and then enter the description for the language in the primary language (as defined in the Merchandising system options) of up to 120 characters. Finally, enter the internationally recognized ISO Code for the language which is published by the International Organization for Standardization (ISO). Note: the Web Help Server, Report Server, and Web Report Server can be entered, but they are no longer used by Merchandising.

If you wish to add translations for the language in languages other than the primary language, this can be done in the Language Translations tab. Navigate to a blank row and select the action type of Create and the language in which the translated description will be entered. Then, enter the language for which the translation applies. Finally, enter the translated description. The translated description can also be up to 120 characters long. This is an optional step.

Update Languages

If you would like to update any details for existing languages, a similar process will be followed as that described above for creating new languages. First, download the spreadsheet, and then navigate to the tab where you would like to make your updates.

The following columns can be updated in each tab:

  • Languages - Description, Web Help Server, Report Server, Web Report Server, ISO Code

  • Language Translations - Description

In the tab where you are going to make your updates, select the action type of Update, and then correct the value in the spreadsheet.

Uploading Changes

For all actions defined above, once all the updates have been made to the data in the spreadsheet, save the file and close it. Then, return to the Merchandising screens and select Foundation Data > Upload Foundation Data from the main task list. In this screen, select the template type Administration and the template Languages. This will generate a process description automatically, but this can be updated if desired. Lastly, select the Browse button and navigate to the directory where you saved the updated spreadsheet.

To review the status of the upload and check whether any errors occurred, select the Foundation Data > Review Status task from the main task list.

For more information, see "Download/Upload Data from Spreadsheets" in the Oracle Retail Merchandising Do the Basics User Guide.