Translating Object Names
Special offer: 50% discount ($1440) for ODataDB Enterprise until June 24, 2024

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:

IDTABLE_SCHEMATABLE_NAMECOLUMN_NAMELANGUAGE_NAMETRANSLATED_NAMETRANSLATED_DESCTRANSLATED_COMMENT
 s02usp_cash_by_monthsenCash by Months
 s02usp_cash_by_monthsesEfectivo por meses
 s02usp_cash_by_monthsfrCash par mois
 s02usp_cashbookenCashbook
 s02usp_cashbookesLibro de caja
 s02usp_cashbookfrLivre 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.