{"id":4402,"date":"2023-07-11T13:05:38","date_gmt":"2023-07-11T11:05:38","guid":{"rendered":"https:\/\/kaleidoscope.at\/?post_type=blog&p=4402"},"modified":"2025-02-13T09:31:55","modified_gmt":"2025-02-13T08:31:55","slug":"terminology-merging-duplicate-entries-made-easy","status":"publish","type":"blog","link":"https:\/\/kaleidoscope.at\/en\/blog\/terminology-merging-duplicate-entries-made-easy\/","title":{"rendered":"Terminology: Merging duplicate entries made easy"},"content":{"rendered":"\n

One of the most daunting tasks for companies that decide to introduce terminology management is populating the termbase with entries in the first place. I don't mean creating entries from scratch, but rather collecting and importing existing terminologies. In this post, I will look at the process of adding legacy terminology to Kalcium Quickterm<\/a> with the main focus on merging duplicate entries, technically called doublettes. I will finish with outlining some performance data, and I hope to show you that what may initially seem like a miserable endeavor can actually be accomplished in a reasonable timeframe.<\/p>\n\n\n\n

Although most companies don't formally manage their terminology, terminology work happens anyway: product managers coin new names for their products; content publishers check correct terminology usage; translators research concepts in order to find correct equivalents in their target languages, and so on. When the decision to manage the corporate language in a centralized terminology management system (TMS) is made, someone will have to collect and harmonize terms and concepts. The desired end result is to have one entry per concept including all designations and supporting terminological information (e.g., part of speech, definition, definition source).<\/p>\n\n\n\n

So, the goal is clear. Ideally a trained terminologist would be entrusted with this task. They will collect terminologies from as many resources as they can identify, such as glossaries from WorldServer<\/a>, spreadsheets from product managers, or lists published in style guides. The data from all these sources would then be compiled in a termbase-compatible format and imported into Kalcium.<\/p>\n\n\n\n

\n

Concept harmonization is not trivial. But the mechanics to remove doublettes in Kalcium could not be easier<\/p>\n<\/blockquote>\n\n\n\n

<\/p>\n\n\n\n

Some degree of cleaning is necessary before this information can be imported. For example, if a column in a spreadsheet combines two or more types of data, they must be separated.<\/p>\n\n\n\n

\"Some<\/figure>\n\n\n\n

The information in the \"Forbidden English\" column above needs to be split into separate lines of synonyms with their correct usage status. Here is one way to organize the above data:<\/p>\n\n\n\n

\"The<\/figure>\n\n\n\n

In this example, it is easy to import all the terms into one entry. But if these synonyms and their terminological data are documented in different spreadsheets, we may not immediately recognize that they all refer to the same concept. That is really the task of concept harmonization. Is it simple? No. But Kalcium Quickterm makes merging records very easy.<\/p>\n\n\n\n

In the following screenshot, we can see the button that allows us to merge two entries.<\/p>\n\n\n\n

\"In<\/figure>\n\n\n\n

When we click on it, we get to a form where we select the additional entry to check against. The form below shows us data categories containing information from both entries.<\/p>\n\n\n\n

\"The<\/figure>\n\n\n\n

We can delete what we don't need, improve existing data, and add additional information. We can also decide whether we want to delete both entries and create a completely new one, or choose an existing entry to retain.<\/p>\n\n\n\n

In the above example, I deleted the second definition and modified the first. I added a definition source and a usage status of \"deprecated\" for the term \"stick. I would do more, if I didn't already know that there is another entry for the same concept with additional information. Therefore I don't spend time completing all the necessary information for this concept, but simply repeat the merge process. This brings me to the following form.<\/p>\n\n\n\n

\"Here<\/figure>\n\n\n\n

I analyze and research as necessary and combine the information into one correct and complete entry.<\/p>\n\n\n\n

\"The<\/figure>\n\n\n\n

Concept harmonization is not trivial. But the mechanics to remove doublettes in Kalcium could not be easier. In a recent project, I started out with the following:<\/p>\n\n\n\n