Add a target language to the Translation Table
The Translation Table is used to manage the languages into which you want to translate your project. Adding a language to the table can be as simple as selecting it from a list and then automatically translating your project texts.
In some cases, however, you might work in one language but develop your project for another — for example, you might work in Portuguese but develop your project for English. If that is the case, you must remember to set the source language in Step 3 below, to associate the correct language with the Source column of the worksheet.
To add a target language to the Translation Table:
- Open the Translation Table worksheet by doing one of the following:
- On the Insert tab of the ribbon, in the Global group, click Translation; or
- In the Global tab of the Project Explorer, double-click Translation.
The Translation Table worksheet is opened for editing.
- Make sure the Enable Translation option is selected. If this option is cleared, then the entire Translation Table worksheet is disabled and the language cannot be changed during run time.
- If the source language of your project is other than the language of the development environment itself, set the source language:
- To the right of the Source language box, click the browse button. The Languages dialog box is displayed.
- In the Languages dialog box, select the language for which your project was originally developed, and then click OK.
The selected language is set in the Source language box.
- Set the target language:
- In the Target languages group, click Add. The Languages dialog box is displayed.
- In the Languages dialog box, select the language to which you want to translate your project, and then click OK.
The selected language is added to the Select list, and a new worksheet is created for the language. The Source column of the worksheet is automatically populated with all of the translatable text strings in your project, and the Target column is blank.
- Configure Date order and Date separator as needed for the target language. For example, for English-United States (i.e., American English), Date order is typically MDY and Date separator is typically /, resulting in a date format of MM/DD/YYYY. In many European languages, however, Date order is typically YMD and Date separator is typically ., resulting in a date format of YYYY.MM.DD. The language is added to the Select list, and a new worksheet is created for the language. The Source column of the worksheet is automatically populated with all of the translatable text strings in your project, and the Target column is blank.
- Use the Filters to search the worksheet for specific text items; as you type a few characters, the list is dynamically filtered to show only the items that match.
Note: The ampersand character (&) is ignored when filtering rows. This is to improve the handling of text in program dialogs, where ampersands are used to indicate keyboard accelerators.
- For each text item in the Source column, enter the translation in the Target column. You can manually translate the items one by one, or you can automatically translate multiple items using Google Translate.
- Highlight the cells in the Source column to select them, and then press Ctrl-C to copy those items to the clipboard. You can also click the column header to select the entire column.
- In your web browser, go to translate.google.com.
- Select the From and To languages.
- Click in the text box on the left, and then press Ctrl-V to paste the items from the clipboard. The items are pasted as separate lines.
- Click Translate. The translation appears on the right. Again, the items are translated as separate lines.
- Highlight the translated items to select them, and then press Ctrl-C to copy the items to the clipboard.
- In InduSoft Web Studio, highlight the empty cells in the Target column to select them. You can also click the column header to select the entire column.
- Press Ctrl-V to paste the translated items from the clipboard into the Target column. Because the translated items were copied as separate lines, they should be correctly pasted into the rows of the worksheet.
- Review the translated items in the Target column, to confirm the translations and to make sure they match the untranslated items in the Source column.
Tip: If you want to keep the original, untranslated text for a specific item, leave the Source column blank.
- Save and close the worksheet.
Changes made to the translation table will not take effect until you either call the function SetLanguage or restart the project runtime.
You can open and directly edit this file with Microsoft Excel, if you choose to do so.