Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading XML file

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

35 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Does the service account have access to the server share?

Not applicable
Author

The file is on the Publisher server, so it does not need to use the share. I only use the share to Access the file from my PC.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

So whenever you move your document from your Desktop PC to the Publisher machine, you change the UNC path of the XML file, right?

Not applicable
Author

No, I don't move the file or change the file. I use the same file both on the server directly, and through a share from my PC. From my PC, I can see the XML output, but not when accessing in from the server.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

I mean your QVW document. The XML file doesn't need to move or change, it just has to be accessible from a QVW document on your PC AND from a (probably identical) QVW document on your server.

The second one doesn't work. The XML proves to be inaccessible for a QVW document on the server, right? Therefor my question: do you change the path to the XML file in your Server-QVW Load script? If you do not, you're still trying to get to the file via a windows share...

Not applicable
Author

The xml file is a https request to our internal jira site, and is not a file. The url request is not changed.

Den 10. mars 2015 kl. 14:49 skrev "Peter Cammaert" <qcwebmaster@qlikview.com<mailto:qcwebmaster@qlikview.com>>:

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Sorry, my bad. I misinterpreted your statements "...I can run the QVW file on my desktop PC from server share, but not from the server it self..." and "...I only use the share to Access the file from my PC." thinking that the server share had an XML file that couldn't be read from the server.

So apparently it's an access denied issue. Did you try to open the https link from a browser session on the server, using the service account?

buzzy996
Master II
Master II

hi,

pls follow these steps:

Reading Data from Sharepoint lists into QlikView

Using RPC-Calls

An easier way is to use RPC-calls using owssvr.dll, like:

http://your-sharepoint-server/site/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List=listGUI...

listGUID and viewGUID must be in the format {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}.


The listGUID can easily be found by navigating to the list in Sharepoint and go to List Settings. The listGUID will then show up in the address-field in your browser.

If viewGUID is omitted, the default view will be retrieved. To find the viewGUID locate the list in Sharepoint and activate the view needed. Select View Soure in IE to see the source code. Search for view={ to locate the viewGUID.

The response will be in XML, so when reading into QlikView make sure you select XML Files and Internet File. Add the correct crafted URL as described above. The data retrieved can be found in the node xml/data/row.

Example URLs to be used in QlikView:

http://your-sharepoint-server/site/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={B9C20FC4-4C04-4F4C-93EF-E69E11D286F2}

http://your-sharepoint-server/site/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={B9C20FC4-4C04-4F4C-93EF-E69E11D286F2}&View={58678A30-DC12-4C66-8568-28E4D9A3EED1}

For more info about owssvr.dll use Google to find various ways of filtering the information

Note: Only fields defined in a view can be retrieved. You need to construct the view with the fields needed, if not using the default view.

Not applicable
Author

Yes, I can access the url with IE with the service accout user.

Since I get a result in the 'delimiter' type option, but not in the 'xml' type option, I belive there is a security issue on the server, parsing the xml request. Don't know if MSXML is used by QW, and if so, there are some settings there.

Den 10. mars 2015 kl. 15:14 skrev "Peter Cammaert" <qcwebmaster@qlikview.com<mailto:qcwebmaster@qlikview.com>>:

blednyi
Partner - Contributor II
Partner - Contributor II

Check IE properties (Internet options) and in the Advanced -tab:

Do not save encrypted pages to disk , it should be untapped...

It works to me in two different environments.