Convert Transit's MARTIF to Excel, tab-del or CSV? Thread poster: Hans Lenting
|
How to convert Transit's MARTIF to Excel, tab-del or CSV, without using TermStar? | | | wotswot France Local time: 10:40 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. Richard
[Edited at 2023-08-26 10:50 GMT]
[Edited at 2023-08-26 10:52 GMT] ▲ Collapse | | | Hans Lenting Netherlands Member (2006) German to Dutch TOPIC STARTER
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 | | | Gary Hess Local time: 10:40 German to English + ...
|
|
Hans Lenting Netherlands Member (2006) German to Dutch TOPIC STARTER
Thank you, Gary, that worked! | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » Convert Transit's MARTIF to Excel, tab-del or CSV? Protemos translation business management system | Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
More info » |
| TM-Town | Manage your TMs and Terms ... and boost your translation business
Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |