topic how to signal app reload issues to users? in App Development

how to signal app reload issues to users?

robodeveloper — Tue, 19 Jun 2018 08:46:40 GMT

We're new to Qlik as an organisation. We are running batch processes (SAS) to create files overnight (e.g. CSV) that the Qlik Sense (Feb18) apps can then upload.

Naturally some days there are overnight issues with the files created. What methods do you use to signal to your users that there has been an issue and the data within the app has not been refreshed?

I'd love to know how other organisation have approached this. We have a mixture of users some of whom will check reload dates, and some won't.

thanks

Ross

Re: how to signal app reload issues to users?

mikegrattan — Tue, 19 Jun 2018 19:29:49 GMT

Although I haven't tried it myself, I know there is a tool available from Qlik Branch

Re: how to signal app reload issues to users?

robodeveloper — Thu, 21 Jun 2018 13:06:58 GMT

As administrators we have used nPrinting to notify us of failures on a timing schedule.

My question was more about signalling the reload status of an app to the end users.

Re: how to signal app reload issues to users?

mikegrattan — Thu, 21 Jun 2018 15:10:07 GMT

If you want something simple that can be displayed on a sheet in the application, you can place a text box or KPI object on your sheet and use the ReloadTime() function to display the last reload date/time. Combine that with a process that manages your downloaded files such as:

Have two separate folders on your server. One for receiving the new files from SAS and one to temporarily contain a copy of only the newest file for loading into Qlik.
Set up a Powershell script to copy from the source folder to the Qlik data load folder based on datetime stamp of file; i.e., if you are expecting one new file per day, only copy the file if it has a date of today.
Set up your Qlik Sense reload task to pull from the Qlik data load folder
Powershell script will run after the scheduled Qlik data load task and delete the contents of the data load folder
Powershell script can email users if there is no new file in the SAS source folder.
If there is no new file in the Qlik data load folder the reload task should fail, and the ReloadTime() function should still show the prior reload date/time.

If you are currently looping through a folder full of SAS files, you might consider saving your data to a QVD file and do incremental loads to add each day's new SAS file to the QVD file, delete SAS file using Powershell, repeat.