Automated Upload of excel/csv files generated from Qlikview application to Sharepoint from

[ashishseth1988]

Hi Everyone,

I am able to load data from excel files available at SharePoint location however as a next part of automating end to end process I also need to upload data back to SharePoint using the same Qlikview application.

Can you please extend your help & support here to achieve this.

Many Thanks in advance !!!.

[jwjackso]

You can use the Store command to create a csv file from a table in the load script.

[ashishseth1988]

I am able to generate csv file I am interested to know an automated way upload generated csv file to SharePoint with in the same application.

[Brett_Bleess]

You would need to use the Execute script function to allow you to run say an instance of a CMD to run a RoboCopy command to copy the file back over, that would be the best way to do things I believe.  Here are some Help links to guide you on things, there are some other settings you will need to allow etc.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

Just be sure you run cmd.exe -c such that the cmd dialog is shutdown after the command is run, otherwise the task may hang etc.  Hopefully this is what you need to get things the rest of the way.

Regards,
Brett

[johnca]

You can save (Store) directly into Sharepoint as long as you can reach the desired location using Explorer. I used to do this but when we migrated to O365 it broke.

When in Sharepoint, try to open the location in Explorer and note the path. Copy that path into your Store command in the script, along with the stored filename of course.

HTH,

John