topic Re: Macro issue??? in QlikView

Macro issue???

Fri, 26 Apr 2013 12:40:47 GMT

Hello,

I have created a macro, which exports the chart to excel and sending it through email. It works fine when i press the reload button.

I just want to automate this process through Task Scheduler( Reloading & running macro).

Iam using the following command for reloading but its not running the macros after reload ( Setting in Documents properties->Post Load -> run macro -> 'Macroname')

Reload.bat file: (Calling this file through task schedular)

"C:\Program Files\QlikView\qv.exe" /r "D:\Qlikview Applications\Buckinghamshire.qvw"

Its reloading the qvw file but macro are not executing after reload....

Any help is much appreciated...

Regards

Siva Rama

Re: Macro issue???

Fri, 26 Apr 2013 12:51:56 GMT

try this for make batch file

HERE REPLACE r by L

"C:\Program Files\QlikView\qv.exe" /I "D:\Qlikview Applications\Buckinghamshire.qvw"

Re: Macro issue???

Fri, 26 Apr 2013 12:59:15 GMT

since /r not reload the script file. only showing reload because it reload externally.

but /l reload the whole script.

In macro you must allow the SYSTEM ACCESS and also the ALLOW SYSTEM ACCESS

Re: Macro issue???

Sat, 27 Apr 2013 07:01:04 GMT

Vishwaranjan,

Thanks for your prompt reply.

Its working fine, when i double click Reload.bat file.

But when i start running this Reload.bat file throughTask Schedular... Its reloading the qvw file but post reload macros are not running...

Any clues...

Regards

Siva

Re: Macro issue???

Sat, 27 Apr 2013 07:46:06 GMT

Vishwa,

Please check the attachments for reference.

Its working fine, but not executing through task schedular. Please help.

Regards

Re: Macro issue???

Mon, 29 Apr 2013 04:54:22 GMT

I think you miss some steps in macro.

go to macro script

then on Requeste module security ---> select System Access

and Current Local Security ----> select Allow System access

then ok.

Re: Macro issue???

Tue, 07 May 2013 10:53:25 GMT

Thank you very much for your help at the right time.

In my case, Its because of the Task Schedular. We are running it from Normal User, instead of Administrator. the option we selected is 'Run only when user is logged on' to excecute the task. The task is executing without any issues, if i keep the session(user connection) open all the time or when the task is started executing.

If i select the second option('Run whether user is logged on or not'), the task is not executing with macros.

Its Strange behaviour.

Regards

Siva Rama