Home   ·   Index   ·   Search

MultiTerm Convert 2017


This page details the process for converting an Excel file into files that can be imported into MultiTerm.
If you need to convert other file types, contact STP Tech for assistance. Or consult the MultiTerm Convert help documentation and try it out yourself. Note! If you have received XDT and XML files, those can be imported into MultiTerm to create a new termbase

Processing an Excel file with MultiTerm Convert - Walkthrough

1. First, open the Excel file you need to process and make sure it looks OK. You may need to prep the file before converting:
- Remove any extra columns and rows at the start of the document. 
- Make sure that the first row contains headings and that the columns you want to import are next to each other, ABCD, not ACEF for instance. 
- Watch out for hidden columns, these confuse the Convert tool!
Don't use this

... but use this instead, (the same file as above after some manual prepwork)

2. When you are happy with your Excel file, open MultiTerm Convert.
On first page, with New conversion session selected click Next to move on.

3. On the next page, select your file format. We now assume it is Excel. Click Next.

4. On the next page, navigate to your Excel file. Add it to the Input file field and the rest will automatically be populated for the same location as the Excel you selected. Click Next if this is OK with you, if not just choose other locations for each file.

5. Next page you need to set the usage for each column. This is crucial, so do stop and do this bit carefully. For other than language fields, select Descriptive field - Text, for instance for the Context column seen in the screenshot below. You  need to select each column one by one and select the appropriate field, especially for language field content.
Also, if you can't see all the columns that you need to import into your termbase, you should stop here and investigate. If the column is not listed n the Available column header fields window, it won't end up in the converted XML either. 
To search for missing columns, open your Excel file and see if you prepped it thoroughly (see the start of the page). Look for hidden columns that might add extra columns inbetween the language columns, for instance.
Click Next when ready.

6. Next, you need to decide where all the additional columns will be located in the termbase entries. Click on the level, select the field and click Add button to add. After adding the Context field into Entry level, you can see Context with green color in the Entry Structure box. Any term comments for Swedish would go under Swedish>Term, for instance. Make sure to add each field into the Entry Structure or it won't be included in the converted XML at all, and will not end up in the final termbase either. Click Next to move on.

7. The next window (no screenshot of this) is where you decide to kick off the conversion. You can still go back to check/amend if needed. Click Next if you are ready to do convert.
8. The final window will show you the converion process advancing. Click Next to finish the process when the conversion is done and the button is no longer greyed out.

The conversion is now done. The result will be 3 files in the location you set earlier during the process. You can now use the XDT and XML files to create a MultiTerm termbase