This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
Convert Transit's MARTIF to Excel, tab-del or CSV?
Thread poster: Hans Lenting
Hans Lenting Netherlands Member (2006) German to Dutch
Aug 26, 2023
How to convert Transit's MARTIF to Excel, tab-del or CSV, without using TermStar?
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
wotswot France Local time: 17:22 Member (2011) French to English
MTF to Excel
Aug 26, 2023
Hi Hans, the only way I know is to write a custom program that functionally does the same as Termstar's export option but without all the unnecessary information. It all depends on the structure of your dictionary and on what fields you want to retrieve for each dictionary "record" (i.e. (between termEntry id='x' and /termEntry in the MTF). I've written one for my main Termstar dictionary (FR > EN) in Excel VBA, which reads the MTF and writes to an Excel worksheet with one row per Termstar... See more
Hi Hans, the only way I know is to write a custom program that functionally does the same as Termstar's export option but without all the unnecessary information. It all depends on the structure of your dictionary and on what fields you want to retrieve for each dictionary "record" (i.e. (between termEntry id='x' and /termEntry in the MTF). I've written one for my main Termstar dictionary (FR > EN) in Excel VBA, which reads the MTF and writes to an Excel worksheet with one row per Termstar "record" and 1 to n columns for each SL and TL term. Each of the latter is one Excel cell, which in addition to the term itself also includes the term's Remark field (if not empty) and its last modified date. If you are familiar with VBA, in your Excel VBA project make sure to add a reference to Microsoft ActiveX Data Objects 2.x (x being the latest version on your computer); this ensures correct UTF-8 processing in Excel. In your code, create a stream object before looping through the MTF and read the MTF into the stream object you've created. For each MTF record, add a row in your Excel worksheet, and write each field you want to export to a column on that row.
Let me know if you need any help. I could write a custom program for you if you can provide a small MTF that includes at least one record with all the fields you want to export from it.
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Hans Lenting Netherlands Member (2006) German to Dutch
TOPIC STARTER
Thank you
Aug 26, 2023
Hello Richard,
Thank you for your generous offer!
For now, I have solved the task by deleting all lines that don't contain either the source term or the target term (since these are the only data that I need). After that, I separated them with a tab character via a simple find and replace action.
Cheers,
Hans
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Gary Hess Local time: 17:22 German to English + ...
Xbench
Oct 19, 2023
Hi Hans,
I think that Xbench will do what you want to do. See these links:
Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.
Exclusive discount for ProZ.com users!
Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value