MultiTerm 2009 - how do I import an Excel sheet?
Thread poster: Amr Alaa

Amr Alaa
Egypt
Local time: 23:35
English to Arabic
+ ...
Mar 26, 2010

how do i import an excel sheet to my termbase ??

Direct link Reply with quote
 

Luisa Ramos, CT  Identity Verified
United States
Local time: 17:35
Member (2004)
English to Spanish
Manuals and online Mar 26, 2010

The manual has a pretty good explanation, and there is a ton of information online, step by step.

Direct link Reply with quote
 

Agnese Carnazzola  Identity Verified
Italy
Local time: 23:35
English to Italian
+ ...
Multiterm Convert Mar 26, 2010

You have to use Multiterm Convert. (SDL->SDL Multiterm 2009->SDL Multiterm 2009 Convert)

http://bulgarian-translator.com/multiterm-convert-converting-excel-files/
http://www.proz.com/videos/helpful%20tips/22


Direct link Reply with quote
 

Joel Earnest
Local time: 23:35
Swedish to English
No frills instructions Mar 27, 2010

I've used the following instrucitons since Trados 6 or so with XP and they still work with Studio and Vista, along with the various Excel versions through the years.

I put all of the files generated in a specific folder with the same name as the termbase. The original Excel file goes there too. Since upgrading to Studio, all my termbase folders are stored at the default location.


Transferring terms from an Excel file to a new, basic MultiTerm termbase
(Swedish-US English)


Step 1. Prepare the Excel file
In the Excel file, delete all columns but two – one with “Swedish” (no quotation marks) in Row 1, Column A, with the Swedish terms beneath, and one with “English” (no quotation marks) in Row 1, Column B, with the English terms beneath.
Save and close the file.


Step 2. Converting the Excel file into TRADOS XML format
Open MultiTerm Convert.

MultiTerm Convert opens with a conversion wizard at step 1/7.

1/7 Click Next.

2/7 Select: New conversion session and Save conversion session.
Click Save as…
Name the file and save it in the appropriate folder.
Click Next.

3/7 Select Microsoft Excel format.
Click Next.

4/9 Browse to your Excel input file.
Click Next.

5/9 Select Swedish from Available column header fields: and then click Index field. Select Swedish (Sweden) from the dropdown list.
Select English from Available column header fields: and then click Index field. Select English (United States), or the appropriate sublanguage, from the dropdown list.
Click Next.

6/9 Click Next.

7/9 Select Convert immediately.
Click Next.

8/9 Wait until the conversion is complete.
Click Next.

9/9 Click Finish to close the MultiTerm Convert.


Step 3. Creating a new termbase
Open MultiTerm.

Select Create termbase… from the Termbase menu.
Browse to the folder where you would like to store your termbase and click OK.

The Termbase Wizard will now open at step 1/5.
Click Next.

1/5 Select Load an existing termbase definition file.
Browse to the XDT file created during the conversion process described in Step 2 and click Open.
Click Next.


2/5 Enter a termbase name.
Click Next.

3/5 Click Next.

4/5 Click Next.

5/5 Click Next.

Click Finish.


Step 4. Importing the entries from your Excel file
Choose Import Entries… from the Termbase menu.
Click Process… in the Termbase Catalogue dialog box.

2/8 Browse to the XML file created in MultiTerm Convert in Step 2, and click Open.
Select Fast import.
Click Next.

3/8 Click Save As… to save the exclusion file.
Click Next.

7/8 Click Next.

8/8 Wait until the import has been processed.
Click Next.

Click Finish.

Click OK.



[Edited at 2010-03-27 12:38 GMT]


Direct link Reply with quote
 

Amr Alaa
Egypt
Local time: 23:35
English to Arabic
+ ...
TOPIC STARTER
Thanks a lot Mar 28, 2010

Thanks a lot
Thanks a lot
Thanks a lot
Thanks a lot
Thanks a lot
Thanks a lot


Direct link Reply with quote
 

Ulrika Mansson
Local time: 23:35
German to Swedish
+ ...
no import option! Sep 21, 2011

And if one can't find the import option in the termbase menu?
I am using 8.5, only got Open/Create/Close termbase and Servers and Exit.
/Ulrika


Direct link Reply with quote
 

Nora Diaz  Identity Verified
Mexico
Local time: 15:35
Member (2002)
English to Spanish
+ ...
The import option is in the Catalog view Sep 21, 2011

Have a look here for a detailed explanation:

http://noradiaz.blogspot.com/2011/08/importing-excel-glossaries-into_03.html


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

MultiTerm 2009 - how do I import an Excel sheet?

Advanced search







SDL Trados Studio 2017 only €415 / $495
Get the cheapest prices for SDL Trados Studio 2017 on ProZ.com

Join this translator’s group buy brought to you by ProZ.com and buy SDL Trados Studio 2017 Freelance for only €415 / $495 / £325 / ¥60,000 You will also receive FREE access to our getting started eLearning program!

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search