How to import an excel glossary into an existing termbase?
Thread poster: Anne Besnier

Anne Besnier  Identity Verified
United Kingdom
Local time: 20:16
Member (2013)
English to French
+ ...
May 18, 2015

Hello

I use SDL Trados Studio 2014. I can convert the excel glossary with multiterm converter.
I can see how this glossary can be imported in a newly created termbase: loading the termbase definition first (glossary.xdt), then importing the content glossary (glossary.mtf.xml). I tried it and it worked!

However, I don't know how to import an excel glossary into an existing termbase in multiterm. I don't have a termbase definition and when I import the content glossary, no terms get imported! My problem is: where can I find this termbase definition (which I assume I need for succeeding in this task).

Many thanks for any tips


 

Siegfried Armbruster  Identity Verified
Germany
Local time: 21:16
Member (2004)
English to German
+ ...
Step by step guide May 18, 2015

A step by step guide on how to use Glossary Converter. Learn how to convert your glossaries into or from Excel, MultiTerm, .tbx, but also .tmx and other formats – all this in a few clicks.

English version https://alexandria-translation-resources.com/how-to-center/video-tutorials/glossary-converter-en/

French version https://alexandria-translation-resources.com/how-to-center/video-tutorials/glossary-converter-fr/


 

Anne Besnier  Identity Verified
United Kingdom
Local time: 20:16
Member (2013)
English to French
+ ...
TOPIC STARTER
Useful but what about adding terms to existing termbase? May 18, 2015

I would like to thank you very much for your answer. The glossary converter is indeed very useful. But I still cannot see how I could convert and import the results in an existing termbase in Multiterm.

I may also have confused you slightly: I am using SDL Multiterm Convert

Everything I can read about is usually about newly created termbases in Multiterm. But what about adding extra terms from an excel glossary into an existing termbase?

I hope it makes sense. Many thanks for you helpicon_smile.gif


 

Siegfried Armbruster  Identity Verified
Germany
Local time: 21:16
Member (2004)
English to German
+ ...
I am not the expert May 18, 2015

Sorry Anne, I am not the expert. Our expert on this is Delphine Guérou, who unfortunately is not in today.

My approach (while Delphine is not here) would be very simple and pragmatic.

1) process the existing Multiterm termbase into an Excel file (E1) using Glossary converter
2) copy/paste the new terms from my Excel file that contains the new terms into my E1 file
3) produce a new Multiterm termbase from the resulting Excel file that now contains all terms

I know it sounds primitive, and it might be primitive and some colleagues will hopefully describe a much better workflow - but this is how I would handle it - or I might decide to wait and ask Delphine when she is back.


 

Anne Besnier  Identity Verified
United Kingdom
Local time: 20:16
Member (2013)
English to French
+ ...
TOPIC STARTER
Thank you May 18, 2015

Thank you very much again Siegfried. I think your answer makes sense: I was thinking exactly the same as I was having a hot chocolate in the kitchenicon_smile.gif
If Delphine could confirm or complement that answer, that would be brilliant!
Have a nice day


 

Alexander Somin  Identity Verified
Germany
Local time: 21:16
Member (2014)
English to Russian
+ ...
MultiTerm Import into ... May 18, 2015

Hi Anne,

I guess the MultiTerm Import into ... feature might come in handy here. The second thought.

[Edited at 2015-05-18 16:11 GMT]


 

SDL Community  Identity Verified
United Kingdom
Local time: 21:16
English
For a simple glossary... May 18, 2015

... just source and target terms then the approach from Siegfried is probablay the easiest. But you could also do this as long as the definitiion os the same for both termbases:

- use the glossary converter to go from your new Excel directly to MT XML and XDT
- Import the MT XML straight into the existing termbase

Pretty straightforward, just change the setting in the converter to give you the MT definition file directly from the excel spreadsheet.

Regards

Paul
SDL Community Support


 

bmclaughlin3 (X)  Identity Verified
Spain
Local time: 21:16
Spanish to English
+ ...
Worked for me! Nov 2, 2015

Just did the same workaround proposed and it worked fine for me. I even purged duplicates from the previous version of the termbase. Many thanks!

 

Elisa Farina  Identity Verified
Spain
Local time: 21:16
Member (2009)
German to Italian
+ ...
Useful PDF that guides you step by step Mar 14

Three years after the first entry of this string was posted I found myself facing the same issue. I bumoped into this PDF by Jayne Fox, followed the instructions and managed to carry out the task successfully:
http://foxdocs.biz/BetweenTranslations/wp-content/uploads/2016/02/How-to-import-a-bilingual-Excel-glossary-into-MultiTerm-v3.pdf
(link to the page were I found it: http://foxdocs.biz/BetweenTranslations/how-to-import-a-bilingual-excel-glossary-into-multiterm-for-use-in-trados-studio/)

Two important notes:
1) I work with SDL MultiTerm 2015 and the process is the same.
2) The PDF is about importing the glossary in a new and empty termbase, but the process worked just as well with an existing and not at all empty termbase.


 


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


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

How to import an excel glossary into an existing termbase?

Advanced search







PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

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