Mobile menu

How to convert a translated dirty file to Excel file
Thread poster: Robin Song
Robin Song  Identity Verified
Local time: 09:24
English to Chinese
+ ...
Dec 24, 2005

Dear All,

Would you give me some information on how to convert an unclean file translated with Trados to an Excel file? Or what software can help me to do so? The Excel worksheet will contain 2 columns, one for source while the other for translation.
Thanks in advance.

Robin Song


Direct link Reply with quote
 
shule  Identity Verified
Local time: 04:24
English to Turkish
+ ...
a suggestion Dec 25, 2005

Download the following macro from TW users yahoo group (You must become a member in order to access files section):

"Two-column printout of Trados translations.zip"

Direct link: http://f2.grp.yahoofs.com/v1/wImuQzhlu9gklgWTtesZodVjHOxeeMcz5KCt3U8GUbyOz-sErDRsc95a7Fn8FWv3WSCURyRT_nD71ZDZstNZkLU6beJhla-Gzg/Macros/Macros%20from%20Users/Two-column%20printout%20of%20Trados%20translations.zip

Read the instructions document carefully. If you do everything right you will have a two column word file with source on the left and target on the right. Then you can copy these columns into you Excel file. Hope it works!



[Edited at 2005-12-25 12:55]


Direct link Reply with quote
 
Robin Song  Identity Verified
Local time: 09:24
English to Chinese
+ ...
TOPIC STARTER
The link is dead Dec 26, 2005

Sule Bulbul wrote:

Download the following macro from TW users yahoo group (You must become a member in order to access files section):

"Two-column printout of Trados translations.zip"

Direct link: http://f2.grp.yahoofs.com/v1/wImuQzhlu9gklgWTtesZodVjHOxeeMcz5KCt3U8GUbyOz-sErDRsc95a7Fn8FWv3WSCURyRT_nD71ZDZstNZkLU6beJhla-Gzg/Macros/Macros%20from%20Users/Two-column%20printout%20of%20Trados%20translations.zip

Read the instructions document carefully. If you do everything right you will have a two column word file with source on the left and target on the right. Then you can copy these columns into you Excel file. Hope it works!



[Edited at 2005-12-25 12:55]


Thanks for your kind suggestion. However, the link you provided is not active. Some friends suggest converting the file to an xls by modifying the tags of the original file.

Happy New Year!


Direct link Reply with quote
 
shule  Identity Verified
Local time: 04:24
English to Turkish
+ ...
It's not dead but... Dec 26, 2005

Hi Robin,

The link is not dead,however you must become a member of the group in order to access this file. Go to: http://groups.yahoo.com/group/TW_users/

and click "Join this group" icon on the right.

Happy new year to you, too.

Robin Song wrote:


Thanks for your kind suggestion. However, the link you provided is not active. Some friends suggest converting the file to an xls by modifying the tags of the original file.

Happy New Year!


Direct link Reply with quote
 

Francis Kastalski  Identity Verified
Local time: 22:24
Member (2010)
English to Portuguese
+ ...
If you have not already found a solution Dec 27, 2005

Hello Robin,

Please let me know if you have already solved your issue.
If not, please, emailme: fkastalski@yahoo.com.br.
cheers!

Francis


Direct link Reply with quote
 
Robin Song  Identity Verified
Local time: 09:24
English to Chinese
+ ...
TOPIC STARTER
It converts but... Dec 27, 2005

Hi Sule,

Eventually I downloaded the macro package consisting of 6 macros. When I run one of them, a two-column form really appeared. But the contents in the two columns are the same, both of them contain the uncleaned texts. The format I want is Source-Target. Had you tried these macros before? Anyway, I'd appreciate your great help.


Direct link Reply with quote
 
shule  Identity Verified
Local time: 04:24
English to Turkish
+ ...
Just some more suggestions... Dec 27, 2005

Hi again,

You only have to run the first macro; the others must be called upon by each other in turn. You must also be sure that you have all source text in the Trados default blue colour; the target text likewise in the default green/dark green colour. Use the default setting in Workbench (Options > Translated Text Colours; the Suggestion button)as decribed in the instruction file. That's crucial and I think this might be the solution to your case. If not, please try asking in the TW users forum, the writer of the macro may help you more.

Best wishes,

Sule


Direct link Reply with quote
 
Robin Song  Identity Verified
Local time: 09:24
English to Chinese
+ ...
TOPIC STARTER
It works Dec 28, 2005

Hello Sule,

I changed the color setting and it works.
The only weakpoint to this solution is that the generated form lists the translation by hard returns (paragraphs) instead of segments. You know, we list the translations to help proofreading.

Thanks a mil for your help and useful information.

Thanks for Francis' attention. I will share with you when I get another solution to this issue.


Direct link Reply with quote
 
shule  Identity Verified
Local time: 04:24
English to Turkish
+ ...
Glad to hear... Dec 28, 2005

that it has worked at last, though partially:) You can still try asking at TW users forum at yahoo if all the re-shaping will cause you a great burden. There might be some other adjustments to be made in order to get the segments listed instead of whole paragraphs. You may also try replacing the tags with "tags and paragraph marks" if the paragraph marks are what the macro uses to identify cells when converting into tables. Or, try merging the cells and redividing them with the correct number of cells. But be sure to have a nice copy of your file first, these are merely suggestions:)

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 convert a translated dirty file to Excel file

Advanced search


Translation news related to SDL Trados





CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »
PDF Translation - the Easy Way
TransPDF converts your PDFs to XLIFF ready for professional translation.

TransPDF converts your PDFs to XLIFF ready for professional translation. It also puts your translations back into the PDF to make new PDFs. Quicker and more accurate than hand-editing PDF. Includes free use of Infix PDF Editor with your translated PDFs.

More info »



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