topic Re: Writting data from Qlikview to SharePoint in QlikView

Writting data from Qlikview to SharePoint

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Please assist me here:

I have data from sharepoint that i'm putting in Qlikview. The users enter data into an excel sheet in sharepoint and i read it into Qlikview.

That data is matched against payments in Qlikview to check what has been paid and what has not been paid .

After getting what has not been paid, the user requested that we write back what has not been paid back to the excel sheet in sharepoint

Is it possible to write back that information to Sharepoint?

avinashelite — Wed, 14 Dec 2016 12:59:11 GMT

You can but you need to make this through MACRO code, we don't have direct option in Qlikview to do this You need to have rite permissions also

Wed, 14 Dec 2016 14:52:06 GMT

The one possible option access the SharePoint site data through network drive and store the file into csv format.

1. Create sample csv on the Sharepoint site.

2. Enable the both Read & Write access to qlik service accounts

3. Please enable the network path access to share point site data (you may get \\myteamsite\WWRoot\dev\......)

4. Use store function to store back into SharePoint network drive path

STORE TransTable into [\\myteamsite\WWRoot\Project\data\NotPayment.csv] (txt)