Translating Object Names

SaveToDB products show by default native object names from databases and other data sources.

For example, s02.usp_cashbook and s02.usp_cash_by_months.

You can add translated object names to the xls.translations table.

For example:

TABLE_SCHEMA	TABLE_NAME	LANGUAGE_NAME	TRANSLATED_NAME
s02	usp_cash_by_months	en	Cash by Months
s02	usp_cash_by_months	es	Efectivo por meses
s02	usp_cash_by_months	fr	Cash par mois
s02	usp_cashbook	en	Cashbook
s02	usp_cashbook	es	Libro de caja
s02	usp_cashbook	fr	Livre de caisse

Use two characters of the language code in the LANGUAGE_NAME field.

SaveToDB and DBEdit users must choose the required data language in the Options dialog box and reload data and configuration to get the translated names.

To get the translated names in DBGate and ODataDB, use the URLs with the desired language.

For example, try these with DBGate:

or these with ODataDB:

Using Translated Descriptions and Comments

The SaveToDB add-in allows displaying translated names, descriptions, and comments using names cells: SaveToDB_Name, SaveToDB_Desc, and SaveToDB_Comment accordinly.

SaveToDB 10 has a special task pane that combines all values to show an object description. Users can open it using Options, Show Descriptions.

Moreover, SaveToDB 10 supports the markdown syntax in the TRANSLATED_COMMENT field.

DBEdit does not support translated object descriptions and comments.

DBGate and ODataDB show the description below the page title and the comment below the data table.

DBGate 2 and ODataDB 4 also support the markdown syntax in the TRANSLATED_COMMENT field.