Removing duplicate entries from termbase
Thread poster: Yaniv Moshkovitz

Yaniv Moshkovitz  Identity Verified
Israel
Local time: 23:52
Member (2014)
Arabic to English
+ ...
Feb 21, 2012

Hello,
I'm using SDL MultiTerm 2011. I have a termbase with duplicate entries due to several import attempts. Here is what I did in order to try to remove them:
1. Exported the termbase to a tab-delimited text file, which I then opened on Excel. Here each entry appeared only once.
2. Used MultiTerm Convert to turn the Excel file to an mtf file.
3. Created a new Termbase.
4. Imported the entries from the mtf file.

Even though each entry appeared just once in the excel file from Step 1, when I opened the new termbase I saw the duplicate entries again.

What should I do?

Thanks


 

Sandra& Kenneth  Identity Verified
Israel
Local time: 23:52
Member (2009)
French to English
+ ...
Use MT Feb 21, 2012

I don't understand why you did what you did.
Open MultiTerm, load your termbase. Browse the terms, find the duplicates, right click, press Delete.
HTH
icon_smile.gif


 

Jerzy Czopik  Identity Verified
Germany
Local time: 22:52
Member (2003)
Polish to German
+ ...
Default import definition will always import duplicates Feb 21, 2012

You must write a new import definition and synchronize the export on entries, then chose synchronize on your main (source language) and define what to do with already existing entries.

@Sangro: Why not in MT? Because if you have many duplicates it is a long lasting work...


 

FarkasAndras
Local time: 22:52
English to Hungarian
+ ...
Sure? Feb 21, 2012

Yaniv Moshkovitz wrote:

1. Exported the termbase to a tab-delimited text file, which I then opened on Excel. Here each entry appeared only once.


First of all, the tab delimited export is unreliable. It may corrupt your TB so should probably stay away from it.
Second, my guess is that the duplicates were there in the Excel file, only not in adjacent rows. Sort the spreadsheet alphabetically and you'll see if I'm right.


 

Yaniv Moshkovitz  Identity Verified
Israel
Local time: 23:52
Member (2014)
Arabic to English
+ ...
TOPIC STARTER
Need more information Feb 22, 2012

Dear Jerzy Czopik,
Could you please elaborate a bit more on the process of writing a new import definition and performing the synchronization?

FarkasAndras: the Excel file is already sorted by alphabet, and surprisingly the duplicates aren't there.

Sangro: since there are hundreds of terms, this can be exhausting and extremely time consuming...


 

VaclavCermak
Czech Republic
Local time: 22:52
"delete" option is greyed out Apr 30, 2015

Sandra& Kenneth wrote:

I don't understand why you did what you did.
Open MultiTerm, load your termbase. Browse the terms, find the duplicates, right click, press Delete.
HTH
icon_smile.gif


I have Studio 2014 and can't do what you suggest - although that might be the most logic action to take. However, the "delete" option is greyed out i nthe context menu.
Does anyone have a clue how to proceed?


 

Alex Lilo
Ukraine
Local time: 23:52
English to Russian
+ ...
create an import definition Oct 22, 2015

http://producthelp.sdl.com/kb/Articles/4605.html

 

Persian Version

Local time: 01:22
English to Farsi (Persian)
+ ...
removing duplicates from a termbase Jul 17, 2016

I had the same issue and didn't know there was a Ctrl + D shortcut for this!

in multiterm desktop, go to search menu, and choose "Search for duplicate terms"

[Edited at 2016-07-17 16:59 GMT]


 


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


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

Removing duplicate entries from termbase

Advanced search







SDL Trados Studio 2017 only €435 / $519
Get the cheapest prices for SDL Trados Studio 2017 on ProZ.com

Join this translator’s group buy brought to you by ProZ.com and buy SDL Trados Studio 2017 Freelance for only €435 / $519 / £345 / ¥63000 You will also receive FREE access to Studio 2019 when released.

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search