topic Re: Run Macro from Console in QlikView

Run Macro from Console

it_bi_vg — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I've the application "A" that runs this macro, after Event PostReload or on demand from button.

set objExcel=ActiveDocument.GetSheetObject("CH01")
objExcel.ExportEx filepath,4

I' ve publisher and I'd like to schedule it from Management Console every day , but I can't reload this macro. It doesn't work.

I don't like to use Windows Scheduler, I prefer to use only Qlikview tools.

I've red this: The OnPostReload event is not fired after a server reload.

if it wasn't possible, I would run on demand from other application "B".

In other words, Application "B" has a button (on demand from users), it opens application "A" and run macro or when I load script, it executes statement or file.bat that export table to qvd.

Thanks for your help

Re: Run Macro from Console

pradosh_thakur — Fri, 15 Feb 2019 14:56:02 GMT

Post reload trigger will not work on QMC. It only will work when run manually or from scheduler.

I can list out a few option you can explore.

1: store table using "store table into table.qvd" from script.

2: Run it from window scheduler as you have asked.

3: Run a task from qmc which will in turn run a batch file which will open a qvw on the server , do a reload , run the macro, store the table and close the qvw again.

It's up to you what you choose.

Thanks

Pradosh

Re: Run Macro from Console

it_bi_vg — Fri, 15 Feb 2019 16:25:00 GMT

I can't use the first option, because I'd like to store a table with difficult and long KPIs .

I can use the third.

I've written Test_vbs :

Set objShell = CreateObject("WScript.Shell")
set fso = CreateObject("Scripting.FileSystemObject")
dim CurrentDirectory
CurrentDirectory = fso.GetParentFolderName(Wscript.ScriptFullName)
set qv = CreateObject("QlikTech.QlikView")
dim qvDocName
qvDocName = fso.BuildPath(CurrentDirectory, "test.qvw")
objShell.AppActivate("test.qvw")
set doc = qv.OpenDoc(qvDocName)
set obj = doc.GetSheetObject("CH01")

obj.ExportEx "test.qvd",4
doc.CloseDoc
qv.Quit

<<<<------------------------------------------->>>>

I've written test.bat

@echo off

wscript "C:\Desktop\test\Test_vbs.vbs"

<<<<------------------------------------------->>>>

In my qvw :

Execute cmd.exe /C test.bat ;

<<<<------------------------------------------->>>>

If I click on the test.bat , it works, If I run qvw, it doesn't create the qvd.

Thanks.

Re: Run Macro from Console

it_bi_vg — Fri, 15 Feb 2019 16:27:34 GMT

I can't use the first option, because I'd like to store a table with difficult and long KPIs .

I can use the third.

In my qvw :

Execute cmd.exe /C test.bat ;

<<<<------------------------------------------->>>>

If I click on the test.bat , it works, If I run qvw, it doesn't create the qvd.

Thanks.

Re: Run Macro from Console

pradosh_thakur — Fri, 15 Feb 2019 16:31:46 GMT

documnet setting-> security-> all macro overrides security are checked and run external programs are checked.

user preference-> macro related check

last but not the least

go to script (ctrl+E) -> On the bottom where there is odbc connection option etc are there there is a setting tab -> setting-> can execute eternal commands -> check

run it again and it shall work. attach scrrenshot of these if it doesn't.

Thanks

Pradosh

Re: Run Macro from Console

it_bi_vg — Fri, 15 Feb 2019 16:45:10 GMT

I've already set all parameters but I see only black window.

Re: Run Macro from Console

pradosh_thakur — Fri, 15 Feb 2019 16:51:01 GMT

run some other batch file that will do a simple task like copying a file or something and see if that works or not.

Re: Run Macro from Console

pradosh_thakur — Fri, 15 Feb 2019 16:53:43 GMT

I think you need to provide the absolute path of the batch file in double quotes if it contains space.

Execute cmd.exe /C "c:/... absolute pathe to the file ... test.bat ";

Re: Run Macro from Console

it_bi_vg — Fri, 15 Feb 2019 17:01:53 GMT

If I use simple vbs , it works.

Re: Run Macro from Console

pradosh_thakur — Fri, 15 Feb 2019 17:04:12 GMT

@it_bi_vg did you use the absolute path to the bat file in double quoted after cmd.exe /c ?

Re: Run Macro from Console

it_bi_vg — Fri, 15 Feb 2019 17:08:51 GMT

the problem isn't path, because I've used the same files and I replaced the simple statement to copy and it works.
Maybe it doesn't work because I can try to open an other qvw file, maybe it wants some parameters to open concurrent qvw.

Re: Run Macro from Console

pradosh_thakur — Fri, 15 Feb 2019 18:57:10 GMT

I hope you are trying this

1: The bat file is just opening the ABC qvw.

2: The ABC.qvw is in the server /desktop.

3: This qvw has an on open trigger , which runs a macro

4: Macro stores QVD/ does whatever it is supposed to do.
5: Bat file closes and ABC.qvw closes

I have tried something similar above and it worked for me

Regards

Pradosh