Qlik Community

QlikView Connectors

Discussion board for collaboration related to QlikView Connectors.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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

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 !!!.

 

 

4 Replies
Highlighted
Specialist II
Specialist II

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

Contributor
Contributor

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.

 

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
Specialist
Specialist

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