Creating a dictionary with Microsoft Excel

  1. Open Excel.
  2. Create a two-column sheet with source terms in the first column and the corresponding targets in the second.
    If you want to allow multiple target terms for one source entry, add an extra row for each target term.
    SQL statement SQL-instructie
    Application Toepassing
    Not supplied Niet meegeleverd
    Not supplied Niet inbegrepen
  3. Select the source and target columns, selecting the source column first and the target column second.
  4. In QA Distiller, do one of the following to open the Dictionary module:
    • Click Settings > Dictionary.
    • Press F8.
  5. Do one of the following to open the Excel Dictionary Import tool:
    • On the menu bar, click Import from Excel.
    • Press CTRL + F8.
  6. Do one of the following:
    • Click Import > List Open Excel Files.
    • Press F2.
  7. Select the Excel file that contains the terminology.
    If you selected the correct document, there is a message in blue at the top of the dialog box: Selection OK, you can now import.
  8. Do one of the following:
    • On the menu bar, click Import > Import.
    • Press F5.
    The contents of the terminology list are displayed in a newly opened window, where you can edit the source and target cells, disregard terminology by changing the value 1 into a 0 in the Accept column.
  9. Click Close and, on the menu bar, click File > Save or File > Save as.
  10. Click Save.
The Dictionary import tool creates a text file containing a header, the language codes, and the terms separated by a pipe symbol.