ProZ.com Translation Forums

Convert a XML file | IT WORKED!!!

Kathaline Hotte — Mon, 16 Mar 2015 15:42:00 +0000

Forum: Software applications
Topic: Convert a XML file
Poster: Kathaline Hotte
Post title: IT WORKED!!!

Well noted, thanks Rolf!

Regards
Kathaline

Convert a XML file | Next step on the ladder

Rolf Keller — Mon, 16 Mar 2015 13:06:00 +0000

Forum: Software applications
Topic: Convert a XML file
Poster: Rolf Keller
Post title: Next step on the ladder

[quote]Kathaline Hotte wrote:

I opened the XML file with NotePad to get a proper document [/quote]

Ok. Next time you could try a free editor like "Notepad++" or "XML Notepad" instead of Notepad.

Convert a XML file | IT WORKED!!!

Kathaline Hotte — Sun, 15 Mar 2015 18:07:00 +0000

Forum: Software applications
Topic: Convert a XML file
Poster: Kathaline Hotte
Post title: IT WORKED!!!

Hi Rolf,

Thanks for your message. Actually, I'd like to thank all the people who replied to me, as I could find the solution by mixing all your advise!

Here are the different steps:

- I opened the XML file with NotePad to get a proper document (thanks Rolf!)
- Then, I followed Matthias' procedure in Excel (thanks Matthias!) and all the cell information was correct this time
- I converted this new bilingual Excel document into a CSV file
- I created a new project in Trados from this CSV bilingual file, after updating correctly the type of file section (thanks Claude-Andrew!)

Result: the project has been automatically 100% translated as per the bilingual document - no need to re-type the translation manually - and so my translation memory could finally be updated!

It was a great team work, congratulations! :)

Best regards
Kathaline

Convert a XML file | Search-and-replace in XML

Rolf Keller — Fri, 06 Mar 2015 13:19:00 +0000

Forum: Software applications
Topic: Convert a XML file
Poster: Rolf Keller
Post title: Search-and-replace in XML

[quote]Kathaline Hotte wrote:

... unless you have another solution... [/quote]

XML files are plain text files, they consist of the text snippets plus a lot of Tags in angled brackets. Just open the file using Notepad, you'll see that.

Thus, the stuff can be converted into a better form by search-and-replace. Delete all unnecessary tags, then use the remaining tags as "anchor points" to enter appropriate tabs, returns or the like. This way you can get a simple representation, e. g. CSV, that can be imported by Trados.

I've never done that for Trados, but it should be possible to write a Word macro that performs the search-and-replace automatically, preferably by using Regex expressions.

Convert a XML file | ONLY MANUAL SOLUTION SO FAR...

Kathaline Hotte — Fri, 06 Mar 2015 11:09:00 +0000

Forum: Software applications
Topic: Convert a XML file
Poster: Kathaline Hotte
Post title: ONLY MANUAL SOLUTION SO FAR...

Hi Matthias, Hi Claude,

All the various species of XML are checked in the list of the file types accepted by Trados 2011...

Regarding Matthias' solution, I've managed to open the file in Excel but the source language (English) doesn't appear correctly...('key' format instead of 'value' format)...

Same problem when I create a project in Trados from the XML file: the English segments are wrong (key format). So I guess I will have to re-type all the English segments manually in this project so that they can match my French translation segments (which appear correctly)

... unless you have another solution...

Thank you anyway to you both!

Best regards,
Kathaline

Convert a XML file | Select xml file types first

claude-andrew — Fri, 27 Feb 2015 19:38:00 +0000

Forum: Software applications
Topic: Convert a XML file
Poster: claude-andrew
Post title: Select xml file types first

Go to tools > Options > File types and you'll have a list of all the file types accepted by Trados 2011. Probably the various species of xml aren't checked in your list - just check the file type you want (e.g. All xml) and you should be able to load your xml files.
I've translated dozens of xml files with no problem using Trados Studio 2011.

NB My Trados is in French, I'm guessing what the English names are.

Convert a XML file | Perhaps...

Matthias Brombach — Fri, 27 Feb 2015 18:33:00 +0000

Forum: Software applications
Topic: Convert a XML file
Poster: Matthias Brombach
Post title: Perhaps...

...following method may work:
Try to open the xml file via Excel (start Excel first).
Identify the source and target column, if arranged apart of each other in columns.
Erase all other columns.
Save file in Excel format.
Perform an alignment with Studio and update your TM.
Last step: Tell others here, whether it worked. :-)

But maybe first tell from what Online CAT the xml file was created. Perhaps another colleague may know an easier solution.

Very last step: Do all of us and yourself a favour and raise your rates...

[Bearbeitet am 2015-02-27 18:49 GMT]

Convert a XML file

Kathaline Hotte — Fri, 27 Feb 2015 17:25:00 +0000

Forum: Software applications
Topic: Convert a XML file
Poster: Kathaline Hotte

Hello,

I use SDL Trados Freelance 2011. I've received only a XML file for the translation I've done (done directly in the agency software system) in order to add it into my Translation Memory. But Trados doesn't accept this format. As I usely import TMX files, is there a way to convert this XML file into a TMX file ?
Or, here are the other formats accepted to be imported into my Translation Memory:
XLIFF SDL (.sdlxliff)
TRADOStag (.ttx)
SDL Edit (.itd)

I can't find any conversion solution.

Thank you.
Kathaline