Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahamed_Qlik
Specialist
Specialist

XML Help

Dear All,

While Importing XML file into qlik, I am getting error message on the screen.

Below is the screenshot for your reference :

XMLTest.png

Kindly advise.

Regards,

Mahamed

6 Replies
robert_mika
Master III
Master III

XML is quite funny if it gets about the way is written.

try to look if the file is correctly formatted or post it here

jonathandienst
Partner - Champion III
Partner - Champion III

Does the XML declaration (the first line in the file) contain an encoding attribute?

Its possible the file contains a character which is invalid in that encoding.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jonathandienst
Partner - Champion III
Partner - Champion III

Have you tried reading the file into a program like XML Spy?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
simospa
Partner - Specialist
Partner - Specialist

Hi,

first of all validate your XML, you can search (for example codebeautify).

There are some escape characters that invalidate a XML, not only for QlikView, but in general.

For example: " ' < > & that you can replace with:

" &quot;
' &apos;
< &lt;
> &gt;
& &amp;


Let us know.

S.

settu_periasamy
Master III
Master III

Can you try the below Document working in your QV Desktop?

Generic XML Import

Mahamed_Qlik
Specialist
Specialist
Author

Sorry to say but it was actually excel file and xml data in it.

Sorry for the inconvenience caused.