Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with loading the XML .

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

4 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

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.

Anonymous
Not applicable
Author

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

felipedl
Partner - Specialist III
Partner - Specialist III

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.

mkelemen
Creator III
Creator III

Hi Valsala,

were you able to solve this problem?

BR,

  Matus