• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 3 replies
  • Subscribers 190 subscribers
  • Views 7426 views
  • Users 0 members are here
Options
Related

Importing Excel glossaries into an existing Multiterm termbase

Heidrun Wolf-Hinger

Hi,

I would like to import an Excel glossary into an existing termbase (I'm using SDL Trados and Multiterm 2021). 

I have merged several glossaries with the Glossary converter into one termbase and exported this back to an Excel file, so the synonyms are all in one line separated with the "I".

If I use the Glossary converter I get a new Multitem termbase, only with the fields defined on the excel file.

Therefore I would like to import the excel file into an existing termbase with more fields. If I import the Excel file with Multiterm Convert, the synonyms are not recognised as such and are all in one line (as for ex.: retainer|adapter).

If I convert with the Glossary Converter a new termbase is created.

I'm sure I'm overlooking somehting important. But I'm quite new to this.

Does anyone know how I should proceed best?

Thanks

Heidrun
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents
  • +2

    You cannot use MultiTerm Convert for the Excel file in that format. It requires a different layout.  However, the Glossary Converter doesn't just go backwards and forwards between Excel and Multiterm.  If you look in the settings you can also choose MultiTerm XML as the format to convert to.  If you use that then you'll be able to import the XML... as long as the fields match those in your MultiTerm termbase.

    Screenshot of Trados Studio Glossary Converter settings showing the output format options with 'MultiTerm XML' selected, indicated by a red arrow, and a tooltip stating 'When this is checked it will use whatever you select'.

    You can also merge the Excel file and your MultiTerm Termbase to create a new one with all the data in it. 

    So a few options.

    Paul Filkin | RWS Group

    ________________________
    Design your own training!
    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 1:53 PM (GMT 0) on 5 Mar 2024]
Reply
  • +2

    You cannot use MultiTerm Convert for the Excel file in that format. It requires a different layout.  However, the Glossary Converter doesn't just go backwards and forwards between Excel and Multiterm.  If you look in the settings you can also choose MultiTerm XML as the format to convert to.  If you use that then you'll be able to import the XML... as long as the fields match those in your MultiTerm termbase.

    Screenshot of Trados Studio Glossary Converter settings showing the output format options with 'MultiTerm XML' selected, indicated by a red arrow, and a tooltip stating 'When this is checked it will use whatever you select'.

    You can also merge the Excel file and your MultiTerm Termbase to create a new one with all the data in it. 

    So a few options.

    Paul Filkin | RWS Group

    ________________________
    Design your own training!
    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 1:53 PM (GMT 0) on 5 Mar 2024]
Children