Exporting TM's from Idiom

ProZ.com Translation Article Knowledgebase

Articles about translation and interpreting
Article Categories
Search Articles


Advanced Search
About the Articles Knowledgebase
ProZ.com has created this section with the goals of:

Further enabling knowledge sharing among professionals
Providing resources for the education of clients and translators
Offering an additional channel for promotion of ProZ.com members (as authors)

We invite your participation and feedback concerning this new resource.

More info and discussion >

Article Options
Your Favorite Articles
Recommended Articles
  1. ProZ.com overview and action plan (#1 of 8): Sourcing (ie. jobs / directory)
  2. Getting the most out of ProZ.com: A guide for translators and interpreters
  3. El significado de los dichos populares
  4. The difference between editing and proofreading
  5. Does Juliet's Rose, by Any Other Name, Smell as Sweet?
No recommended articles found.
Popular Authors
  1. Brett Ferrell
  2. Nico Wiersema
  3. 633310 (X)
  4. Glreiny
  5. Veronica Lupascu
No popular authors found.

 »  Articles Overview  »  Technology  »  CAT Tools  »  Exporting TM's from Idiom

Exporting TM's from Idiom

By Pieter Beens | Published  02/25/2014 | CAT Tools | Recommendation:
Contact the author
Quicklink: http://www.proz.com/doc/3983
Author:
Pieter Beens
Netherlands
English to Dutch translator
Became a member: Jun 1, 2011.
 
View all articles by Pieter Beens

See this author's ProZ.com profile
Idiom Worldserver Desktop Workbench not even offers an option to export Idiom TM's.
So, to make use of the TM your client provides or to use the translations you collected in all the years you use Idiom Worldserver Desktop Workbench, you need to have a workaround which allows you to use all translated segments in another CAT tool. You need to export Idiom TM. That’s what I will explain below.

Things to note before you begin:

-The procedure to export Idiom TM's can be time consuming and complex. To export the translations you should have above average computer experience (and perseverance too)
- For this workflow you need to have software to open Microsoft Access Database files (MDB), Microsoft Excel spreadsheets (XLSX) and Notepad files (TXT)
- Actual button and system texts in other languages may differ

Export Idiom TM: the process

1. Make a backup
You'll never know what can happen during the process. Therefore I highly recommend you not to use the original WSTM file with the translation memory. Instead copy your WSTM file to a new location (your desktop for instance) and use the copy for this procedure.


2. Converting the Idiom WSTM file to MDB
The WSTM file in Idiom Worldserver Desktop Workbench is nothing else than a Microsoft Access Database file with a different extension. You can simply open the WSTM file in Microsoft Access by changing the file extension.
You can do that as follows: in Microsoft Explorer, in the ribbon click on ‘View’ and select ‘File Extensions’. You will now see the file extension of the TM. Select the TM file, hit ‘F2’ at your keyboard and change ‘wstm’ behind the file name into ‘mdb’. Your file is now ready to be opened in Microsoft Access.

3. Accessing the TM content in Access
Now the TM is ‘converted’ to a Microsoft Access Database double-click on the file to actually open it in Access. You will see a view with tables now. One of the tables (generally the sixth) is called ‘Sentences’. Double-click this table. You will now see a window in which the content of the table is listed. The first column is called ‘ID’ while the fourth column is called ‘Sentence’. Note that the column ‘ID’ contains two copies per ID: the first ID contains the source text while the second ID contains the target. So in the column ‘Sentence’ you will see:

Target
Source
Target
Source
… (and so on)

4. Making the Idiom TM content useful in Excel
You can now copy the content to Microsoft Excel. To do that hover with your mouse over the column title ‘Sentence’. You will now see the cursor changing into a black arrow pointing down. When you click on the column title now, the whole column, including the title, will be highlighted.
Hit ‘Ctrl + C’ to copy the content, open Microsoft Excel, select cell A1 and hit ‘Ctrl + V’ to paste the copied content. You will now see in Excel:

Target
Source
Target
Source
… (and so on)

Now you need to get the source text and the translation divided. Selecting every odd and even row will be a difficult task. So let’s use a formula for that.
In column B1 add the text ‘Filter’. You now have a title for that column too.
In column B2 add the formula ‘=MOD(ROW(A2);2)’. Copy this formula into each cell in column B where column A has content to. The formula will check if the cell is Odd or Even. For each Even row it will add a ‘0’, for each Odd row it will add a ‘1’.

NOTE: the use of formulas in Microsoft Excel is localized. I found a helpful overview of translated formulas here.

5. Exporting the source and targets from the TM
Now add a filter to column B. Select cell B1 and go to ‘Home’ > ‘Sort and filter’.
Filter the content on the source text by clicking on the arrow in cell B1 and selecting the 0. When you apply the filter you will see only the source text. Select the content from cell A2 until the last cell in the column A and copy it. Open an Notepad file and paste the content in it. Save the file as ‘Source.txt’.
Repeat this step for the target text. In cell B1 filter on ‘1’. After applying the filter you will see the target text. Select the content in the column A and copy and paste it to a new Notepad file. Save the file as ‘Target.txt’.

6. Creating a CSV file
Now you have three files: the Excel document with the content of the Microsoft Access Database, a Notepad file called ‘Source.txt’ and a Notepad file called ‘Target.txt’.
For this step we only need the Notepad files.

Create a new Excel document.
In column A paste the content of the file ‘Source.txt’.
In column C paste the content of the file ‘Target.txt’.
In column B add a semi-colon (;) to each cell.

Finally we need to combine the content from the three columns into one column.
Therefore in Cell D2 we add the formula ‘=CONCATENATE(A1;B1;C1)’. You now see the text of the three columns combined into one column. Copy the formula to all cells in column D.
Then select the content of column D and copy and paste it to a new Notepad file. You need to do it because otherwise you will copy the formulas without the actual text.
Past the text in the Notepad file, copy it again and now paste it into a new Excel spreadsheet.
Save the Excel spreadsheet as TM_export.csv. Your CSV file is ready now.

NOTE: You can also chose to save the pasted content in Notepad as TM_export.csv. That’s a bit faster.

7. Importing the Idiom TM content in MemoQ
Now you can import the exported segments into your MemoQ TM. In MemoQ go to ‘Translation memories’ and select the TM you want to import the files to.
In the bottom of the windows select ‘Import from TMX/CSV’. A window will be opened in which you can browse to the file. Select the file and hit ‘Open’. You will now see a window called ‘Translation Memory CSV Import settings’.
Choose ‘Semicolon’ for ‘Delimiter’. Under ‘Fields’ select field F0 and select the radio button ‘Import as source segment’. Select field F1 and select the radio button ‘Import as target segment’. Click the OK button. Everything will be imported now.

That’s how it works. Enjoy and feel free to leave any comments below!


Copyright © ProZ.com, 1999-2019. All rights reserved.
Comments on this article

Knowledgebase Contributions Related to this Article
  • No contributions found.
     
Want to contribute to the article knowledgebase? Join ProZ.com.


Articles are copyright © ProZ.com, 1999-2019, except where otherwise indicated. All rights reserved.
Content may not be republished without the consent of ProZ.com.




Your current localization setting

English

Select a language

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