topic Re: Store to Sharepoint Folder in QlikView

Store to Sharepoint Folder

lbunnell — Fri, 03 Jan 2014 21:02:39 GMT

How could I store a qlikview file in csv format to a Sharepoint folder?

Re: Store to Sharepoint Folder

Siva_Sankar — Mon, 06 Jan 2014 07:51:50 GMT

Hi,

You want to store .QVD file into .Csv file? Can you explain your requirement

Regards.

Siva

Re: Store to Sharepoint Folder

lbunnell — Mon, 06 Jan 2014 14:58:36 GMT

Yes, the results of a qvd file into .csv or .txt file, but really need to understand how to save it to Sharepoint site. Trying the path like this didn't seem to work

I tried

STORE $(_qvd_name) INTO [http://teamsites.sitename.com/sites/xx/Shared%20Documents/Forms/AllItems.aspx?RootFolder=%2fsites%2fQA%2fShared%20Documents%2fFOLDERNAME&Folder/$(_qvd_name).txt] (txt);

And decoded…

STORE $(_qvd_name) INTO http://teamsites.sitename.com/sites/xx/Shared Documents/Forms/AllItems.aspx?RootFolder=/sites/xx/Shared Documents/FOLDERNAME&Folder/$(_qvd_name).txt] (txt);

and also tried

STORE $(_qvd_name) into [\\teamsites.sitename.com\sites\xx\Shared Documents\FOLDERNAME\$(_qvd_name).txt] (txt);

Re: Store to Sharepoint Folder

john_novello — Mon, 06 Jan 2014 15:52:09 GMT

Are there any security restrictions or user profile restrictions on the SharePoint site?

Re: Store to Sharepoint Folder

lbunnell — Mon, 06 Jan 2014 17:41:20 GMT

Yes, I've added the Qlikview process IDs with Full Control to the Sharepoint site.

Re: Store to Sharepoint Folder

Clever_Anjos — Mon, 06 Jan 2014 17:49:03 GMT

Not using http protocol, but using network access should work fine with right permissions set

This statement should work, it returns any errors?

STORE $(_qvd_name) into [\\teamsites.sitename.com\sites\xx\Shared Documents\FOLDERNAME\$(_qvd_name).txt] (txt);

Re: Store to Sharepoint Folder

lbunnell — Mon, 06 Jan 2014 18:17:52 GMT

Just says 'Execution of script failed. Reload old data?'

Re: Store to Sharepoint Folder

Clever_Anjos — Mon, 06 Jan 2014 18:31:37 GMT

1) Debug your script and get the content of _qvd_name variable

2) Check if QlikView has writing rights into \\teamsites.sitename.com\sites\xx\Shared Documents\FOLDERNAME

Re: Store to Sharepoint Folder

lbunnell — Mon, 06 Jan 2014 19:54:39 GMT

Those appear to be correct in debug mode

STORE filename into '[
teamsites.sitename.com\sites\xx\Shared Documents\xx\filename_QA.txt]' (txt)

But I still get the error message at the end

Re: Store to Sharepoint Folder

Clever_Anjos — Mon, 06 Jan 2014 20:07:50 GMT

"\\" shouldn´t be there?

Re: Store to Sharepoint Folder

lbunnell — Mon, 06 Jan 2014 20:14:27 GMT

Good thought, but that didn’t work either. I’ve added the process id’s to the actual folder permissions as well, but since I’m not getting any useable error message, it’s difficult to understand what’s preventing it from working.

Re: Store to Sharepoint Folder

Clever_Anjos — Tue, 07 Jan 2014 14:40:19 GMT

Using Windows Explorer logged as same user from QlikView Server can you copy a file to that path?

Re: Store to Sharepoint Folder

lbunnell — Wed, 08 Jan 2014 16:16:30 GMT

No, it appears I am unable to access the path from the QlikView server using windows explorer. I can access it from Internet Explorer.

Re: Store to Sharepoint Folder

Clever_Anjos — Wed, 08 Jan 2014 16:18:37 GMT

You should have rights to access it from windows explorer in order to permit QlikView store your files there

Re: Store to Sharepoint Folder

Clever_Anjos — Wed, 08 Jan 2014 16:19:23 GMT

Another solution is store the file into a temp directory and call "ftp" from comand line in order to transfer your file to the server

Re: Store to Sharepoint Folder

lbunnell — Wed, 08 Jan 2014 16:27:58 GMT

That points me in the right direction. I’ll contact the server admin and see if there’s something that can be done at the server level.

Thanks!

Re: Store to Sharepoint Folder

Clever_Anjos — Wed, 08 Jan 2014 16:30:58 GMT

Keep us updated to your situation, friend

Re: Store to Sharepoint Folder

lbunnell — Fri, 24 Jan 2014 14:44:24 GMT

So what we ended up finding out is that there was an issue with the QlikView server being unable to bypass the firewall on the Sharepoint server. We created an SSIS job to export the Sharepoint data file in xml format to a shared drive and let QlikView grab the data from there instead. No change to the code was necessary, just the path to the data.

Re: Store to Sharepoint Folder

Clever_Anjos — Fri, 24 Jan 2014 14:54:38 GMT

That´s nice

Thank you for the information

Re: Store to Sharepoint Folder

Clever_Anjos — Fri, 24 Jan 2014 15:23:18 GMT

Lawrence Bunnell, maybe you would like to mark this issue as answered.

Best regards