Importing a limited number of languages

Dear Multiterm experts,

I have an export file of the Multiterm base that contains multiple languages. But I want to import only 3 of them.
I thought I could edit the termbase definition (delete unnecessary languages) and then import with "Allow over-complete entries" selected. But it seems that it does not add entries, if there are not only terms in required languages but also in languages missing in the termbase definition. E.g. if I do not change the termbase definition it imports 25000 German entries including 3000 Russian terms. If I change the termbase definition and leave only German, English and Russian it imports 20000 German entries including only 12 Russian terms.
What is the right way to import a limited number of languages from the multilingual termbase export?

Parents
  • Hi Anna,

    The first thing to make sure is that both termbases are based on the same termbase definition because otherwise you may be trying to bring in fields from your XML that are not in the termbase you are importing to.

    But a simple workaround to avoid messing with import definitions might be these using the Glossary Converter from the OpenExchange:

    1. Use the Glossary Converter to convert the XML to Excel
    2. Clean up the Excel so it only contains the values you want (if you didn't just export the languages you want to Excel during conversion with the Glossary converter)
    3. Convert the cleaned up Excel to MultiTerm XML and import that to your Termbase

    or....

    1. Use the Glossary Converter to convert your termbase to Excel
    2. Use the Glossary Converter to convert the XML to Excel
    3. Combine the Excel files in the structure you wish (remove duplicates in Excel too)
    4. Use the Glossary Converter to recreate your Termbase

    Depending on the content of your Termbase the second option may be the easiest, but if your Termbase is complex then the first method might be easier to just get three language fields in and nothing else.

    Regards

    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

  • Hi Paul,
    Thank you very much for your answer.
    Yes, it is the same termbase definition. I leave all fields unchanged, I delete only unnecessary languages. So you mean the way I tried should work provided that the definition is the same and the termbase is all right? Then I'll test it one more time on a simplier termbase.
    I suspected I could use Glossary Converter, but it is not so fast and convenient, if I get an export file with new terms every month. But I'll keep it as a final resort. Thank you for the detailed workaround with Glossary Converter.
  • Hi Anna,

    If it helps and you can share your termbase and an import file we can take a look?

    Regards

    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

  • Hi Paul,
    I've tested my method on a simplier termbase once more and found what I had done wrong.
    Earlier I had deleted unnecessary languages while creating a termbase (directly in Termbase Wizard after loading definition file), but such termbase could not import entries with terms in languages missing in the termbase definition.
    Now I've tried to change the definition after an empty termbase (with all MDF and MTF-files for all languages) is created, and this time import has succeeded. Thank you for your help!
  • Hi Anna,

    I don't think I really helped... but sometimes it's just good to talk :-)

    Glad you sorted it out!!

    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

  • Hi  and  

    I tried out Anna's solution to be able to split a very large termbase into smaller ones containing only a few languages:

    Modified the term definition of an existing, empty termbase by deleting all indexes/languages not needed and then  imported the xml.

    I found out that MT only imports the full number of entries containing terms in the selected languages if I choose the option "Allow over-complete entries" (as Anna had observed as well).

    But if I do so MT will import all languages and terms contained in the XML  It seems that MT can only import and filter on the entry level.

    The desired result would be a termbase containing exactly the full number of terms in the selected languages. 

    As a first solution I use an XSL transformation on the XML to get rid of the unwanted languageGrp elements.

    Is there a simpler solution to the desired result by using MT without having to manipulate the XML before importing it?

    PS: Using the Glossary Converter (which would do the job exactly in the way I want it) is not an option in my case. 

    Thank you for your help

    emoji
Reply
  • Hi  and  

    I tried out Anna's solution to be able to split a very large termbase into smaller ones containing only a few languages:

    Modified the term definition of an existing, empty termbase by deleting all indexes/languages not needed and then  imported the xml.

    I found out that MT only imports the full number of entries containing terms in the selected languages if I choose the option "Allow over-complete entries" (as Anna had observed as well).

    But if I do so MT will import all languages and terms contained in the XML  It seems that MT can only import and filter on the entry level.

    The desired result would be a termbase containing exactly the full number of terms in the selected languages. 

    As a first solution I use an XSL transformation on the XML to get rid of the unwanted languageGrp elements.

    Is there a simpler solution to the desired result by using MT without having to manipulate the XML before importing it?

    PS: Using the Glossary Converter (which would do the job exactly in the way I want it) is not an option in my case. 

    Thank you for your help

    emoji
Children