Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Connection String to Share Point Server

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.

6 Replies
Not applicable

Connection String to Share Point Server

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...

Ian_Crosland
Not applicable

Connection String to Share Point Server

Hi

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}

Not applicable

Connection String to Share Point Server

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

Ian_Crosland
Not applicable

Connection String to Share Point Server

Hi

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.

alexpanjhc
Not applicable

Re: Connection String to Share Point Server

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!

Ian_Crosland
Not applicable

Re: Connection String to Share Point Server

Hi

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.