topic From Qlik to Git - Pushing data in csv format in Integration, Extension & APIs

From Qlik to Git - Pushing data in csv format

theresa_me — Thu, 22 Dec 2022 10:22:14 GMT

Hey there,

we want to push our dataframe/datamodel we created Qlik to our Git repository in a csv format, so the dataframe is available in git as a csv dataframe. We would like to automize this task on a monthly basis. We are using Qlik Enterprise.

Anybody knows if thats possible - and if, how?

Thanks in advance! Looking forward to your input : )

Re: From Qlik to Git - Pushing data in csv format

GTiscareno — Thu, 12 Jan 2023 20:25:59 GMT

do you have Nprinting? is so that will a quick solution, check the article

https://community.qlik.com/t5/Qlik-NPrinting/Distributing-CSV-file-in-nprinting/td-p/1051384

if not you can use in your load script the you can have at the end STORE-statements that can store an in-memory table in a text (CSV)-file or a QVD-file. Check the next article:

https://community.qlik.com/t5/App-Development/Excel-CSV-Automation-of-a-Report-in-QlikSense/td-p/1244187

hope this helps.

Re: From Qlik to Git - Pushing data in csv format

Marc — Mon, 30 Jan 2023 02:03:52 GMT

As part of your load script you would use a store command to export the data to a CSV file.

You would then need to commit that file change into git.

How I would set this up would be.

Clone the Remote Git repository to a local location.

Set the App reload script to export the CSV using the "Store" command into the local git repo.

Set a "External Program Task" to run a PowerShell script to perform the Git Commit & Push
Link the External Program Task to run upon successful completion of the App Reload.