Understanding the In-Database Translation Dictionary

You can replace user-created text in ClearSCADA with alternative (or translated) text. To do this, you need to create a Translation Dictionary which contains the user-created text and associated translations. You then mark the text in ClearSCADA that you want translated and ClearSCADA will perform a search and replace using the Translation Dictionary.

There are two types of Translation Dictionary you can create: A File Translation Dictionary or an In-Database Translation Dictionary. For more information on which type will meet your specific needs, see Introduction to the ClearSCADA Translation Dictionary.

This topic refers to the In-Database Translation Dictionary only. For information about the File Translation Dictionary, see Understanding the In-Database Translation Dictionary

You create and maintain the In-Database Translation Dictionary by using a Microsoft® Excel® add-in program.

To set up an In-Database Translation Dictionary:

  1. In ClearSCADA, enable the In-Database Translation Dictionary (see Define the Translation Dictionary Type).
  2. Install the In-Database Translation Dictionary add-in program for Microsoft Excel (see Installing the In-Database Translation Dictionary Excel Add-In Program).
  3. Run Microsoft Excel.
  4. In Microsoft Excel, select the ClearSCADA Dictionary tab.

  5. You can now create your In-Database Translation Dictionary. For more information about how to so this, click the Help option in the Microsoft Excel add-in program's ribbon.

  6. When you have created your In-Database directory, you need to specify which ClearSCADA text you want to replace with a translation. To do this, use a @ prefix to mark the text you want to replace (see Define the Format of a Displayed Value in the ClearSCADA Guide to Core Configuration).

    ClearSCADA will then search the In-Database Dictionary for the marked text and, if it finds a match, will replace the marked text with the translation for your locale.

    For more information, see the Help in the In-Database Translation Dictionary Excel add-in program.


Disclaimer

ClearSCADA 2017 R3