Mobile menu

How to use SDL multiterm to handle this kind of excel?
Thread poster: Colin lee
Colin lee
Local time: 20:17
Chinese
Sep 28, 2008

I have a excel file including 2 columns; Column A include languages: ie..

Language
Chinese (PRC)
english
Basque
Chinese (Hong Kong)
Indonesian
German
Czech
Norwegian
Finnish
Turkish
Galician
Korean
Estonian
Thai

Colunm B include Term:ie..托管

Term
寄存
hosting
das Hosting, das Webhosting
hostování, hosting
v?re vert
verkkopalvelu
bar?nd?rma
aloxamento, hosting
???
hostimine
???????

Now, i want to extract the mated Term, ie..
English Chinese 。。。。 French
hosting 托管 .
select 选择 .
Getting Started 入门 .
。 。
。 。 .
。 。 .

BTW, the english strings are more than other language, maybe other language are only the part of english Terms.

Everybody, can we use SDL Multiterm to get a result expected? How to handle it ?? any way will be welcome.

Thanks
Colin







[修改时间: 2008-09-28 02:17]

[修改时间: 2008-09-28 02:19]

[修改时间: 2008-09-28 02:22]


Direct link Reply with quote
 

Peter Linton  Identity Verified
Local time: 12:17
Member (2002)
Swedish to English
+ ...
One suggestion Sep 28, 2008

I have never done anything this complex in MultiTerm, but it sounds possible.
However, I think the structure of your current Excel file is not suitable. The names of the languages need to be horizontally in row 1, not vertically in column 1.
The words in each language need to be vertically below each language name.
Then you should be able to process the file in MultiTerm Convert.


Direct link Reply with quote
 

Grzegorz Gryc  Identity Verified
Local time: 13:17
French to Polish
+ ...
Rotate your xls sheet... Sep 28, 2008

Colin lee wrote:

I have a excel file including 2 columns; Column A include languages: ie..

Language
Chinese (PRC)
english
uote]
Multiterm assumes you put the languages ins successive COLUMNS, not lines, i.e.:
Chinese (PRC) - header of the column A
english - header of the column B
etc.

Colunm B include Term:ie..托管
uote]
As above.
The terms should be put in the sucessive LINES.
It's rather logic 'cause in Excel you can have more lines than columns.

das Hosting, das Webhosting
hostování, hosting
uote]
You should never handle synonims in this way.
Don't use the coma because MT will handle these words as ONE term (i.e. not as TWO synonims).
If necessary, add another language column with the same header (in this case, German and Chech).
Then you map these columns twice in the MT Convert wizard.

Now, i want to extract the mated Term, ie..
English Chinese 。。。。 French
hosting 托管 .


Select the table, copy, go to an empty table, click on the A1 cell.
In the Edit menu, select Paste Special.
In the dialog box, check the Transpose box.
Click OK, it should work.

BTW.
Delete the original sheet because the MT Convert Wizard is stupid i.e. it assumes only the first sheet contains data (i.e. if you have multisheet glossaries, only the first sheet is processed).

BTW, the english strings are more than other language, maybe other language are only the part of english Terms.

MT may behave erratically if some languages fields are empty.

Everybody, can we use SDL Multiterm to get a result expected?

Indirectly, yes.

How to handle it ?? any way will be welcome.

HTH

Cheers
GG


Direct link Reply with quote
 

Grzegorz Gryc  Identity Verified
Local time: 13:17
French to Polish
+ ...
Multterm 5? Sep 28, 2008

Colin lee wrote:

I have a excel file including 2 columns; Column A include languages: ie..

Language
Chinese (PRC)
english
Basque
Chinese (Hong Kong)
Indonesian
German
Czech
Norwegian
Finnish
Turkish
Galician
Korean
Estonian
Thai


A moment...
These languages are listed only once (i.e you have your terms in the columns B, C, D etc) or it's cyclic (you have only the B column)?

If your file is cyclic, you should write a concatenation formula in the column C in orther to create a Multiterm text 5 file like this:

============ begin of the example
<Chinese (PRC)>Chinese term
<English>English term
============ end of the example

In the English Excel, the formula is:
=CONCATENATE("<",A1,">,B1)

Paste the C column to a text editor and add two asterisk before the first language of every entry.

============ begin of the example
**
<Chinese (PRC)>Chinese term
<English>English term
============ end of the example

Then import the file using the MT5 schema.

Cheers
GG



[Edited at 2008-09-28 09:14]


Direct link Reply with quote
 


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


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

How to use SDL multiterm to handle this kind of excel?

Advanced search


Translation news related to SDL Trados





PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs