topic Re: How to run script in data load editor automatically at regular Intervals - Qlik Sense Desktop in Connectivity & Data Prep

How to run script in data load editor automatically at regular Intervals - Qlik Sense Desktop

Anonymous — Mon, 04 Jun 2018 11:14:24 GMT

Hi Team,

I want to run existing script in "Data load Editor" at regular Intervals (Assume every 1 hour) & update KPI statistics "App Overview" with already existing measures.

Is it possible to do? Please share sample script to perform this requirement.

I have remote desktop open 24X7 & data will be pumped in to folder "C:\Users\sXXXX\Documents\Qlik\Data" every one hour & accordingly all KPI stats should be updated in Qlik Sense Desktop accordingly as per new data.

It will be more helpful if i get the reply at the earliest.

Thanks

Suresh

+91 9871200685

Re: How to run script in data load editor automatically at regular Intervals - Qlik Sense Desktop

Gysbert_Wassenaar — Mon, 04 Jun 2018 18:02:26 GMT

Try something like a AutoIT or AutoHotKey script and schedule it with windows tasks.

Re: How to run script in data load editor automatically at regular Intervals - Qlik Sense Desktop

Anonymous — Tue, 05 Jun 2018 12:26:00 GMT

Hi Gysbert,

Thanks for revert, I have explored AutoHotKey script & found its quite interesting.

I used below script to operate, Coordinates (2069,42) received from windows spy tool (snapshot) enclosed but the problem is with accuracy, @

Coordinates which I'm using from Windows Spy are not accurate due to which after running script.. execution is happening some where across the screen.

I tried all possibilities to resolve but couldn't helpful

Is there any way you can help me out from this.

; Main Script

;---------------------------

Pause Off

Sleep, 2000

Mousemove, 2069, 42

Sleep, 1000

click, 2069 45

Sleep 1000

ExitApp

^z::Pause

^x::ExitApp

Re: How to run script in data load editor automatically at regular Intervals - Qlik Sense Desktop

brunobertels — Tue, 05 Jun 2018 12:32:55 GMT

you can try this extension

http://branch.qlik.com/#!/project/58276ae8d4dbcc7481114356

Re: How to run script in data load editor automatically at regular Intervals - Qlik Sense Desktop

Anonymous — Thu, 07 Jun 2018 11:57:34 GMT

I'm getting this error using Reload button.

"Error: Reload failed. isPartial:false"

Can anyone help on this?