Data Source Settings

After defining the connection string, click on Setup in the Build Connection dialog. This opens the Setup Data Source dialog to specify the source of the localizable strings from database tables.

Procedure

  1. All the tables in the selected database are shown in the Table Names list.
  2. Select the table you want to use from this list. All the columns in the selected table are then shown in the Column Names list.
  3. To select the contents of a column as the ID for the translated text, highlight the column and click the Add as ID button. The column name is then added to the list on the right with ID as the type. One or more columns can be added with ID as the type.
  4. Select the column names from which source strings are to be extracted. In this case, highlight the column and click the Add as Source Text button. Columns that are not Text type cannot be added as source text columns.
  5. You can also read Comments, Max Length specifications or other Properties from the columns by adding them with the corresponding buttons. These values are then entered in the Passolo source string list.
  6. If you click the Preview button, the content of the selected language is displayed in the preview table.
  7. In the Query String edit box you can define a condition to limit the display to a selection of strings in the given language. Put column names in quotation marks, as shown in the left-hand field of the query. For example, column names in Microsoft Excel or Microsoft Access databases have to be placed in angle brackets. These markers should be entered for security reasons. If column names contain keywords or spaces, this is necessary to ensure that the database can identify the column names correctly.
  8. Click Preview to display the changes.
  9. Click OK if the strings displayed in the preview table correspond to the strings that you want to extract from the database for translation, or Cancel if you want to close the dialog without saving your changes.