Importing an excel file into a termbase

I am trying to help someone I know import their excel file that is setup like this, into their termbase

Language One Language Two Language1 Definition Language2 Definition Source
wordOne|synonymOne translationOne|synonymTranslatedTwo Bla bla bla Bla bla bla Some website

I have been trying to help them, as the | pipe is a common delimiter anywhere else, but I cannot find a reliable or well documented source to do this.

Exactly what do I need to import this excel file and have the synonyms show up as separate words, rather than how it shows up now as an ENTIRE string including the pipe characters in their termbase? The poor documentation is making this extremely frustrating, since this to me does not seem outside of the norm for importing documents into pieces of software (Heck, I've written software that by default would work this way, that is less complex in it's scope compared to Trados).

We are able to import it, but like I said the ONLY issue is that it does not recognize the synonyms as separate words and simple shows word1|word2|word3 when viewing the specific entry in Multiterm.

I'm not sure if we need to use Glossary Conveter, or multiterm convert, or some other piece of software since trados seems to just like pumping out tools with no proper documentation.

Sorry if this is rude, but this is extremely frustrating for something that really shouldn't be.

emoji
Parents Reply
  • Hi Chris,

    The frustration with spreadsheets is rooted in the fact that they are not really suitable for terminology data, It's necessary to create a spreadsheet format that somehow maps the tree structure of termbase data into the 2-dimensional grid of a spreadsheet. Unfortunately, there is a near infinite number of possible formats.

    Despite Paul's Enthusiasm your format is not quite trivial for the glossary converter... but if you shuffle the columns around, it can be. Assuming this is the termbase format you want to achieve

    Screenshot of a MultiTerm termbase entry with fields for English and French. English section includes 'wordOne' and 'synonymOne'. French section includes 'translationOne' and 'synonymTranslatedTwo'.

    then this spreadsheet will get you there:

    Source English >>I<<Definition French >>I<<Definition
    Some website wordOne|synonymOne Bla bla bla translationOne|synonymTranslatedTwo Bla bla bla

    Hope this avoids further frustration Slight smile

    emoji


    Generated Image Alt-Text
    [edited by: RWS Community AI at 12:56 PM (GMT 0) on 23 Dec 2024]
Children
No Data