Problem when alligning Excel files (cell to cell).
Thread poster: Ignacio Costa

Ignacio Costa  Identity Verified
Brazil
Local time: 03:49
Member (2016)
English to Portuguese
+ ...
Dec 22, 2015

Hello guys,

Another quick question to the experts! =)

I have such a big file to align. It's in Excel and I already have source and target, side by side.

I just tried to copy the target to another file (with exactly the same number of rows) as I normally do in these cases.

However, at some point the alignment gets totally messed. It has, apparently, no reason for that (the files, as I said, are exactly with the same number of lines, and the target corresponds to the source in every cell).

So, two questions:

1- Would you guys have any idea about what is happening? (i.e., how could I leave this file in a way that it could be automatically aligned with no problems).

2- Is there any way I could simply ask Trados to align all the segments 1 to 1? I know the alignment has the "Connect n:n" option, but then I have to select in the check boxes string by string, and there are thousands of them!

Many thanks guys!

Regards,

Ignacio


 

Dmitry Pakidov
Russian Federation
Local time: 09:49
As an option… Dec 23, 2015

…you can use TMbuilder, which allows to create TMX files out of two-column XLS files, forgoing the need for alignment altogether.

 

Ignacio Costa  Identity Verified
Brazil
Local time: 03:49
Member (2016)
English to Portuguese
+ ...
TOPIC STARTER
Thanks! Dec 23, 2015

Thank you Dmitri!

It seems the tool solved my problem!


 

Walter Blaser  Identity Verified
Switzerland
Local time: 08:49
French to German
+ ...
You don't need to align this kind of files Dec 25, 2015

igaapp wrote:

Hello guys,

I have such a big file to align. It's in Excel and I already have source and target, side by side.


ignacio

If your Excel file contains source and target already in an "aligned" arrangement as you say, there is no need to do an align to get this into Studio.

The easiest way is to open the file using the filetype "Bilingual Excel", tell Studio which column is the source and which one is the target. You will then get both columns in the Editor and can then make corrections if necessary and update your TM by finalising the project.

Very easy, no alignment process needed for this.

Walter


 

Ignacio Costa  Identity Verified
Brazil
Local time: 03:49
Member (2016)
English to Portuguese
+ ...
TOPIC STARTER
Thanks! Dec 25, 2015

Thanks Walter.

Very helpful hint!

Kind regards,

Ignacio


 


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


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

Problem when alligning Excel files (cell to cell).

Advanced search







SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »
WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »



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