Parsing XML Data

Hi I'm trying to parse an XML File that matches the below sample format:

NON -XML LINE
\NEWLINE
XML TAGS
XML TAGS
...
\NEWLINE
NON-XML LINE

The above format repeats

Sample BELOW:

<?xml version="1.0" encoding="UTF-8"?>
<TAB1 protocol="OCI" xmlns="C">
<sessionId xmlns="">0</sessionId>
<command xsi:type="DeviceManagementFileAuthLocationGetRequest18" xmlns="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<deviceAccessProtocol>Http</deviceAccessProtocol>
<deviceAccessMethod>GET</deviceAccessMethod>
<deviceAccessURI>/System.xml</deviceAccessURI>
</command>
</TAB1>

Tried using XML Tabular Data input and got the following error:

XML data error. There is a problem processing xml data.

XML data error. There is a problem processing XML data line [1] column [1]. Content is not allowed in prolog.

Error code:
Raised on 2016-12-01 at 20:15:51

Java details:
com.lavastorm.brain.node.lal.tabularXml.AbstractTabularXmlFile$TabularXmlErrorHandler
(AbstractTabularXmlFile.java@263)

Any guidance re parsing this XML/Text File is Appreciated.

Stony Smith

December 01, 2016 20:39

It may not be the "best" solution, but what I had to do for such a file was read it in with the Delmited_Input node, use a filter to remove those first 3 records, write it back out with the Delimited_Output node, then read the (temporary) file with TabularXML. Not pretty, but got the job done.

Dwayne Ramsay

December 01, 2016 20:41

Hi Stony,

Thanks. Crossed my mind - just wondered if there was a more elegant way of doing.

Will try the above.

Could you advise under what contact one might use Data Reader node?

Thanks Again.

December 01, 2016 20:53

The DataReader is primarily for use with another Lavastorm product called the Lavastorm Data Reader (LDR) - it was designed mainly to handle high-volume CallDetailRecord files by a telephony operator.

Parsing XML Data

Comments

Didn't find what you were looking for?