Translating Columns and Parameters

By default, SaveToDB products display native column and parameter names from databases and other data sources, such as account_id or company_id.

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

Example

TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	LANGUAGE_NAME	TRANSLATED_NAME
s02	usp_cash_by_months	company_id	en	Company Id
s02		account_id	en	Account
s02		company_id	en	Company
s02	usp_cash_by_months	company_id	es	ID de empresa
s02		account_id	es	Cuenta
s02		company_id	es	Empresa
s02	usp_cash_by_months	company_id	fr	ID de l'entreprise
s02		account_id	fr	Compte
s02		company_id	fr	Entreprise

Use a two-character language code in the LANGUAGE_NAME field.
Leave the TABLE_NAME blank to apply the translated name to all objects in the schema by default.

To disable translation for specific columns or parameters, use the DoNotTranslate event type in the xls.handlers table.

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

To retrieve translated names in DBGate and ODataDB, use URLs with the specified language.

DBGate Examples

ODataDB Examples

Using Translated Descriptions and Comments

SaveToDB products display translated descriptions in header comments or tooltips.

Note that SaveToDB products ignore TRANSLATED_COMMENTS values for columns or parameters.