Store to Sharepoint Folder

[lbunnell]

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

[Siva_Sankar]

Hi,

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

Regards.

Siva

[lbunnell]

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%2f...$(_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);

[john_novello]

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

[lbunnell]

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

[Clever_Anjos]

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);

[lbunnell]

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

[Clever_Anjos]

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

[lbunnell]

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

[Clever_Anjos]

"\\" shouldn´t be there?