topic Connection String to Share Point Server in QlikView

Connection String to Share Point Server

Wed, 29 Sep 2010 19:45:46 GMT

Hello,

I am trying to do a simple connection to one of our share point servers. Our server account has admin rights to the site, but when i try to do a connection using the web files button (enter the url in the internet file field) there is no data in the wizard and the load all statement fails. I have also tried to enter this url in the Table Files/File name field (thinking this might work) and it tells me path does not exist. I have accessed this URL using internet explorer from the server, so i know it has the correct security. Thanks for any help.

Connection String to Share Point Server

Tue, 09 Nov 2010 17:44:45 GMT

Hello Again,

I am still having issues with the above. Has anyone seen this problem? I dont understand. I can access the spread sheet through the IE browser on the server, but when i try to access the same spread sheet using the same URL through the QV connection string, it says it says the path doesnt exists. Thanks again...

Connection String to Share Point Server

Ian_Crosland — Sat, 13 Nov 2010 16:22:51 GMT

If you are trying to access sharepoint spreadsheets within a list the URL should look like the following

(File type xml from the web files)

FROM [http://vm-sharepoint/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={625801CC-11E6-40E9-9C25-AD198E2BAF21}] (XmlSimple, Table is [xml/Schema/ElementType/AttributeType]);

Access the list via your browser and select the View you want to find the GUID.

2. Select "Modify this View" and copy the URL.

3 You will get a URL like this,

http://vm-sharepoint/_layouts/listedit.aspx?List=%7B625801CC%2D11E6%2D40E9%2D9C25%2DAD198E2BAF21%7D

There you can find,

List=%7B5C65CB1A%2D2E1B%2D488A%2DAC07%2DB115CD0FC647%7D

Replace "%7B" with "{"
Replace all "%2D" with "-"
Replace "%7D" with "}"

You are now left with the GUIDs, in the above example;

List ID is {625801CC-11E6-40E9-9C25-AD198E2BAF21}

Connection String to Share Point Server

Mon, 15 Nov 2010 19:01:04 GMT

Ian,

Thanks for the feedback. My URL doesnt contain the information you listed above. Mine contains %20. I know these are spaces and i have tried replacing them with spaces and it doesnt work. I get an error message after i select the file type XML that says " An Invalid Character was found in text content. On line 1 column 3. I then open the SS and there is only text in this column/line. Not sure what is causing this issue. Any other suggestions? Thanks again for the help.

http://XXX/XXX/XXX/XXX%20Documents/B%20-%20Lean6Sigma%20Return%20on%20Investment/Global%20ROIV1.xlsx

Connection String to Share Point Server

Ian_Crosland — Sat, 20 Nov 2010 17:00:45 GMT

The URL you posted is the default view you will see when looking at the list within sharepoint, you will need to navigate to the URL containing the GUID which is not overtly displayed and then use this to construct a new URL for QlikView.

Finding the GUID differs between sharepoint versions,The listGUID can 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.

Re: Connection String to Share Point Server

alexpanjhc — Wed, 26 Sep 2012 16:52:15 GMT

Hi Ian

I am still confused with how did u get the script?

(File type xml from the web files)

FROM [http://vm-sharepoint/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={625801CC-11E6-40E9-9C25-AD198E2BAF21}] (XmlSimple, Table is [xml/Schema/ElementType/AttributeType]);

did you choose any opton from the picture to get the above script?

and where is modify and view?

thanks!

Re: Connection String to Share Point Server

Ian_Crosland — Mon, 01 Oct 2012 12:18:30 GMT

You need to select web Files and file type xml from the QlikView wizard, modify and view are options within Sharepoint to find the GUID required, also finding the GUID differs between sharepoint versions,The listGUID can 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.