• State Verified Answer
  • Replies 9 replies
  • Answers 3 answers
  • Subscribers 189 subscribers
  • Views 5437 views
  • Users 0 members are here
Options
Related

Multiterm failing to import/distinguish language variants

Almudena Ballester

I have an excel glossary for several languages including variants for Spanish (Mexico, Argentina) and Portuguese (Brazil, Portugal). I treated each variant as a new language and therefore I create separate columns for them like this:

Then, I use Multiterm Convert to create Multiterm Database and carefully asign each column to language variant like this:

Same for ptPT for Portuguese (Portugal). Then I get my structure:

which distinguish between both language variants. But when I create my Termbase with Multiterm Desktop or Multiterm Server, I just get all portuguese terms under Portuguese (Brazil) and all spanish terms under Spanish (Argentina), no terms for Spanish (Spain), Spanish (Mexico), nor for Portuguese (Portugal), like this:

I've been using Multiterm, Multiterm convert and all Multiterm products since ever, so this time I think it is not a matter of not doing things right... I think it's a bug :(

I like to use Multiterm Convert instead other solutions like Glossary Converter because I want to keep .xcd, .xdt files for further Termbase updates and I also like to have control over structure and fields, etc.

Any suggestions?

Thanks in advance,

Almudena
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents
  • 0

    Hi Almudena,

    Don't let that stop you using the Glossary Converter.  It can create your definition files too!  However, let's look at MultiTerm Convert.  Can you share a small sample spreadsheet with just a dozen lines perhaps?  Makes it easier to provide a better answer if we're working with the same starting point as you.

    You can put the spreadsheet in here if you like (instructions are in this article).

    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

  • 0 in reply to Paul

    sample-language_variants.xlsx

    Hi Paul,

    I'll try with Glossary Converter indeed... Anyway I'm attaching a sample of my spreadsheet. Some languages are empty but problematic ones have some examples for you to test.

    Many thanks in advance!

    Almudena
  • 0 in reply to Almudena Ballester

    Hi Almudena,

    I have done this using the Glossary Converter (just like this tool better), but had to structure your spreadsheet a little differently to achieve it.  So I get this now for example:

    I have attached the spreadsheet I used and the converted termbase.  maybe this will help you as you could also use the termbase to edit the definition to suit what you really wanted and then base your proper termbase on that.

    gc_no_picklists.xlsx

    https://community.rws.com/cfs-file/__key/communityserver-discussions-components-files/91/gc_5F00_no_5F00_picklists.sdltb

    Hope this helps... also hope it's right!!

    Regards

    Paul

    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

  • 0 in reply to Paul

    Hi Paul,

    Many thanks for this solution. I see that you only leave one cell for each language whereas I keep three: a cell for main term, a cell for a synonym and another cell for a special form of term, which I also categorise with a field (cat).

    I know that your option, all terms in one cell separated through "|" is an easier way but I like to keep translations separate so I can add info for each translation variant. For example, it is a forbidden translation, it is an acronym, it is preferred... If I don't do this way, my cat field goes under an (unique) term level and categorises terms wrongly like here:

    It should read under term form DELE. I do this to warn my translators in case a special project or document doesn't allow a particular translation, etc.

    Also I'd like to show language names in .sdltb with full original name and not with those codes I use in excel for practical reasons...

    So, what about Multiterm Convert? Is there really a bug with language variants or am I doing something wrong...? I will give a try to Glossary Converter and re-build my termbase the way you did, but I'd really like to know if I need to discard my old method if termbase involves language variants.

    Many thanks again,

    Almudena
  • 0 in reply to Almudena Ballester
    Hi Almudena,

    You can also do what you want this way too. You just separate the notes with the same pipe separator. I do have one set up this way ready to go, and also with a different way to categorise the variants, but when I tested it found a bug with the Glossary Converter so the developer will work on this for his next update. As explained to me by the developer... "The problem is that the fields are assigned to the language left of them. But if that language has no term, the field "falls through" to the next one. For example, the English column is followed by empty Spanish and Finnish columns, and thus ends up with the fields for all three. "

    Once this is fixed it should work.

    I'm going to break a golden rule and have a look at MT Convert :-(

    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

Reply
  • 0 in reply to Almudena Ballester
    Hi Almudena,

    You can also do what you want this way too. You just separate the notes with the same pipe separator. I do have one set up this way ready to go, and also with a different way to categorise the variants, but when I tested it found a bug with the Glossary Converter so the developer will work on this for his next update. As explained to me by the developer... "The problem is that the fields are assigned to the language left of them. But if that language has no term, the field "falls through" to the next one. For example, the English column is followed by empty Spanish and Finnish columns, and thus ends up with the fields for all three. "

    Once this is fixed it should work.

    I'm going to break a golden rule and have a look at MT Convert :-(

    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

Children