topic Re: Batch file & windows scheduler in QlikView

Batch file & windows scheduler

Anonymous — Thu, 29 Oct 2015 01:44:51 GMT

Hi,

Please suggest how to create a batch file to reload the dashboard automatically and also to create a windows scheduler to run the batch file every 5 seconds.

I have also small query how to refresh the dashboard in access point without using qemc / server side settings.

because getting permission from admin team to automatic schedule the reaload for dashboard in access point 5 secs is very low.

So I need an alternative way, could someone please suggest me the ways?

I am attaching the sample app. Please suggest me

Re: Batch file & windows scheduler

sujeetsingh — Thu, 29 Oct 2015 03:13:05 GMT

Here it is

Batch file script to reload Qlikview Applications

Re: Batch file & windows scheduler

Anonymous — Thu, 29 Oct 2015 04:39:33 GMT

Thanks Sujeet for the post

unfortunately if I use /R dashboard is not getting reload it could only open the application its not getting reloaded and also new data is not appealing.

if I use /L the new data is appealing but qlivkiew instance exists on the screen.

Kindly suggest

Re: Batch file & windows scheduler

vikasmahajan — Thu, 29 Oct 2015 04:41:56 GMT

see this

and https://community.qlik.com/docs/DOC-5412

and

https://community.qlik.com/message/157373#157373

Hope this solves your problem

Vikas

Re: Batch file & windows scheduler

HirisH_V7 — Thu, 29 Oct 2015 04:58:52 GMT

Hi John ,

You can create Script like this . Please check the attachments.

Create A task in the task scheduler as for your reloading time basis.By this reload dash boards on access point get automatically updated as of last reload time. Once you refresh your browser.

Hope this helps.

Regards,

Hirish

Re: Batch file & windows scheduler

Anonymous — Thu, 29 Oct 2015 05:03:41 GMT

Hello all

thanks for the replies

I was using the same batch file syntax to reload the dashboard , but unfortunately my dashboard is not reloading with new data/records and even not giving error.

My major concern is with batch file to reload the dashboard, that is not happening with the line

"C:\Program Files\QlikView\qv.exe" /r "C:\QlikviewApplications\dynamic.qvw"

Exit

any suggestions on this pls

Re: Batch file & windows scheduler

vikasmahajan — Thu, 29 Oct 2015 05:17:24 GMT

Did you check with log file ?

Vikas

Re: Batch file & windows scheduler

HirisH_V7 — Thu, 29 Oct 2015 05:24:10 GMT

Is there any error message or can u please check once the sources of the application you mentioned in batch file are correct .

Re: Batch file & windows scheduler

Thu, 29 Oct 2015 05:49:13 GMT

Hi john,

are you running via service account?? when you run batch file manually,is it working fine??othrwise try EDX

Re: Batch file & windows scheduler

HirisH_V7 — Thu, 29 Oct 2015 06:35:03 GMT

hi john can you attach your bat file if possible .

Re: Batch file & windows scheduler

petter — Thu, 29 Oct 2015 06:38:58 GMT

When you put up a schedule - make sure that you schedule it using the same User Account as the one that is licensed to use the QlikView application... Or it will run as Personal Edition and probably fail...

Re: Batch file & windows scheduler

Anonymous — Thu, 29 Oct 2015 07:10:35 GMT

Hello Petter

Thanks for the suggestion

but unfortunately I am using the same user account details and QV enterprise edition too .

My concern Is not with the scheduler with the batch line to reload the dashboard

that is not happening

please suggest me in that area?

Re: Batch file & windows scheduler

Anonymous — Thu, 29 Oct 2015 07:32:37 GMT

Here is my attached Batch file

Please look into it and suggest me if any syntactical error

Re: Batch file & windows scheduler

Anonymous — Thu, 29 Oct 2015 07:54:48 GMT

any help

Re: Batch file & windows scheduler

HirisH_V7 — Thu, 29 Oct 2015 08:09:07 GMT

Hi,

Its fine. Can you check is there any post reload trigger in your application Document Properties > Triggers > Document event triggers.

Does the document reload normally if you open it in QV desktop and click reload?

Turn on the document reload log (Document Properties | General) and then check the log to see the last statement executed by the load script, which will help you to identify the statement causing the reload to stop or freeze.

thanks,

hirish

Re: Batch file & windows scheduler

marcus_sommer — Thu, 29 Oct 2015 09:08:56 GMT

Could do you open and reloading the application manually with this user? Did you try it directly on the server or from another (local) machine?

- Marcus

Re: Batch file & windows scheduler

Anonymous — Tue, 03 Nov 2015 03:14:21 GMT

Hello all

thanks for the replies, I can manually reload the dashboard in my desktop and I am using service account QV even if I keep /L in the batch file the dashboard is reloading but only the problem with /L is everytime the instance of QV will opens this I don't need.

I need /R i.e dashboard should reload and instances of QV should be opened only once or closed.

I am unaware of EDX and want an sample app on it, to get started.

Please help me on this regard.

Re: Batch file & windows scheduler

petter — Tue, 03 Nov 2015 05:59:54 GMT

Are you sure that your BAT-file is running at all? A BAT-file needs to be invoked via the cmd.exe. It can't be called upon directly.

So from the Windows Scheduler it has to look like this:

c:\Windows\System32\cmd.exe /c c:\QlikViewApplications\test.bat

But you could drop the BAT-file if it contains only one line and invoke qv.exe directly.

Re: Batch file & windows scheduler

marcus_sommer — Tue, 03 Nov 2015 11:28:32 GMT

You won't get everything to work with the parameter /r - qlikview runs then more like a service then as a normal application and not each mechanism is then available. A common workaround for this is using the /l parameter and to quit those thread after finishing or to switch completely to vbs which is in general more flexible. See here an example: Re: Vbs - passing parameters to opendoc or opendocex

- Marcus