Translating Columns and Parameters

SaveToDB products show by default native column and parameter names from databases and other data sources like, for example, account_id or company_id.

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

For 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 two characters of the language code in the LANGUAGE_NAME field.

You can leave the table name blank to apply the translated name to all objects in the schema by default.

You can disable translating columns and parameters for an object using the DoNotTranslate event type in the xls.handlers table.

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

SaveToDB products show translated descriptions in the header comments or tooltips.

SaveToDB products ignore TRANSLATED_COMMENTS values for columns or parameters.