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

Amr Alaa
Egypt
Local time: 21:06
English to Arabic
+ ...
Mar 26, 2010

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

 

Luisa Ramos, CT  Identity Verified
United States
Local time: 15:06
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.

 

Agnese Carnazzola  Identity Verified
Italy
Local time: 21:06
Member (2010)
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


 

Joel Earnest
Local time: 21:06
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]


 

Amr Alaa
Egypt
Local time: 21:06
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


 

Ulrika Mansson
Local time: 21:06
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


 

Nora Diaz  Identity Verified
Mexico
Local time: 13:06
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


 


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 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running, helps experienced users make the most of the powerful features, ensures new

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »



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