Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All ,
Once again I need help , I got stuck with XML .
So , I have a report where I am using the .xml files to fetch the data & I am getting error for few files mentioned below :
Error: Invalid at the top level of the document.
On line number: 2. On column number: 11.
Pasted below is my XML file code .
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE rrd SYSTEM "http://oss.oetiker.ch/rrdtool/rrdtool.dtd">
<!-- Round Robin Database Dump -->
<rrd>
..................
....................
................
</rrd>
Currently i am using the QV SR 12 version .
Please help .
Thanks,
Valsala
Hi Valsala,
It seems the Qlikview XML parser doesn't accept doctype and other specific types of markups in the xml.
Attached are some files I tested and only the most simple XML was accepted (teste2.xml) using Qlikview 12.
Regards,
Felipe.
Hi Felipe.,
Thanks for the reply.
But can you please elaborate more as i m not able to understand. Is it the doctype which is coming in the xml need to get change.
Also i m not able to find any attachment.
Regards,
Valsala
Hi Valsala,
As I understand by the examples I tested, the Qlik XML parser (as to how Qlik extracts data from the xml files) doesn't support something like this:
Type 1:
<?xml version="1.0"?>
<DOCTYPE rrd SYSTEM "http://oss.oetiker.ch/rrdtool/rrdtool.dtd">
<!-- Round Robin Database Dump -->
<rrd>
<test>aaaa</test>
</rrd>
Probably as it is parsing the strings from the file, it searches for another syntax member (not quite sure about this, just assuming by the examples) and gets the "DOCTYPE rrd system" string not recognizing it and therefore being unable to open the file in the Load assistant in QlikView.
Since this works (without the bold line above).
Type 2:
<?xml version="1.0"?>
<catalog>
<book id="bk112">
<author>Galos, Mike</author>
<title>Visual Studio 7: A Comprehensive Guide</title>
<genre>Computer</genre>
<price>49.95</price>
<publish_date>2001-04-16</publish_date>
<description>Microsoft Visual Studio 7 is explored in depth,
looking at how Visual Basic, Visual C++, C#, and ASP+ are
integrated into a comprehensive development
environment.</description>
</book>
</catalog>
I'm assuming that it's not possible to open more complex types of XML, you would have to treat it somehow, to get the t type 2.
Something like this would work though:
<?xml version="1.0"?>
<!-- Round Robin Database Dump -->
<rrd>
<test>aaaa</test>
</rrd>
Felipe.
Hi Valsala,
were you able to solve this problem?
BR,
Matus