topic Re: [resolved] Error trying to read an XML file with NameSpaces in Talend Studio

[resolved] Error trying to read an XML file with NameSpaces

Anonymous — Mon, 25 Aug 2014 17:10:12 GMT

I'm trying to use a tFileInputXML component to read an XML file. The XML file contains namespaces which seems to cause errors trying to read the XML. Sample xml below. If I remove the namespaces, I'm able to read the file. Is there something I need to do differently when an XML file contains namespaces?
<?xml version="1.0" encoding="utf-8"?>
<ns0 nRampMessageRequest xmlns:ns0="urn:xxx nRampMessageRequest:v1.0">
<ns0 ourceSystemName>xxx</ns0 ourceSystemName>
<ns0:MessageType>Exchange Rates</ns0:MessageType>
<ns0:MessageTypeVersion>1.0</ns0:MessageTypeVersion>
<ns0 ourceMessageId>abc123</ns0 ourceMessageId>
<ns0 ourceSentDatetime>2014-01-10T05:00:00</ns0 ourceSentDatetime>
<ns0 ayload>
    <ns0:ExchangeRateData xmlns:ns0="">
      <ns0:ExchangeRates>
        <ns0 ate>2012-05-17</ns0 ate>
        <ns0 ellRate>4.670057</ns0 ellRate>
        <ns0:BuyRate>4.670057</ns0:BuyRate>
        <ns0:MeanRate>4.670057</ns0:MeanRate>
        <ns0:Checksum>14.010171</ns0:Checksum>
        <ns0:CurrencyCode>AED</ns0:CurrencyCode>
      </ns0:ExchangeRates>
      <ns0:ExchangeRates>
        <ns0 ate>2012-05-17</ns0 ate>
        <ns0 ellRate>2.275906</ns0 ellRate>
        <ns0:BuyRate>2.275906</ns0:BuyRate>
        <ns0:MeanRate>2.275906</ns0:MeanRate>
        <ns0:Checksum>6.827718</ns0:Checksum>
        <ns0:CurrencyCode>ANG</ns0:CurrencyCode>
      </ns0:ExchangeRates>
    </ns0:ExchangeRateData>
</ns0 ayload>
</ns0 nRampMessageRequest>

Re: [resolved] Error trying to read an XML file with NameSpaces

Anonymous — Tue, 26 Aug 2014 09:17:18 GMT

Hi,
Have you tried option "Ignore the namespaces" in Advanced settings of tfileinputxml?
Best regards
Sabrina

Re: [resolved] Error trying to read an XML file with NameSpaces

Anonymous — Tue, 26 Aug 2014 09:53:28 GMT

I wanted to see if I could get it to work without the "Ignore the namespaces" option. I would think it should work without the option selected. Should it work without the option selected?

Re: [resolved] Error trying to read an XML file with NameSpaces

Anonymous — Tue, 26 Aug 2014 10:28:51 GMT

Hi,
Currently, tFileInputXML can't be used to extract namespace value.
Best regards
Sabrina

Re: [resolved] Error trying to read an XML file with NameSpaces

Anonymous — Tue, 26 Aug 2014 11:21:58 GMT

hi all,
And it seems that your file doesn't respect standard xml namespace.

Error on line 9 of document file:/C:/Users/lraulier/Documents/forum/readNamespace.xml: The value of the attribute "prefix="xmlns",localpart="ns0",rawname="xmlns:ns0"" is invalid. Prefixed namespace bindings may not be empty.

regards
laurent

Re: [resolved] Error trying to read an XML file with NameSpaces

Anonymous — Tue, 26 Aug 2014 11:24:12 GMT

That was just a cut/paste error, the actual xml has a valid namespace, thanks

Re: [resolved] Error trying to read an XML file with NameSpaces

Anonymous — Tue, 26 Aug 2014 11:47:36 GMT

put as resolved if it's ok for you
thanks
regards
laurent

Re: [resolved] Error trying to read an XML file with NameSpaces

Anonymous — Mon, 15 Sep 2014 11:42:22 GMT

Is there any example online with the "Ignore namespaces" option checked?

Re: [resolved] Error trying to read an XML file with NameSpaces

Anonymous — Mon, 15 Sep 2014 11:50:47 GMT

hi,
it's in the doc from talend help ... just a check box :
https://help.talend.com/search/all?query=tFileInputXML&content-lang=en
regards
laurent

Re: [resolved] Error trying to read an XML file with NameSpaces

Anonymous — Mon, 15 Sep 2014 12:01:57 GMT

Thanks for the link but I have already seen it.
The purpose behind asking for an example was that my situation differs a wee bit.
I am reading an XML file using tFileInputXML and then mapping its elements to database columns through tXMLMap component.
Now I am curious to know if in the tXMLMap where I define XML document structure by using "Import from File", do I keep the schema definitions along with their prefixes and also maintain the tag names with the namespace prefixes or do I remove them?