{"id":680,"date":"2012-09-27T19:41:09","date_gmt":"2012-09-27T18:41:09","guid":{"rendered":"http:\/\/wasaty.pl\/blog\/?p=680"},"modified":"2012-09-27T19:42:37","modified_gmt":"2012-09-27T18:42:37","slug":"dealing-with-sajan-tms-exports","status":"publish","type":"post","link":"http:\/\/wasaty.pl\/blog\/2012\/09\/27\/dealing-with-sajan-tms-exports\/","title":{"rendered":"Dealing with Sajan TMS exports"},"content":{"rendered":"
Tweet<\/a><\/div>\n

\"\"One of my end clients recently introduced Sajan TM management system. As a result, instead of Trados TMs and TTX files which were a standard previously, I began to receive jobs as an Excel files, containing source segments and pre-translation (from 80% matches up) in separate columns. Additionally there’s a column with TM match percentage and some additional info\/comments. And the Excel has a macro for propagating exact repetitions. Great. My task is to translate what’s missing and make sure the 100% matches strictly follow a mandatory glossary (in a separate Excel file). The general attitude was “we have a great new system, deal with it”. So I did. And since I’m sure I’m not the only one, I decided to share my solution.<\/p>\n

<\/p>\n

Excel is a great tool for spreadsheets, but it really sucks for text editing. And checking for correct translation of glossary terms in Excel would take an eternity. Also formatting tags are just text, easy to miss or damage. It was obvious that I have to find a workaround for working with these files in a decent CAT environment. Fortunately the task came out to be quite simple and preparation takes just about 5-15 minutes, depending on number of sheets – because every chapter of a file for translation is inserted into a separateExcel sheet.<\/p>\n

Take a look at the Sajan-exported file (click for full size):<\/p>\n

\"\"<\/a><\/p>\n

If only 100% matches were pre-translated, I would just copy source and translation into a separate file, create a TM using this tool<\/a>, then copied source column into target and imported selected columns for translation. However, with non-100% matches the task was more complicated… or so I thought. Eventually I found an easier and less time-consuming solution. The procedure was designed to import text into memoQ, but should work with any tool accepting Trados bilingual DOC format.<\/p>\n

The procedure:<\/h3>\n
    \n
  1. Create a backup copy of the source file.<\/li>\n
  2. Select and copy to new Excel file columns Match %<\/strong>, Basis<\/strong>, Source<\/strong> and Target<\/strong> from all Excel sheets.<\/li>\n
  3. Remove Basis<\/strong> column.<\/li>\n
  4. Move column Match %<\/strong> between Source<\/strong> and Target<\/strong> (see picture below).
    \n    \"\"<\/a><\/li>\n
  5. Select all three columns and copy them (Ctrl-C<\/strong>).<\/li>\n
  6. Open Word.<\/li>\n
  7. Click on a triangle below Paste<\/strong> icon and select Paste special<\/strong>.
    \n    \"\"<\/a><\/li>\n
  8. Select Non-formatted Unicode text<\/strong>. After pasting, turn on the option to display hidden characters.
    \n    \"\"<\/a><\/li>\n
  9. Insert an empty line before pasted text by pressing Enter<\/strong> at the beginning of the first line.<\/li>\n
  10. Press Ctrl-H<\/strong> to open Search & Replace<\/strong> dialog.<\/li>\n
  11. Click More<\/strong> to display additional dialog options.<\/li>\n
  12. Select Use wildcards<\/strong> check box.<\/li>\n
  13. In the Find<\/strong> field enter: ^9([0-9]*)^9<\/strong><\/li>\n
  14. In the Replace with<\/strong> field enter: <}\\1{><\/strong><\/li>\n
  15. With cursor in the Replace with<\/strong> field click Format > Style<\/strong> and select tw4winMark<\/strong>.
    \nIf you don’t have this style on a style list, open any bilingual Trados .doc or .rtf file and copy a line or two at the beginning of your file. Then try again – tw4winMark style will be on styles list.<\/em><\/li>\n
  16. Click Replace all.<\/li>\n
  17. In the Find<\/strong> field enter: ^13<\/strong><\/li>\n
  18. In the Replace with<\/strong> field enter: <0}^13{0><\/strong>
    \nThe field must still have tw4winMark<\/strong> style.<\/em><\/li>\n
  19. Click Replace all<\/strong>.<\/li>\n
  20. Remove empty first line and any additional text pasted in step 15 (if any).
    \n    \"\"<\/a><\/li>\n
  21. Save the file as Word 97-2003 (.doc) or .rtf file.<\/li>\n
  22. Start memoQ (or use other CAT tool).<\/li>\n
  23. Create a project in memoQ, add document saved in step 22.
    \n    \"\"<\/a><\/li>\n
  24. Open the file for translation, then click Format > Run regex tagger<\/strong>.<\/li>\n
  25. In the Regular expression<\/strong> field enter: {.*?}<\/li>\n
  26. Click Add<\/strong>.<\/li>\n
  27. Click Run tagger now<\/strong> (click OK<\/strong> in the warning dialog).
    \n    \"\"<\/a><\/li>\n
  28. Translate\/review, importing Excel glossary into a project term base.
    \nIf no review of 100% matches is needed, you can sort the file by match percentage, select all 100% matches and confirm them in one go by pressing Ctrl-Enter<\/strong>.<\/em><\/li>\n
  29. When finished, open original Excel file again.<\/li>\n
  30. For all sheets select Source<\/strong> column, copy to Target<\/strong> column. Save.<\/li>\n
  31. Open the Excel file in memoQ importing only target columns for each sheet (Add document as<\/strong>).<\/li>\n
  32. Pre-translate file, perform QA.<\/li>\n
  33. Export finished file.<\/li>\n<\/ol>\n

    Of course the procedure creates some additional overhead, but at the same time it makes it possible to work with received files in a decent environment with all the features of a modern CAT tool, including QA on tags. Of course you can also save the file as XLIFF to perform an additional QA in an external tool, like Xbench or CheckMate.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Tweet One of my end clients recently introduced Sajan TM management system. As a result, instead of Trados TMs and TTX files which were a standard previously, I began to receive jobs as an Excel files, containing source segments and pre-translation (from 80% matches up) in separate columns. Additionally there’s a column with TM match … <\/p>\n

    Continue reading<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6],"tags":[9,20,24],"class_list":["post-680","post","type-post","status-publish","format-standard","hentry","category-narzedzia","category-wskazowki","tag-cat","tag-memoq","tag-porady","item-wrap"],"_links":{"self":[{"href":"http:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/posts\/680","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/comments?post=680"}],"version-history":[{"count":8,"href":"http:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/posts\/680\/revisions"}],"predecessor-version":[{"id":694,"href":"http:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/posts\/680\/revisions\/694"}],"wp:attachment":[{"href":"http:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/media?parent=680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/categories?post=680"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/wasaty.pl\/blog\/wp-json\/wp\/v2\/tags?post=680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}