topic Re: Qlik Sense: Storing CSV to SharePoint in App Development

Qlik Sense: Storing CSV to SharePoint

Jade_Earley — Fri, 11 Jun 2021 07:31:28 GMT

Good morning

I have written an app which, as the final command, stores the table as a CSV into a local folder:

STORE
[Field Names Here]...
FROM DataTable INTO [lib://[Local Filepath Here].csv](txt, delimiter is ', ');

I would like to store this into SharePoint instead. QlikSense has full access to this SharePoint account and I have also set the destination up as a Data Connection. When I do this, the app successfully runs, but the file is not stored in SharePoint.

The command looked like:

STORE
[Field Names Here]...
FROM DataTable INTO [lib://[SharePoint Data Connection Name Here].csv](txt, delimiter is ', ');

Can anyone offer some advice around this?

I am using Qlik Sense June 2020 Patch 15, if that helps.

Thank you!

Jade

Re: Qlik Sense: Storing CSV to SharePoint

PadmaPriya — Tue, 22 Jun 2021 15:04:02 GMT

Hello @Jade_Earley

Please view the below article:

Loading data from files ‒ Qlik Sense on Windows

Thanks,

Padma Priya

Qlik Support

Re: Qlik Sense: Storing CSV to SharePoint

Jade_Earley — Fri, 09 Jul 2021 08:00:07 GMT

Hi Padma

Thanks for your reply. I might be missing something but I don't think this answers my question.

I would like to know how to store a CSV into SharePoint, not load one as advised by the article.

Thank you

Jade

Re: Qlik Sense: Storing CSV to SharePoint

marcusva — Thu, 05 Aug 2021 20:22:01 GMT

Hi,

I have the same issue, any updates on this?

Is there any kind of tutorial or maybe a thread on how to properly connect and directly store/export data to Sharepoint via QlikSense or NPrinting?

Thanks

Re: Qlik Sense: Storing CSV to SharePoint

Jade_Earley — Thu, 03 Feb 2022 15:41:32 GMT

Hi Marcus, I'm still having the same issue and no response. I am raising a ticket to Qlik Support directly and I will post the solution here once I have tested.

Re: Qlik Sense: Storing CSV to SharePoint

tarteflambee — Fri, 04 Nov 2022 14:46:12 GMT

Hi Jade, Community,

Does someone found a solution?

Re: Qlik Sense: Storing CSV to SharePoint

Karthik_Parasa — Mon, 13 Mar 2023 09:50:23 GMT

Hello @Jade_Earley Did you find any solution on the approach?

Re: Qlik Sense: Storing CSV to SharePoint

rpennacchi — Mon, 13 Mar 2023 22:31:50 GMT

By the way you load and store files, I will assume you use Qlik Sense Enterprise On Premise.

You can do this:

1 - Install One Drive on the server that you store your QVD files.

2 - Create a connection folder on your App on the same physical path that your One Drive is installed.

3 - Store your CSV file on this path (One Drive syncronization will automatically upload the CSV file into your sharepoint folder)