How to use SDL multiterm to handle this kind of excel?
Thread poster: Colin lee
Colin lee
Local time: 16:30
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: 09:30
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: 10:30
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: 10:30
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







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 »
BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »



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