How to import two column (source and target) word file in SDL?
Thread poster: Akhil Kumar

Akhil Kumar
India
Local time: 23:40
English to Panjabi
+ ...
Dec 11, 2015

Hi friends,

I have a query. Usually client provide us with a word file which is exported from SDL and contains both source and target. I want to import the file into SDL but when I try SDL imports both the columns as Source segment. I want source column in source segment and target columns in target segment so that I can proceed with translation. Is it possible? If yes, how can I do that?

Thanks,
Akhil


 

Andrzej Lejman  Identity Verified
Local time: 20:10
Member (2004)
German to Polish
+ ...
Just Dec 11, 2015

select and hide the source column (Ctrl+Shift+H) and translate the target column. Afterwards unhide the source column (Ctrl+Shift+H).
That's all.


 

Nora Diaz  Identity Verified
Mexico
Local time: 12:10
Member (2002)
English to Spanish
+ ...
You would need the SDLXLIFF Dec 11, 2015

The best thing would be to either get the original Word file or the SDLXLIFF from your client. What you are describing sounds like a file that has been exported for external review, whose purpose is to be reviewed outside of Studio, then imported back into Studio, not to be used as translatable document.

If you must absolutely use the exported file, though, open the file in Word and select the source column, then Ctrl+Shift+H to hide the content of that column, save the file and then open it in Studio. When you're done translating, save your target file, open it in Word, select all with Ctrl+A, then Ctrl+Shift+H again (sometimes twice) to unhide everything.

[Edited at 2015-12-11 16:40 GMT]

[Edited at 2015-12-11 17:45 GMT]


 

Akhil Kumar
India
Local time: 23:40
English to Panjabi
+ ...
TOPIC STARTER
Please elaborate Dec 11, 2015

Andrzej Lejman wrote:

select and hide the source column (Ctrl+Shift+H) and translate the target column. Afterwards unhide the source column (Ctrl+Shift+H).
That's all.


Hi Andrzej,

Thanks for help! But I couldn't understand you point, can you please elaborate?


 

Akhil Kumar
India
Local time: 23:40
English to Panjabi
+ ...
TOPIC STARTER
Select all rows of target segment in SDL Dec 11, 2015

Is it not possible to select all the rows of target segment in Trados as we do in word or excel so that I can paste all the rows of a column(already translated) in target segment of Trados? or is it somehow possible to paste whole column from word or excel file in target segment of Trados? When I tried text of all the rows pasted into one row of target segment of Trados.

 

Nora Diaz  Identity Verified
Mexico
Local time: 12:10
Member (2002)
English to Spanish
+ ...
Not posible to paste several rows separately at once Dec 11, 2015

That can't be done for several rows at a time, you would need to do it one by one, but if your translation memory is being updated as you translate, those segments can be populated as 100% matches automatically by Studio.

[Edited at 2015-12-11 17:47 GMT]


 

Nora Diaz  Identity Verified
Mexico
Local time: 12:10
Member (2002)
English to Spanish
+ ...
In Word, not in Studio Dec 11, 2015

Akhil Kumar wrote:

Andrzej Lejman wrote:

select and hide the source column (Ctrl+Shift+H) and translate the target column. Afterwards unhide the source column (Ctrl+Shift+H).
That's all.


Hi Andrzej,

Thanks for help! But I couldn't understand you point, can you please elaborate?


Andrzej's suggestion is to modify the file in Word before you open it in Studio. So the procedure explained above needs to be done in Word. You do the first part, hiding the source column, then save the Word file and open that file in Studio. After translation you save your target, open it in Word, and then unhide as explained above.


 


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 import two column (source and target) word file in SDL?

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 »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »



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