4.2.2 - eXercise

IDevice Icon Activity 2

Converting the Microsoft Excel File

To convert the Microsoft Excel glossary take the following steps:

1. Open MultiTerm Convert.

2. On the first page of the wizard, click Next to continue. On the following page click Next again.

3. Select Microsoft Excel format from the available conversion options, then click Next (see Figure 1).

4. On the Specify Files page click the Browse button and select your EuroVoc glossary from the previous exercise by double-clicking it. Then click Next.

5. On the Specify Column Header page, the column headers in the selected Excel file are shown. You need to define which column headers should be considered as descriptive fields, and which ones as index fields. If a column contains index fields (i.e. terms), you need to assign the required language variant (e.g. English UK, English US).

6. Start with the Client field: it is a descriptive field. However, this descriptive field should be treated as a picklist field (rather than conventional free text field). Therefore, select Picklist from the Descriptive field dropdown list.

7. Continue with the index fields: the column English should be English (United Kingdom) in the termbase. Make sure that English is selected in the Available column header fields list. Then click the radio button Index field. From the dropdown list below select English (United Kingdom).

8. Repeat step 7 for Czech.

9. Click Next to proceed to the Create Entry Structure page.

10. On the Converting page, wait for the progress bar to indicate that the conversion process is finished. Proceed by clicking Next and then click Finish.

11. Take a quick look at the sample folder that contains your glossary.xsl file. SDL MultiTerm Convert has created the following files:

glossary.xdt: this is the termbase definition from which we will create a new (empty) termbase

glossary.mtf.xml: this is the termbase content, which we will import into the termbase