Author Topic: Convert multiple excel files to tmx or Trados txt translation memory [TmBuilder]  (Read 12649 times)

spiros

  • Administrator
  • Hero Member
  • *****
  • Posts: 699075
  • Gender: Male
  • point d’amour
    • spiros.doikas
    • greektranslator
    • doikas
    • 102094522373850556729
    • lavagraph
    • Greek translator CV
TM builder used to crash in older to 1.0.4 versions (latest working version attached), I also recommend this alternative tool http://www.cerebus.de/glossaryconverter/
Try also this online utility: http://translatum.gr/cgi-bin/excel-to-tmx.pl

Convert multiple excel files to tmx or Trados txt translation memory [TmBuilder]

TMbuilder is a Translation Memory export creator is a small tool that makes building up TM export/import files as straight-forward as possible. The 1.01 build uses code pieces from a previously created console-based version but has a nice and handy GUI. It was written in Microsoft Visual Studio 2008 so the Microsoft .NET Framework 3.5 is necessary to use the application.

— Accepts two input formats: tab-delimited text files and MS Excel spreadsheets
— Creates output files in two file formats: Translator's Workbench 7.x/8.x (TXT) and the Translation Memory eXchange (TMX)
— Works on multiple input files and offers a merging feature—there might be just one import file
— Allows the user to specify standard TM fields, like: source and target ISO flags, segment descriptions and author name
Removes additional quotes often created by MS Excel when saving the file to the Text form
— Works with standard encodings: Unicode and UTF-8
— Rapid file creation: milliseconds for .txt and seconds for .xls input files
— Application is free for non-commercial use and can be distributed as a standalone executable program



See also:
Convert Excel glossaries to Multiterm 5 format or to Trados translation memory (txt import file)


TM Builder crash info:

Code: [Select]
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Runtime.InteropServices.COMException (0x80028018): Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
   at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad)
   at TMbuilder1._0.Form1.utworz_tm(String plik_wejsciowy, Boolean tw, Boolean tmx)
   at TMbuilder1._0.Form1.button4_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5472 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
TMbuilder1.0
    Assembly Version: 1.0.0.34
    Win32 Version: 1.0.0.34
    CodeBase: file:///H:/Downloads-H/tools05/mine/TMbuilder/TMbuilder1.0.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5468 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.Office.Interop.Excel
    Assembly Version: 11.0.0.0
    Win32 Version: 11.0.5530
    CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.Office.Interop.Excel/11.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Excel.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
« Last Edit: 02 Mar, 2015, 16:19:06 by spiros »


zocipro

  • Semi-Newbie
  • *
  • Posts: 1
Will the files then be compatible with Trados 2007 ...as need to send like materials from my work ? THANKS.

spiros

  • Administrator
  • Hero Member
  • *****
  • Posts: 699075
  • Gender: Male
  • point d’amour
    • spiros.doikas
    • greektranslator
    • doikas
    • 102094522373850556729
    • lavagraph
    • Greek translator CV
Yes, export as tmx.


michaelbeijer

  • Semi-Newbie
  • *
  • Posts: 5
TMbuilder works fine on my computer (Win7 64-bit), but it sometimes introduces stuff like "&apos;" instead of apostrophes. It also spits out UTF-16, which I don't like. TM Maker in the LF Aligner "Grab Bag" also adds these HTML characters.

The best free TMX creator I have found is actually inside the now free Heartsome TMX Editor:

Tools > Convert to TMX … produces perfect TMXs every time!

spiros

  • Administrator
  • Hero Member
  • *****
  • Posts: 699075
  • Gender: Male
  • point d’amour
    • spiros.doikas
    • greektranslator
    • doikas
    • 102094522373850556729
    • lavagraph
    • Greek translator CV
In fact the issue was fixed in latest version (1.0.4).

Xbench does the trick too and there is an online tool also:
http://translatum.gr/cgi-bin/excel-to-tmx.pl