Importing Excel glossary into Multiterm
Thread poster: Natalya Zelikova
Natalya Zelikova
Natalya Zelikova  Identity Verified
Poland
Local time: 08:37
English to Russian
+ ...
Mar 18, 2005

I have Excel glossary with multiple sheets (2 columns in which - source and target) to be imported in Multiterm for translation of a Word file in Trados.
I am doing this for the first time and can't find the way to import it. Should I convert Excel file first in required import format?

I seem to can't understand how I can do this in MultiTerm Migration Tool, which I have to use for this, if I'm not mistaken...

Would appreciate quick reply, as it's rather urgent.


 
Clarisa Moraña
Clarisa Moraña  Identity Verified
United States
Local time: 01:37
Member (2002)
English to Spanish
+ ...
Which Excel version do you have? Mar 18, 2005

Hi, Natalia

From the Multiterm User Guide:

"MultiTerm Convert directly supports Excel 2000,Excel 2002 (XP)and Excel 2003.Users of Excel 97 must prepare their files..."


So, to start with, please let us know wich Excel version do you have.


 
Natalya Zelikova
Natalya Zelikova  Identity Verified
Poland
Local time: 08:37
English to Russian
+ ...
TOPIC STARTER
XP Mar 18, 2005

Hi, Clarisa,

I use Excel 2002 (XP) and the error I receive is some runtime error (abnormal program termination) on a stage of "Processing the Import" of xml file I created from my Excel file...


 
Clarisa Moraña
Clarisa Moraña  Identity Verified
United States
Local time: 01:37
Member (2002)
English to Spanish
+ ...
:-( Mar 18, 2005

Hi, Natalia

I'm afraid I can't help you. I've Excel 97, thus all my experience with the Trados Convert tool does not apply to your case.

I'm sure someone else will help you.

Regards

Clarisa


 
Clarisa Moraña
Clarisa Moraña  Identity Verified
United States
Local time: 01:37
Member (2002)
English to Spanish
+ ...
Have you checked if the Excel file is well prepared? Mar 18, 2005

Also, from the Trados Multiterm user guide:

Your Microsoft Excel file (*.xls must comply with the following preconditions:
* All data must be located n the first sheet in the book.
* The first row or line in the file must contain the information from the header field of each
column.
* No empty columns should appear between the columns that contain data.If the file contains an empty column between columns that contain data,the conversion process will stop at the empty column. Be sure to remove any empty columns of this kind before you run the conversion.


 
Natalya Zelikova
Natalya Zelikova  Identity Verified
Poland
Local time: 08:37
English to Russian
+ ...
TOPIC STARTER
multiple sheets... Mar 19, 2005

Well, but I have multiple sheets, should I then copy all data into first sheet to convert the file correctly?

 
Ralf Lemster
Ralf Lemster  Identity Verified
Germany
Local time: 08:37
English to German
+ ...
Which MultiTerm version? Mar 19, 2005

Hi Natalya,
The import routines for different versions of MultiTerm (5.x, 6.0.x, 6.2.0.x) differ fundamentally - therefore, could you please specify which version you're using? (Full version number including the 'build number', please - got to Help - About... to find out.)

Best regards,
Ralf


 
Natalya Zelikova
Natalya Zelikova  Identity Verified
Poland
Local time: 08:37
English to Russian
+ ...
TOPIC STARTER
... Mar 19, 2005

Hi, Ralf

MultiTerm iX (6.0.1.209)
Still can't find the way...


 
Ralf Lemster
Ralf Lemster  Identity Verified
Germany
Local time: 08:37
English to German
+ ...
No wonder Mar 19, 2005

Hi again,
Natalya Zelikova wrote:

Hi, Ralf

MultiTerm iX (6.0.1.209)
Still can't find the way...

I'm not surprised, as the first version of MTiX did not support the import of Excel files. This was replaced in 2003 by version 6.2.0.267 (meanwhile upgraded to build 287), which incorporates MultiTerm Convert. This utility lets you convert Excel files.

For details, check FAQ##28-30 in the Support section of the Trados website.

Best regards,
Ralf


 
Natalya Zelikova
Natalya Zelikova  Identity Verified
Poland
Local time: 08:37
English to Russian
+ ...
TOPIC STARTER
... Mar 19, 2005

Thank you.

 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Importing Excel glossary into Multiterm







Anycount & Translation Office 3000
Translation Office 3000

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.

More info »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »