Studio 2009 - How to overwrite the target column (multiple segments edition)
Thread poster: pcs_MCIL

pcs_MCIL  Identity Verified
English to Italian
+ ...
Jul 7, 2010

I translated an Excel file from Italian to English, then I had to send it off for proofreading to an English mothertongue. The proofreader was sent a file in Excel because she did not used any CAT.

Now I want to implement the changes the proofreader did, so that I can update my TM with her corrections.

I can generate a Trados file simply opening the English Excel file as if I wanted to start a new translation, but then how can I copy the whole English-as-source column and paste it in the previous English-as-translation column? (There is a difference of 80 segments on 2600 among the files, I don't know why)


Thanks,

Paola


Direct link Reply with quote
 

Ade Indarta  Identity Verified
Indonesia
Local time: 18:26
English to Indonesian
Create TM from the proofread xls file Jul 8, 2010

Hi Paola,

Have you tried creating TM from your proofread xls file and apply the TM to your translation?

Regards,
Ade


Direct link Reply with quote
 

pcs_MCIL  Identity Verified
English to Italian
+ ...
TOPIC STARTER
no - but what's the point? Jul 8, 2010

But If I create a TM from the proofread file there is no target!
How can the program relate it to the other file?


Direct link Reply with quote
 

Sergei Tumanov  Identity Verified
Local time: 14:26
English to Russian
+ ...
Align the source and the proofread files Jul 8, 2010

I see no other way but to create a new tm using an align tool.

[Edited at 2010-07-08 13:19 GMT]


Direct link Reply with quote
 

pcs_MCIL  Identity Verified
English to Italian
+ ...
TOPIC STARTER
please explain Jul 8, 2010

I m,a sorry I am not very skilled about Trados, but from what I undesrtand a TM is a file containing bilingual information (e.g. "given that segment in Italian, this is the corresponsing segment in English").

If I create a new TM from the Italian file, it stays EMPTY since there is only Italian text in there, and the English column is empty.

I need to paste the Italian column into the English-to-Italian file, but it seems ctrl-c and ctrl-v does not work.


Direct link Reply with quote
 

Graeme Lorimer  Identity Verified
Local time: 13:26
German to Italian
+ ...
There are several ways Jul 8, 2010

1) Take the original Excel file with the Italian in Column A, take the corrected Excel with the English in column A) and copy the whole column to B.
At this point you have an Excel file with two columns. A) Italian and B) English - Make spot checks to make sure that the segments coincide.
If they don't, revisor did something funny and should fix it.
2) Use save as function of Excel and Save as a TAB delimited TXT file.
3) Import the txt file into a Trados memory defining colum A) as Italian and column B) as English. I suggest you create a new memory just in case something goes wrong.
4) Apply memory to your original translation.

Please note that due to segmentation issues you might have some empty segments, however you can find them easily in memory by searching for portions with the concordance command.
The only thing you have to be sure is that the segments of the newly created memory coincide.
You can also recreate a translation document by eliminating the English column of the new Excel and applying the meory to the Italian.
Of course this method is advisable only if the Excel is quite long and corrections extensive.

Otherwise I suggest make a TXT file with your English translation, and make a TXT file with the corrected English. Use a software tool to compare the two files (Beyond compare or even Word) the tool highlights the changes - manually make the changes in your original tanslation.


Direct link Reply with quote
 

pcs_MCIL  Identity Verified
English to Italian
+ ...
TOPIC STARTER
Here's the solution Jul 10, 2010

I tried to follow Graeme's suggestion but I was not able to import from a *.txt in Trados Studio 2009.

Sergei idea was the correct one, but since I don't have WinAlign I had to use another align tool.
A colleague suggested me http://www.youalign.com, which is free and immediate.

I have uploaded the Italian monolingual *.xls, then the English monolingual *.txt and with YouAlign I was able to get a bilingual *.tmx file.

I opened my project and file in Trados Studio 2009, went in the Translation Memory window, chose "Import" and then selected the bilingual *.tmx.
Then it is sufficient to apply the translation (file > pre-translate) or to work in the Editor window.


Thanks again to everyone!


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 »

Studio 2009 - How to overwrite the target column (multiple segments edition)

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 »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



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