How to process a bi-lingual XML file?

Question

Hello community,

I have been given a bi-lingual XML file for revision. The basic structure is like this:

<string language="de">German text</string>

<string language="en">English text</string>

I would like to edit the file in Studio 2016 so that I can update my TM after the final revision. I know how to extract strings in one language (e.g. only the "en" attribute), but how can I "tell" Studio that German (de) is the source language whereas English (en) is the target?

I assume I will have to define a new file type and parsing rules, but I have not be been able to figure out exactly how to do it.

Any pointers will be appreciated!

Paul · Accepted Answer

Hi Bettina, 
 I guess that means you just need to make sure the Bilingual Excel filetype is used when you open the file. Easiest way, if you are using the default templates is just deactivate the default for now: 
 
 Then open the file or create your project. 
 A better solution is to create a new project template that is set up this way in the first place and then when you create your projects just select the new one if you want to work with Bilingual Excel files. 
 Regards 
 Paul

Paul · Answer

Hi Bettina,

There is no bilingual xml capability in Studio. So your options are either to verify this isn't eally xliff disguised as xml in which case you may be able to use the xliff filetype with a small adjustment; or you need to copy the source text into the target segments in the xml file before you start and then translate the file as xml.

This article might be helpful for you:

multifarious.filkin.com/.../

Regards

Paul

Paul Filkin | RWS Group

________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub

Paul · Answer

Hi Bettina, 
 
If your aim is to be able to create a TM then the easiest solution is probably to open the file in Excel. Excel should support the xml conversion and give you different columns for the data. Then you remove all the columns apart from the source and target languages and just drag and drop that file into the Glossary Converter to get your TMX. Then open the TMX in Studio using the TMX filetype on the AppStore. Alternatively use the Excel file you get in Studio with the Bilingual Excel filter. 
 
Does that help maybe? 
 
Regards 
 
Paul

Trados Studio > 5. Regex and XPath

How to process a bi-lingual XML file?