I am using Multiterm 220.127.116.114. I have an old Termbase that contains over 11000 entries in multiple languages. It has been decided that the structure of the TD needs to change, so I will need to transfer all the legacy content into a new Termbase that follows the new structure. The field names do not match between the old and new TDs. What is the best way to do this conversion? I initially thought I could export the legacy TD into an Excel format, change the order and the title of the columns to be compatible with the new TD structure, use Multiterm convert to create an XML and then import that XML into the new TD, but the first step, exporting into an Excel format does not seem to work, since not all entries have the exact same fields populated the data gets misalligned.
The MT programmers are idiots and are unable to produce correct CSV (Excel) files.
In fact, none of MT export filters work as expected.
I would appreciate advice regarding how to work around this. Thank you!
IMHO the best approach for dummies is to import the XML file in Across, then export as CSV.
Across is free of charge for freelance translators although the registration page is not easy to find
Attention, the download is huge (it contains the MS SQL Server Express, it makes approx. 0.5 GB).
Your termbase structure is very complex?
If yes, you may need to modify the Across termbase structure (i.e. add the missing fields).
If you don't want to install Across, another possibility is to create your own export filter for MT5 (not intuitive at all but you have no other way, the default MT5 export is a crap i.e. it doesn't work for multiple languages), modify the field names in the MT5 text file, create a MT5 termbase with the same field structure, then import the MT5 binary termbase to MT7.
Frankly, I think it's more annoying than the Acress process
In fact, every complex export from MT7 is a pain in the arse.
If you change only the field names, it may be sufficient to open your XML file in a good text editor as Notepad++ and make the changes directly in the XML file (global search and replace operations).
A skilled XML programmer should write a transformation in a breeze.
[Edited at 2008-12-27 11:56 GMT]