How the In-Database Translation Dictionary Search Works

The In-Database Translation Dictionary is part of the Geo SCADA Expert database and, for convenience, you can create and maintain it in a Microsoft® Excel® spreadsheet by using an Excel add-in program. For more information, see Introduction to the In-Database Translation Dictionary.

Before you read this section, you should first read about how you format the Excel Spreadsheet (see Formatting the In-Database Translation Dictionary Spreadsheet).

When you have created a dictionary, the Geo SCADA Expert search and replace works like this:

1. In Geo SCADA Expert, you mark with a @ prefix the text that you want Geo SCADA Expert to translate. For more information, see Defining the Format of Displayed Values in the Geo SCADA Expert Guide to Core Configuration.
2. Geo SCADA Expert detects the marked text and begins a search.
3. Geo SCADA Expert compares the user's locale (defined in the user's User Account) to the country-specific columns in the In-Database Translation Dictionary. If it finds a match for the user's locale, Geo SCADA Expert searches the column items for the marked text. If Geo SCADA Expert cannot find a match for the locale it checks for a match in the region-specific columns (see step 5).
4. Geo SCADA Expert searches the country-specific dictionary column for a match for the marked text. If it finds a match, Geo SCADA Expert reads the associated translation and uses it in place of the marked text. The process then ends.

   If Geo SCADA Expert cannot find the marked text in the country-specific dictionary column, it continues the search in the region-specific column (see step 5).

5. Geo SCADA Expert compares the user's locale to the locale of the region-specific dictionary columns. If it finds a match, Geo SCADA Expert searches the column items for the marked text. If Geo SCADA Expert cannot find a match it will check the default dictionary column (see step 7).
6. Geo SCADA Expert searches the region-specific dictionary column for a match for the marked text. If it finds a match, Geo SCADA Expert reads the associated translation and uses it in place of the marked text in Geo SCADA Expert. The process then ends.

   If Geo SCADA Expert cannot find the marked text in the region-specific dictionary column, it continues the search in the default dictionary column (see step 7).

7. Geo SCADA Expert searches the default dictionary column (if the column exists) for a match for the marked text. If Geo SCADA Expert finds a match, it reads the associated translated text and uses it in place of the marked text in Geo SCADA Expert. The process then ends.

   If Geo SCADA Expert cannot find a match for the marked text in the default dictionary column, or there is no default dictionary column, it ends the search. Geo SCADA Expert will continue to use the marked text in its current form, but will remove the @ prefix.

   Example:

   A user logs on with a User account that is set to the English (United Kingdom) locale and creates a Mimic text box with the value:

   @High Level

   The In-Database Translation Dictionary contains columns named en-GB, en, and default. The 'High Level' text and its translation are in the en Database column.

   This means that Geo SCADA Expert will replace the text 'High Level' with 'High Pressure'.

   As the Mimic text box text is prefixed with the @ character, Geo SCADA Expert will search for the 'High Level' text in the dictionary and attempt to replace it. Geo SCADA Expert searches the dictionary for a Locale match (for information on the dictionary column names, see Formatting the In-Database Translation Dictionary Spreadsheet).

   

   Geo SCADA Expert begins by searching the country-specific dictionary columns and finds a match with en-GB. As this country-specific dictionary column does not contain the search text, Geo SCADA Expert continues its search in the region-specific dictionary column (en). It locates the search text (High Level) and its replacement (High Pressure). Geo SCADA Expert automatically replaces 'High Level' with 'High Pressure' in the Mimic text box.