xls.translations

The xls.translations table is a part of the SaveToDB Framework used to configure data translation.

Below is a configuration sample:

The table has the following fields:

1. ID
2. TABLE_SCHEMA
3. TABLE_NAME
4. COLUMN_NAME
5. LANGUAGE_NAME
6. TRANSLATED_NAME
7. TRANSLATED_DESC
8. TRANSLATED_COMMENT

Use TABLE_SCHEMA and TABLE_NAME to define database objects being translated. Leave TABLE_NAME blank to apply the translation to all objects in the schema.

Use COLUMN_NAME to translated a column or parameter name. Leave it blank to translate database object names.

Use the LANGUAGE_NAME column to define a language like "en" or "es".

Use the TRANSLATED_NAME column to define the translated name of the specified database object, column, or parameter.

DBEdit ignores TRANSLATED_DESC and TRANSLATED_COMMENT field values. However, the columns must exist in the translation tables or views.