• State Verified Answer
  • Replies 6 replies
  • Answers 2 answers
  • Subscribers 123 subscribers
  • Views 5072 views
  • Users 0 members are here
Options
Related

How to process a bi-lingual XML file?

Bettina Koch

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!
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents Reply Children
  • 0 in reply to Paul Filkin
    Hi Paul,

    Thanks for the quick reply. I am positive that the file is not a xliff in disguise. The file was created by a software engineer as an XML file.

    While the link you posted contains quite some helpful hints for other issues I have encountered in the past, I am not sure how it may help me with this particular file. I apologise if my initial request was not clear. The file I am dealing with contains roughly 1,000 strings in both German and English which need to be revised.

    <string language="de">Bildschirm</string>

    <string language="en">Display</string>


    For the sake of consistency, I would like to edit the file in Studio and create a TM from it.

    The only solution I can think of at the moment is to extract the German strings to one file and the English strings to another file and then to perform an aligment, but I am still hoping for a less cumbersome solution.
  • 0 in reply to Bettina Koch
    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

    Paul Filkin | RWS

    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

  • 0 in reply to Paul Filkin
    Thanks again, Paul! I have managed to create an Excel file with one column for DE and one column for EN. If I now try to open this file in Studio, selecting the "Bilingual Excel File" option, Studio still uses the default Excel file type to process it. So I end up with an sdlxliff file that has both German and English text in the source column while the target column is empty. What am I missing?
  • 0 in reply to Bettina Koch

    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 Filkin | RWS

    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

  • 0 in reply to Paul Filkin
    Thank you so much Paul! I created a new template and it worked a treat.