topic Re: Unable to load from qvd that stores data from SharePoint list in QlikView

Unable to load from qvd that stores data from SharePoint list

Wed, 25 Nov 2020 16:16:04 GMT

I have a qvd that stores data from a SharePoint list. On creating a qvw that loads from this qvd, no data is being read. Instead the LOAD returns XML elements with table definition items.

Is there a specific way to Store and Load data in this case?

Below are the steps I am following:

Create a qvw to load data from a SharePoint list using the RPC-calls using owssvr.dll, like:

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

The data is parsed and am able to see it via the Table Viewer screen
Store the data in a qvd
Create another qvw and Load the data from the qvd using - LOAD * FROM filename.qvd
When I preview the data in the Table Viewer screen, instead of the data it shows some XML elements that seem to contain table definition items

Re: Unable to load from qvd that stores data from SharePoint list

vadimtsushko — Thu, 08 Sep 2016 09:52:39 GMT

I think the problem is not in your QVD file, but in your load statement. Apparently you did not include (QVD) modifier in that statement, so data load in some default format (probably as csv)

Try to change your statement to

LOAD * FROM filename.qvd (QVD);

Re: Unable to load from qvd that stores data from SharePoint list

Thu, 08 Sep 2016 16:24:20 GMT

You are absolutely correct Vadim - just adding the (QVD) after the Load is pulling in the data from the file.

Can't thank you enough - this was troubling me for the past week!

Best,

Shuchi