topic Re: Sharepoint connection issue in QlikView

Sharepoint connection issue

chematos — Mon, 13 Aug 2012 19:50:26 GMT

Hi, I´m using this example to try to connect with sharepoint:

" 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}"

I´m using this URL and is not working:

http://our-server.com/Dpto/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}

If I put the URL in the browser, the xml file is downloaded, but using the same in QlikView returns a syntax error and if I use the same but without "Dpto",

http://our-server.com/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX},

it returns to me " The object was not found"

This is the URL looks like when I´m seeing the lists:

https://sharepoint-server.com/Dpto/Lists/SOMETHING/Allitemsg.aspx

Thank you for your help.

Regards, Chema.

Re: Sharepoint connection issue

Anonymous — Mon, 13 Aug 2012 20:31:49 GMT

Perhaps this helps:

http://community.qlik.com/message/242749#242749

Regards

Norbert

Re: Sharepoint connection issue

chematos — Mon, 13 Aug 2012 20:34:25 GMT

I have already seen that thread, I´m following all steps from this doc:

http://community.qlik.com/docs/DOC-1308

Re: Sharepoint connection issue

mls — Wed, 15 Aug 2012 12:46:46 GMT

We have had reports of something similar happening in the early version of QlikView 10 SR5 but in the updated SR5 it is working (build 10.00.9519).
So possibly the problem is version related.

Re: Sharepoint connection issue

chematos — Wed, 15 Aug 2012 12:50:57 GMT

Thank's mls, we will check it out.

Re: Sharepoint connection issue

chematos — Mon, 27 Aug 2012 18:50:13 GMT

We are using SR1 11.0.11282.0

I have no clues what´s happening and what to do

Re: Sharepoint connection issue

mls — Tue, 28 Aug 2012 08:59:18 GMT

I have done a quick test in your version and I too get a syntax error when importing from a Sharepoint list. The same list works in version 10 SR5, so it would seem to be a bug in v11 SR1.

You may be able to workaround it by extracting the list in 10SR5 and saving the result as a QVD which you can then read into v11.

I would suggest reporting this as a support case so that it can be looked into a bit more.

Re: Sharepoint connection issue

chematos — Tue, 28 Aug 2012 12:14:42 GMT

Thank you Magnus, it would be to know what versions have problems with this and what versions didn´t.

Regards

Re: Sharepoint connection issue

chematos — Tue, 28 Aug 2012 14:10:06 GMT

The problem would be with Desktop or Server??

I've tried changing the Desktop to SR5 Qv 10 as you said and now I´m getting this error message: "The download failed"

In v11 returns: incorrect syntax was used in a comment

Re: Sharepoint connection issue

mls — Wed, 29 Aug 2012 08:08:14 GMT

I tried it in both Desktop & Server which showed the same behavior

In my tests it worked with 10 SR5, and the new error sounds more like a failure connecting to Sharepoint, can you double check if you can download the list from a browser on the same machine as you are getting this issue?

Re: Sharepoint connection issue

chematos — Wed, 29 Aug 2012 12:51:10 GMT

https://sharepoint-server.com/DEPTO/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}

I´m using this syntax and I´m getting the xml from the browser but in Qv 10 I´m still getting "Dowload failed"

Re: Sharepoint connection issue

chematos — Wed, 29 Aug 2012 14:31:02 GMT

I could get the list! I needed to use this sequence:

1.- File -> Open URL (using the same URL, QV bring me the login page of my sharepoint)

2.- Logging in sharepoint

3.- Follow the steps in the script normally

So my next question is:

Is there a way to use the login embedded in the URL to use only the script section and not to do the first two steps??

Re: Sharepoint connection issue

Mon, 22 Oct 2012 13:22:58 GMT

RPC call works for me in QV9 but same doc doesn't reload in QV11(SP2) getting this error message:

grrrrrr

Re: Sharepoint connection issue

chematos — Mon, 22 Oct 2012 15:24:41 GMT

Yes, it happens becasuse of the format of the fileds... this symbol I think is te problem '/'

I had the same problem but I didn´t need that fields so I just supressed them but I don´t know how to resolve because I couldn´t change the names of the fields... sorry.

good luck, tell me if you resolve this please

Regards

Re: Sharepoint connection issue

Qvmaster2019 — Tue, 19 Mar 2013 15:19:09 GMT

I am still receiving error when reloading in QMC. Using desktop, it's working just fine,

Error: Incorrect syntax was used in a comment.

3/19/2013 11:14:45 AM: On line number: 2. On column number: 45. System ID: https://vey.sharepoint.com/sites/DonCamTestSharepoint/Qlikview_Notes/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=0&RowLimit=0&List=ec325c26%2Dac52%2D4ea3%2Db259%2D9da623c9ff04&View=%7bEFAD1AFD-82E7-484E-9607-7923CDAA635F%7d.

3/19/2013 11:14:45 AM: General Script Error

3/19/2013 11:14:45 AM: Execution Failed

3/19/2013 11:14:45 AM: Execution finished.

Any idea?

Re: Sharepoint connection issue

Qvmaster2019 — Tue, 19 Mar 2013 15:20:15 GMT

Hi Jose,

On my end, i think the reload stops here, it seems it is considering // as a comment. I haven't solved this yet.

Any thoughts?

FROM [https://

Re: Sharepoint connection issue

Anonymous — Thu, 13 Jun 2013 15:31:43 GMT

Hi,

How can we do that when reloading from QlikView Distribution Services ? (Step 1. Open URL Action)

Regards, Adrien