topic Re: Loading XML file in QlikView

Loading XML file

Mon, 30 Jul 2012 09:03:47 GMT

Hi,

When I try to load the xml file using Qlikview, it gives 'Download Error' but I can open the same url in browser.

What could be the reason for download failed error

Re: Loading XML file

Mon, 30 Jul 2012 10:48:10 GMT

Hi,

are you loading that xml file from local file system or via http (https) url?

regards

Re: Loading XML file

Mon, 30 Jul 2012 11:12:52 GMT

Loading the file from https url...

Re: Loading XML file

rajni_batra — Mon, 30 Jul 2012 12:47:05 GMT

When you open that on browser does that ask for any username and password???

Re: Loading XML file

Mon, 30 Jul 2012 13:03:36 GMT

In IE, it is not asking for any credentials. But in Chrome, it is asking for the credentials. After giving the credential I am able to view the xml file.

But qlikview couldn't read the data from the url, it is giving the error - 'The download Failed'

Note: I am trying to fetch the data from share point using REST service

Re: Loading XML file

Tue, 31 Jul 2012 07:31:03 GMT

Can qlikivew fetch the xml file from 'https' site?

Re: Loading XML file

Thu, 14 Feb 2013 10:53:21 GMT

Hi,

I've encountered the same problem.

Did you find any solution for it?

Thanks

Re: Loading XML file

Fri, 17 May 2013 17:43:55 GMT

I'm also receiving the same issue.

I pull the XML file up in my browser (Firefox, IE and Chrome)

The URL has the ID and Password as a plain text string.

When going through the wizard to upload the XML file, I can see my data when the FileType is set to Delimited or Fixed Record.

HOWEVER, when I select the File Type of XML, I receive the following:

Re: Loading XML file

Fri, 17 May 2013 17:53:42 GMT

More info:

If I perform a File/SaveAs from my browser, I can import into QlikView with no problems.......

Re: Loading XML file

Anonymous — Tue, 08 Oct 2013 11:39:37 GMT

I have the same problem.
When I type the URL in the browser the result shows up, but when I use the
wizard in Qlikview pulling from internet file it says: 'The download Failed'. But when I chose delimited I can see the data (as Jason describes earlier).

The same URL works from Qlikview on my local machine.

So I guess there is/are some setting(s) on the server that stops Qlikview from pulling xml from internet files. Anyone have any idea how to solve this problem?

Re: Loading XML file

Anonymous — Tue, 08 Oct 2013 11:59:44 GMT

I found a solution. I changed "https" to "http".

Re: Loading XML file

Anonymous — Wed, 15 Jan 2014 19:40:16 GMT

Jason, have you resolved your issue?

Thanks,

Gene

Re: Loading XML file

Sat, 08 Feb 2014 23:29:45 GMT

Same here, with sharepoint... DUH...

the legacy model works fine (owssvr.dll) but it does not work with TASK LIST so I need an alternative method... yet the _api method seems very troublesom...

Re: Loading XML file

Sat, 08 Feb 2014 23:47:05 GMT

I solved my issue which was caused by URL encoding! I was using this URL:

http://[myserver]/[mysite]/_api/web/lists/getbytitle('وظایف پروژه')/Items

Which I changed to this one:

http://[myserver]/[mysite]/_api/web/lists/getbytitle('%D9%88%D8%B8%D8%A7%DB%8C%D9%81%20%D9%BE%D8%B1%D9%88%DA%98%D9%87')/Items

And it worked like a charm! So I suggest that you try encoding the inner part of the string you are trying to give to API which will save the day for you!

by the way, I already solve some other issues of using SharePoint with QlikView which might help; for example if you have a problem with authentication, you might want to add the URL of the site to INTRANET of TRUSTED areas in INTERNET EXPLORER. Just remember to test everything with IE in authentication issues.

Re: Loading XML file

chrisbrain — Fri, 09 May 2014 07:32:39 GMT

I have seen this issue now with one of our users and they were not even able to open this simple W3Schools hosted file in QlikView:

http://www.w3schools.com/xml/note.xml

If the file is downloaded to disk it is not problem then loading it.

Re: Loading XML file

Wed, 08 Oct 2014 07:39:44 GMT

Hi,

I've got the same problem, I'm trying to load a xml file and it doesn't work.

Do you find an issue to this problem ?

Re: Loading XML file

mjayachandran — Wed, 08 Oct 2014 07:47:13 GMT

Hi can you try something like,

FROM [http://user:password@server/job/jobname/build/xml/note.xml] (XmlSimple, Table is [note]);

have the user:password@ in the URL like the above example..

Re: Loading XML file

DavidFoster1 — Wed, 08 Oct 2014 08:14:48 GMT

That is an incredibly bad idea. You should never include security credentials in a plain text Http request. You should always consider a single-sign-on solution first.

Re: Loading XML file

Wed, 08 Oct 2014 08:30:55 GMT

Thank you for your answers,

It's not my problem, I don't have any login / password on my server.

In QV :

1. if I select XML, I have the message "The download failed"

2. if i select fixed record, I obtain the confirguration (I think) of my XML file

Thanks for your help,

Re: Loading XML file

Mon, 09 Mar 2015 12:59:48 GMT

I have exactly the same problem. Strange thing is, I can run the QVW file on my desktop PC from server share, but not from the server it self.

I also see the xml info in the "Delimiter" type, but get the error "The download of the specified resource has failed" in XML type.

My url is an https on a local host.

Guess there is some security settings on the server, but can't figure out what.