Translating Object Names

By default, SaveToDB products display native object names from databases and other data sources, such as s02.usp_cashbook and s02.usp_cash_by_months.

You can add translated object names to the xls.translations table. Here's an 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 a two-character language code in the LANGUAGE_NAME field.

SaveToDB and DBEdit users must select the desired data language in the Options dialog and reload data and configuration to see the translated names.

To access translated names in DBGate and ODataDB, use URLs that specify the desired language. For example, in DBGate, try:

For ODataDB, use:

Using Translated Descriptions and Comments

The SaveToDB add-in allows you to display translated names, descriptions, and comments using the following name cells: SaveToDB_Name, SaveToDB_Desc, and SaveToDB_Comment.

In SaveToDB 10, a special task pane combines all values to show an object description. Users can access this pane via Options > Show Descriptions.

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

Note that DBEdit does not support translated object descriptions and comments.

DBGate and ODataDB display the description below the page title and the comment below the data table. Both DBGate 2 and ODataDB 4 also support markdown syntax in the TRANSLATED_COMMENT field.