Matching the XML Req and Res

Question

I need advice on the below

Below are the request and response XML's. Request XML contains the words to be translated in the Foriegn language [String attribute inside Texts node] and the response XML contains the translation of these words in English [inside ].

REQUEST XML

    <TranslateArrayRequest>
          <AppId /> 
    <From>ru</From> 
    <Options> 
            <Category xmlns="http://schemas.datacontract.org/2004/07/Microsoft.MT.Web.Service.V2" ></Category> 
            <ContentType xmlns="http://schemas.datacontract.org/2004/07/Microsoft.MT.Web.Service.V2">text/plain</ContentType> 
            <ReservedFlags xmlns="http://schemas.datacontract.org/2004/07/Microsoft.MT.Web.Service.V2" /> 
            <State xmlns="http://schemas.datacontract.org/2004/07/Microsoft.MT.Web.Service.V2" ></State> 
            <Uri xmlns="http://schemas.datacontract.org/2004/07/Microsoft.MT.Web.Service.V2" ></Uri> 
             <User xmlns="http://schemas.datacontract.org/2004/07/Microsoft.MT.Web.Service.V2" ></User> 
        </Options> 
        <Texts> 
        <string xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays">вк азиза и ринат</string> 
        <string xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays">скачать кайда кайдк кайрат нуртас бесплатно</string>
   </Texts> 
    <To>en</To> 
</TranslateArrayRequest>

RESPONSE XML

    <ArrayOfTranslateArrayResponse xmlns="http://schemas.datacontract.org/2004/07/Microsoft.MT.Web.Service.V2" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
        <TranslateArrayResponse>
            <From>ru</From>
            <OriginalTextSentenceLengths xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"><a:int>16</a:int>
            </OriginalTextSentenceLengths>
            <State/>
            <TranslatedText>BK Aziza and Rinat</TranslatedText>
            <TranslatedTextSentenceLengths xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"><a:int>18</a:int>
            </TranslatedTextSentenceLengths>
        </TranslateArrayResponse>
        <TranslateArrayResponse>
            <From>ru</From>
            <OriginalTextSentenceLengths xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"><a:int>43</a:int>  </OriginalTextSentenceLengths>
            <State/>
            <TranslatedText>Kairat kajdk Qaeda nurtas download free</TranslatedText>
            <TranslatedTextSentenceLengths xmlns:a="http://schemas.microsoft.com/2003/10/Serialization/Arrays"><a:int>39</a:int></TranslatedTextSentenceLengths>
        </TranslateArrayResponse
</ArrayOfTranslateArrayResponse>

Answer 1

So there are two ways to relate the translated text to the original text:

1. Length of the original text; and
2. Order in the XML file

Relating by length being the probably unreliable because the probability of translating 2 or more phrases with the same number of characters is relatively significant.

So it comes down to order. I think it is relatively safe to assume that the files were processed and written in the same order. So I'll show you a way to relate the phrases using the order of the XML files.

---

This is relatively simple. We simply iterate through the trees and grab the words in the list. Also, for the translated XML due to its structure, we need to grab the root's namespace:

import re
import xml.etree.ElementTree as ElementTree

def map_translations(origin_file, translate_file):
    origin_tree = ElementTree.parse(origin_file)
    origin_root = origin_tree.getroot()

    origin_text = [string.text for text_elem in origin_root.iter('Texts')
                   for string in text_elem]

    translate_tree = ElementTree.parse(translate_file)
    translate_root = translate_tree.getroot()

    namespace = re.match('{.*}', translate_root.tag).group()


    translate_text = [text.text for text in translate_root.findall(
                          './/{}TranslatedText'.format(namespace))]

    return dict(zip(origin_text, translate_text))


origin_file = 'some_file_path.xml'
translate_file = 'some_other_path.xml'

mapping = map_translations(origin_file, translate_file)

print(mapping)

Update

The above code is applicable for Python 2.7+. In Python 2.6 it changes slightly:

• ElementTree objects do not have an iter function. Instead they have a getiterator function.

  Change the appropriate line above to this:

  origin_text = [string.text for text_elem in origin_root.iter('Texts')
                 for string in text_elem]
  

• XPath syntax is (most likely) not supported. In order to get down to the TranslatedText nodes we need to use the same strategy as we do above:

  Change the appropriate line above to this:

  translate_text = [string.text for text in translate_root.getiterator(
                        '{0}TranslateArrayResponse'.format(namespace))
                        for string in text.getiterator(
                        '{0}TranslatedText'.format(namespace))]