topic Re: XML Help in QlikView

XML Help

Mahamed_Qlik — Fri, 22 Jan 2016 12:35:36 GMT

Dear All,

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

Below is the screenshot for your reference :

Kindly advise.

Regards,

Mahamed

robert_mika — Fri, 22 Jan 2016 12:39:53 GMT

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 — Fri, 22 Jan 2016 12:41:58 GMT

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.

jonathandienst — Fri, 22 Jan 2016 12:42:44 GMT

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

simospa — Fri, 22 Jan 2016 12:46:59 GMT

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:

" " ' ' < < > > & &

Let us know.

settu_periasamy — Fri, 22 Jan 2016 12:49:31 GMT

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

Mahamed_Qlik — Fri, 22 Jan 2016 12:50:38 GMT

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

Sorry for the inconvenience caused.