.sdlxliff is exporting the source content instead of target content when I try to export the file in the target format (MS Excel). Could you please help me find a solution?

Question

.sdlxliff in question available upon request (cannot attach). When I go to Batch Tasks > Export Files > Target Version > Finish I get an English excel file, when it should be in Spanish. Any thoughts on why this might be happening? It appears to be pulling source content instead of target in the export.

Paul · Accepted Answer

Hi Rachel Messenger , 
 
The problem is that the files was handled with the Bilingual Excel filetype and the source is not a Bilingual Excel file. I recreated the file correctly and pretranslated from your SDLXLIFF and sent it back to you, along with my SDLXLIFF. You'll need to translate more of the file as lot's of it was not extracted as there is also more than one worksheet in the file.

Ana-Maria Matefi · Answer

Hello Rachel Messenger , 
 
I would recommend to verify that all your translated segments are confirmed and the .sdlxliff is saved with CTRL + S. 
 
Then please try to obtain your target document with: File --> Save Target As 
 
Wish you a great day. 
 
Best Regards, 
Ana-Maria Matefi

Paul · Answer

Hi Rachel Messenger , 
 
I have seen something similar with older version of the Excel filetype. What version of Studio are you using and what version of the Excel filetype are you using? 
 
The solution in the past was to locate where the language changed in the sdlxliff and then copy course to target for the paragraph before and after, and including, the affected segment. Sometimes tags that are not exposed to the user (bug in the older versions) don't get carried over correctly during translation so copying source to target for all segments in that location can solve the problem. 
 
Feel free to send me the SDLXLIFF and original source file if you'd like me to take a look? pfilkin@sdl.com

Paul · Answer

Unknown said: It looks like my project settings didn't have me set up to work with the correct version of excel to begin with. My guess is I'll have to redo the order if I want to utilize a bilingual excel file in the specific project settings during project creation. 
 Hi Rachel Messenger perhaps you can consider creating a Project template with the files in a different order. This way if you need to use the Bilingual Excel Filetype you just create your project on the basis of a different template. This might be a lot easier than remembering to change the order in the default template all the time.

Trados Studio > 1. Trados Studio

.sdlxliff is exporting the source content instead of target content when I try to export the file in the target format (MS Excel). Could you please help me find a solution?