Configuring Data Translation
Users want to see business names in Excel instead of database ones.
For example, "Manager Name" is much better then "MGR_NAME" and "Budget Form" is much better then "xls41.uspBudgetForm".
As a result, database developers create (and modify then) a lot of views and procedures to show data with required business names.
The SaveToDB add-in allows solving this task much simpler.
The add-in reads translations from databases and applies the translation within Excel.
Just install SaveToDB Framework to your database and use a configuration workbook to translate names of database objects, fields, and parameters.
Also, you can create own configuration objects as described in the specification below.
Users can select an actual data translation language using the Options dialog box.
To reload changed translation, use the Reload, Reload Data and Configuration button for column and parameter names, and the Reload Query List button for object names.
Also, you can create special named cells to show values from translation tables in worksheets.
SaveToDB reads translations from tables and views with the following fields:
- An optional primary key column like ID
- TABLE_SCHEMA *
- COLUMN_NAME **
- TRANSLATED_COMMENT ***
* The add-in does not use the TABLE_SCHEMA field values with Microsoft SQL Server Compact and SQLite.
** The add-in also reads object name translations from tables and views in the previous format without the COLUMN_NAME field.
*** The add-in also reads column and parameter translations from tables and views in the previous format without the TRANSLATED_COMMENT field.
The SaveToDB Framework 8 creates the xls.translations table following the specification.
TABLE_SCHEMA and TABLE_NAME define objects.
The COLUMN_NAME field defines a column or a parameter.
The LANGUAGE_NAME field must contain the first two characters of a language code like "en" or "fr".
The TRANSLATED_NAME field is a main field. The add-in uses it to translate names in UI elements.
The add-in uses the TRANSLATED_DESC field to show UI element descriptions (if applicable).
The add-in uses the TRANSLATED_COMMENT field to update special named cells.
You can set NULL values in the TABLE_NAME field to define default column and parameter names for all objects in the schema.
Also, you set NULL values in the TABLE_SCHEMA and TABLE_NAME fields to define default column and parameter names for all objects in a database.