Mobile menu

specifying fields for translation in Excel document
Thread poster: Lynda Tharratt

Lynda Tharratt  Identity Verified
Local time: 06:00
Member (2006)
Spanish to English
+ ...
Feb 25, 2007

Hi, I have Trados Freelance 2006 and I'm not really sure yet what I'm doing. I have to translate an Excel file so from the help pages I have determined that I have to do this with Tag Editor. However, the client only wants information under certain headings translated so I don't know how to go about knowing which data belongs below which heading unless I open the original document in another window. Can anybody please help? I've searched all the tutorials, online questions etc. and I guess this question is just to simple to be mentioned ánd I'm just an idiot!

Direct link Reply with quote
 

Jan Sundström  Identity Verified
Sweden
Local time: 11:00
English to Swedish
+ ...
Use filter settings Feb 26, 2007

Lynda Tharratt wrote:

Hi, I have Trados Freelance 2006 and I'm not really sure yet what I'm doing. I have to translate an Excel file so from the help pages I have determined that I have to do this with Tag Editor. However, the client only wants information under certain headings translated so I don't know how to go about knowing which data belongs below which heading unless I open the original document in another window. Can anybody please help? I've searched all the tutorials, online questions etc. and I guess this question is just to simple to be mentioned ánd I'm just an idiot!


Hi Lynda,

If the columns are consistent (ie all content in one column should be translated, another contains no translatable segments), you can use the SDL Filter Settings from the Start Menu.

Just hide the non-translatable segments in Excel first, uncheck the filter (Translate content from hidden columns) before opening Trados.
Afterwards, go back to Excel and unhide all columns again. Done!

I agree that the documentation is very sketchy on all the filter capabilities. They are very powerful, but most users tend to miss them.

/Jan


Direct link Reply with quote
 

Jabberwock  Identity Verified
Poland
Local time: 11:00
Member (2004)
English to Polish
Hide it... Feb 26, 2007

I don't think it is a stupid question, as I've asked it myself

http://www.proz.com/topic/48701

The answer is that you can hide text in Excel, which is then excluded from translation in TagEditor (provided you have set the proper option with TradosFilterSettings).


Direct link Reply with quote
 

Doron Greenspan MITI  Identity Verified
Israel
Local time: 13:00
Member (2005)
English to Hebrew
+ ...
Another approach Feb 26, 2007

When you work with Trados, sometimes you do get the (wrong) feeling you're an idiot... Happened to all of us.

A simpler approach would be to copy only those columns that need translating onto a fresh Excel document, and then translate them with TagEditor.

Once finished, you run the Save as Target command in TagEditor, open the translated Excel file, and copy the translated columns back into the original document.
You MUST then check that they're well-aligned with the existing columns.

Don't forget to have a backup copy of the original doc for emergencies...

Good luck, Doron


Direct link Reply with quote
 

Lynda Tharratt  Identity Verified
Local time: 06:00
Member (2006)
Spanish to English
+ ...
TOPIC STARTER
thanks... Feb 26, 2007

Thanks so much everybody. You've been a big help. I will try your suggestions. Hope everyone's having a better day than I am, I sent the completed translation but when it loads fully the fields turn back to French. Now I have to fix this!

Direct link Reply with quote
 

Zita Petrán
Local time: 11:00
German to Hungarian
I would like rather to hide as to delete Mar 20, 2007

Hi, all!

Doron Greenspan wrote:
A simpler approach would be to copy only those columns that need translating onto a fresh Excel document, and then translate them with TagEditor.
ou MUST then check that they're well-aligned with the existing columns.[/quote]

Good Idea, but I'm really afraid to lose or to add several lines by chance during the translation process, so I wouldn't try it, just to cut out and than copy the translated columns back into the original document.

However, I can't find the pane for the other solution, where you can mark hidden columns as non-translatable in Trados. On the two panes for "Project and Filter Settings" I can only find "New", "Approved" and "Read Only" as capable status to choose.

My question is: Where can I set in Trados, not to translate hidden Excel-columns?

Best regards
Zita


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 »

specifying fields for translation in Excel document

Advanced search


Translation news related to SDL Trados





LSP.expert
You’re a freelance translator? LSP.expert helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

More info »
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 »



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