Oracle Application Express 18: Translating an App (2 of 2) - Translating Messages and Specifying Primary language

Before You Begin

This 20-minute tutorial shows you how to translate your application. You will later view your translated application by specifying the primary language.

This is the last tutorial in Oracle Application Express 18: Translating an App Series. Read the tutorials in sequence:

Oracle Application Express 18: Translating an App (1 of 2) - Defining Translatable Text Messages
Oracle Application Express 18: Translating an App (2 of 2) - Translating Messages and Specifying Primary language

Background

You can run applications built in App Builder concurrently in different languages. A single Oracle database instance and Oracle Application Express can support multiple database sessions customized to support different languages.

The Globalization attributes specify how the Application Express engine determines the primary language of an application. To translate an application developed in App Builder, you must map the primary and target language, seed and export text to a translation file, translate the text, apply the translation file, and publish the translated application.

What Do You Need?

To complete this tutorial you need to:

Complete the preceding tutorial in this series.

Translate the Create App Wizard

In this section, you translate the Create App Wizard to German. To translate an application developed in App Builder, you must:

Map the primary and target language
Seed and export text to a translation file
Translate the text
Apply the translation file
Publish the translated application

Perform the following steps:

To map the primary and target language:
- Click Application ID in the Runtime Developer Toolbar.
- From the application page, click Shared Components.
- Under Globalization, click Globalization Attributes.
- In the Globalization page, check the following:
  - Application Language Derived From: Application Primary Language (you selected this in the previous tutorial)
  - Click Apply Changes.
The second step is to seed the translation table and then export the translation text to a translation file. Seeding the translation copies all translatable text into the Translation Text repository. To seed translatable text:
- Click Application ID breadcrumb.
- Click Shared Components.
- Under Globalization, click Translate Application.
- The Translate page appears. Click Define application languages.
- Click Create.
- In the Create/Edit Application Language Mapping page, update the following:
  - Translation Application: Enter a unique Application ID
  - Language: Select German (Germany) (de)
  - Click Create.
- Click the Translate breadcrumb.
- Click Seed translatable text.
  Note: Seeding the translation copies translatable text into the translation text repository. Once the translatable text is seeded, you can translate the text strings.
- Select the check-box for your Translated Application, and click Seed.
Description of the illustration seed.png
After you specify the language and seed the Translation Text, you can then generate and export an XLIFF file for translation. The seeding process keeps your primary language application synchronized with the Translation Text repository. You should run the seed process any time your primary language application changes. To export text to a translation file:
- Click the Translate breadcrumb.
- Click Download XLIFF translation files.
- In the XLIFF Export page:
  - Download XLIFF file for complete Application: Language - Select German (Germany) (de)
  - Click Export XLIFF File for Application.
- Save the exported XLIFF file into your working directory.
After you export a translatable file to XLIFF format, you can translate it into the appropriate languages. To translate the text:
- Open the exported XLIFF File in a text editor.
- Press Ctrl+H.
- For Find what, enter Home.
- For Replace with, enter Zuhause.
- Click Replace All.
- Repeat the same for other navigation bar and menu items, for example:
  - Create App Wizard - Anwendung erstellen Magier
  - Dashboard - Instrumententafel
  - Milestones - Meilensteine
  - Tasks - Aufgaben Tasks
  - Calendar - Aufgaben Kalender
  - Project Costs - Projektkosten
  - Administration - Verwaltung
  - Sign in - Anmelden
  - Sign Out - Ausloggen
- Save the changes, and close the file.
After your XLIFF document has been translated, the next step is to upload and then apply it. To upload and apply the translated XLIFF:
- Click the Translate breadcrumb.
- Once the XML Localization Interchange File Format (XLIFF) file is populated with the translations, the XLIFF file is uploaded back into the translation repository. To do this, click Apply XLIFF translation files.
- Click Upload Files.
- Click Choose File. Click Browse and browse to your working directory. Select the XLIFF File you modified.
- Click Upload.
- Select the check-box for the row with your XLIFF file name.
- Select a translation mapping from the drop-down list for Apply to Translation. Click Apply Checked.
Publishing your application creates a copy of the base language application, substituting the translated text strings from your translations table. This published application can then be used to render your application in alternate languages.
To publish the translated application from the translation repository:
- Click the Translate breadcrumb.
- Click Publish translated applications.
- Select the check box for the Translated Application, and click Publish.
The translated application is successfully published.

Description of the illustration published_app.png

Specify the Primary Language - German

In this section you specify the primary language to see the translated version of the Create App Wizard.

Perform the following steps to view your application in German:

Click the Shared Components breadcrumb.
Under Globalization, click Globalization Attributes.

Description of the illustration global_attribute.png

In the Globalization page, update the following:
- Application Primary Language: Select German (Germany) (de)
- Application Language Derived From: Select Application Primary Language
- Click Apply Changes.

Description of the illustration edit_global_attr.png

Click Run Application.