Hi,

I have a report that contains titles in french.
The same report is used in an Arabic country which requires them to be shown in Arabic.
Is there a posiibility to pick the translation from French to Arabic from an external file.

Thanks for your suggestions.

Majid.

Majid,

There are translation files around but they are specifically Am-English to [language] and would only contain WF specific phrases.

Look at using separate synonym files with a TITLE attribute in the language you want. You could prefix or suffix the synonym filename with a code to depict the language (e.g. EN - English, AR - Arabic, FR - French etc.) and then just use that within your code -

-SET &Lang = 'FR';
TABLE FILE reportdata_&Lang
PRINT .... etc.

This would expand as TABLE FILE reportdata_FR etc.

T

Or, you can -READ the translation file into Dialogue Manager variables, one &var per column title in the language of choice and then use the &var in the table file request like PRINT col1 AS '&var1' or something like that.

Majid

I copied this from the manual (some people use manuals)

Using Multilingual Titles in a Request
The following Master File for the CENTINV data source specifies French titles (TITLE_FR) and
Spanish titles (TITLE_ES) as well as default titles (TITLE) for the PROD_NUM and PRODNAME
fields:
FILE=CENTINV, SUFFIX=FOC, FDFC=19, FYRT=00
SEGNAME=INVINFO, SEGTYPE=S1, $
FIELD=PROD_NUM, ALIAS=PNUM, FORMAT=A4, INDEX=I,
TITLE='Product,Number:',
TITLE_FR='Nombre,de Produit:',
TITLE_ES='Numero,de Producto:',
DESCRIPTION='Product Number', $
FIELD=PRODNAME, ALIAS=PNAME, FORMAT=A30,
WITHIN=PRODCAT,
TITLE='Product,Name:',
TITLE_FR='Nom,de Produit:',
TITLE_ES='Nombre,de Producto:'
DESCRIPTION='Product Name', $
FIELD=QTY_IN_STOCK, ALIAS=QIS, FORMAT=I7,
TITLE='Quantity,In Stock:',
DESCRIPTION='Quantity In Stock', $
FIELD=PRICE, ALIAS=RETAIL, FORMAT=D10.2,
TITLE='Price:',
DESCRIPTION=Price, $

might work for Arabic too...

Hi Frank,

I read that part of the documentation but I was facing a problem when I had to re-create the synonyms all the translation are lost.

Regards

I would do it with Dialogue Manager. Set up DM variables with text for the various column titles, headings, subtotals based on the possible languages. You could put this in an INCLUDE to be used by all programs in the system. I've done this for Canadian Federal Government bilingual systems.

-SET &LANG1 = 'F';

-SET <_CAR =
- DECODE &LANG1(
- 'F' 'VOITURE'
- 'S' 'COCHE'
- ELSE 'CAR');

-SET <_COUNTRY =
- DECODE &LANG1(
- 'F' 'PAYS'
- 'S' 'PAÍS'
- ELSE 'COUNTRY');

-SET &LH_HEADING1
- DECODE &LANG1(
- 'F' 'FICHIER VOITURE'
- 'S' 'ARCHIVO COCHE'
- ELSE 'CAR FILE');

TABLE FILE CAR
PRINT
CAR AS '<_CAR'
COUNTRY AS '<_COUNTRY'
HEADING
"&LH_HEADING1"
END

FrankDutch,
You've tought me an interesting capability of FMDs: How they can contain alternative column captions, in this case, for multiple languages applications (TITLE='..', TITLE_FR='...', etc.) but two questions arise regarding this ability:
- #1 What/where is the list of permissable 2-character keyword suffix codes?
- #2 How does one specify which of the alternate TITLE[-aa]= keyword sets is used to produce the report?
CB

Look for "Multilingual Metadata" in the 7.6 Describing Data With WebFOCUS Language documentation.