In my previous post, I discussed how to convert a glossary into the SDL Trados TM using ApSIC Xbench. In this post, I will explain a more simple way to convert a glossary into the SDL Trados 2011/2014 TM using the Tab Delimited Text filter.
1. First, convert a glossary file into a tab-delimited text file. For a glossary in Excel format, simply coping and pasting all entries into a text file will creates a tab-delimited text file. (Or you can also save it as tab delimited text file or a comma delimited text format.) For example, it will look like the following:
2. Go to "Tools" > "Options," and select "File Types" and then "Tab Delimited Text." (If the format of the glossary is CSV (Comma Delimited Text,) please select "Comma Delimited Text (CSV)" instead.)
3. On the "Format" tab, specify settings as shown in the following figure:
4. Now, you can open the document for translation by clicking the "Open Document for translation" icon in SDL Trados Studio (or "File" > "Open" > "Document" in the SDL Trados Studio menu.)
In the "Open Document" dialog, please select "Tab Delimited Text Documents" as the File Type.
5. When the document is opened in the SDL Trados Studio Editor, you can save it and then perform Batch Tasks to update TM. (Or, you can use SDLXliff2Tmx to export the sdlxliff file to a tmx file.)
There are several ways to import the glossary entries into a Trados TM. In this post, I explained how to convert a glossary into the SDL Trados TM using the Tab Delimited Text filter. If you are familiar with regular expressions, you can easily convert a tab delimited text file into a tmx file using the following setting in the Find & Replace feature:
Find: (.*)\t(.*)
Replace with: <TrU>\r\n<Seg L=EN-US>\1\r\n<Seg L=KO-KR>\2\r\n</TrU>
(Language codes need to be changed according to your language pairs.)
This method is simpler to follow (Please refer to this post.)