xls.translations

xls.translations

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

Below is a configuration sample:

Sample of Translation Configuration

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.