topic Re: Share point question in QlikView

Share point question

alexpanjhc — Tue, 25 Sep 2012 22:16:12 GMT

I searched a few discussion but I am still not able to get how it works.

Where do you put the connection string on the script?

I was reading one post from Ian Crosland

he said :

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

I am not familiar with sharepoint's architecture, is the part below universal? when I tried to use this in the script, but how to i use (XmlSimple, Table is [xml/Schema/ElementType/AttributeType]); in my script?

http://vm-sharepoint/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={

where do you see the step 2: Modify this View?

TIA

Re: Share point question

alexpanjhc — Thu, 27 Sep 2012 19:46:43 GMT

OK I finally get it connected.

here are the steps:

go to the sharepoint page that you want to grab the information from.

I used Firefox so that i can see the view page source, there i found my GUID after the first List=

I then construct the url close to the above. I am still not sure how the dll is placed in the sharepoint infrastructure.

but it seems that you can just use it after the directory.

Try the URL out in your browser, you will see the codes if they are valid, if not you either do not have access or you did something wrong.

open Qlikview scriptor, and click the web file, put the url in the internet file. then choose xml, you are good to go.

Re: Share point question

Mon, 22 Oct 2012 13:20:01 GMT

Hello - what QV version do you use??

Works fine for me in QV9 but fails with with QV11 ><,

Syntax error, missing/misplaced FROM:AttributeType... anyone having the same??

Re: Share point question

alexpanjhc — Mon, 22 Oct 2012 13:25:01 GMT

I do not think it has anything to do with your sharepoint, it is the ';' you are missing before the attribute type?

Re: Share point question

Wed, 06 Aug 2014 17:44:19 GMT

I see the same error. Were you able to get it resolved. If so, how?

Syntax error, missing/misplaced FROM: Attribute Type: