topic Re: Issue loading from Sharepoint in QlikView

Issue loading from Sharepoint

cbushey1 — Thu, 28 Sep 2017 19:03:31 GMT

Has anyone else experienced this when trying to load data from a sharepoint site?

One user sees (notice the field names):

While a different user see this (note field names are missing):

Both using the same link and using the web file wizard.

Ideas?

Sharepoint permissions are the same for both users.

Re: Issue loading from Sharepoint

krishnacbe — Fri, 29 Sep 2017 14:43:37 GMT

I could see both the Qlikview Versions are also different.

Did the second user able to see @14 & @15 columns in SharePoint?

Re: Issue loading from Sharepoint

cbushey1 — Fri, 29 Sep 2017 14:47:09 GMT

Yes I believe the versions are different but I might be able to rule that as being the issue.

No the 2nd user couldnt see @14 or @15.

We have tried changing permissions in sharepoint but that didnt help.

Re: Issue loading from Sharepoint

krishnacbe — Fri, 29 Sep 2017 14:50:17 GMT

If the user is unable to view the columns in SharePoint itself then you need to fix the issue in SharePoint. If he/she is able to view in SharePoint hopefully there wont be any issue to get it in Qlikview.

Re: Issue loading from Sharepoint

cbushey1 — Fri, 29 Sep 2017 15:27:49 GMT

The user has full control over the document so it doesn't appear to be a permission thing.

Re: Issue loading from Sharepoint

krishnacbe — Fri, 29 Sep 2017 16:02:23 GMT

If it is a document, can you try download it in your local machine and load. Just to test, it is in local whether the user is able to view all the columns.

Re: Issue loading from Sharepoint

Bill_Britt — Mon, 09 Oct 2017 13:11:51 GMT

HI,

Try adding

WebFileUserAgent="curl/7.51.0"

to the settings.ini file.

Bill

Re: Issue loading from Sharepoint

cbushey1 — Mon, 09 Oct 2017 13:37:26 GMT

Hi Bill,

Where is this file located?

Re: Issue loading from Sharepoint

Bill_Britt — Mon, 09 Oct 2017 15:26:51 GMT

For the user it would

C:\Users\username\AppData\Roaming\QlikTech\QlikView

QDS

C:\Windows\System32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch

Bill

Re: Issue loading from Sharepoint

diegoberriel — Thu, 16 Nov 2017 15:48:14 GMT

Hi All,

We are having the same issue with QV 12.10 and Sharepoint 2013... I have tried the recommendation from Bill without success, locally QV overwrites the .ini file and remove the WebFileUserAgent="curl/7.51.0".

Do have find any possible solution on this?

Thks!

Diego

Re: Issue loading from Sharepoint

diegoberriel — Fri, 17 Nov 2017 12:19:45 GMT

Hi All,

Finally the solution provided by Bill is working . We have set before the value "WebFileUserAgent="curl/7.51.0"" previously on one section of the setting files that is override every time that QV is open. Now is set at the beginning of the file and works perfectly!

Thanks Bill!!!

Re: Issue loading from Sharepoint

RashmiD — Mon, 19 Nov 2018 14:42:35 GMT

I am facing similar issue,link below

https://community.qlik.com/t5/New-to-QlikView/QV12-Error-Unknown-error-in-xlsx-file/m-p/1508688/highlight/false#M365081

Re: Issue loading from Sharepoint

Amogh — Fri, 31 May 2019 10:59:49 GMT

Hi Bill ,

We were facing same issue in qlikview 12 after upgrade after applying this sol. in single node that worked.

Can you please suggest in distributed environment does this needs to be applied in every node or primary one.

Thanks.

Re: Issue loading from Sharepoint

sjarugum — Fri, 10 Apr 2020 20:36:45 GMT

Hi,

I have added the line WebFileUserAgent=curl/7.51.0 as the second line in settings.ini file after the line [Settings 7].

Still i am unable to load the data from SP 2013 list.

Error: Unknown LOAD statment error

Qlik version 12.20.20700.0 on Windows 10.

I can confirm that It was working with the same QV version on Windows 7.

Any help is highly appreciated.

Thanks, Sat