Creating a XLIFF File for Translated Report Templates

When you required to have a translation of the text strings of the template layout, you can generate an XLIFF (or RTF) file from the report template.

A "translatable string" is any text in the template that is intended for display in the published report, such as table headers and field labels. Text supplied at runtime from the data is not translatable, nor is any text that you supply in the Microsoft Word form fields. You can translate the template XLIFF file into as many languages as desired and then associate these translations to the original template.

XLIFF is the XML Localization Interchange File Format. It is the standard format used by localization providers. For more information about the XLIFF specification, see: XLIFF 1.1 Specification.

To create an XLIFF translation file:

1. Open your template in Microsoft Word with the Template Builder for Word installed.
2. From the Template Builder menu, select Tools, then Translations, and then Extract Text.

   BI Publisher extracts the translatable strings from the template and exports them to an XLIFF (.xlf) file.

3. When prompted, save the file as: TemplateName_<language code>.xlf or .rtf where:

   • TemplateName is the original template name.

   • language code is the two-letter ISO language code (use lower case characters).

   For example, if your original template is named EmployeeTemplate and you are uploading a translation for Japanese-Japan, name the file: EmployeeTemplate_ja.xlf.

   For information on including the" territory code" in the file name, see Oracle Business Intelligence Publisher Report Designer's Guide.

4. In the report Editor, select the Layouts page to upload the translated XLIFF files.
5. Save the file to the language subdirectory of the <EPM_ORACLE_HOME>\Products\FinancialDataQuality\Templates folder.