topic Re: How to Run macros in QMC in QlikView

How to Run macros in QMC

Fri, 02 Oct 2015 11:06:33 GMT

HI Guys,

I've got a problem when i run my QV model manually on a server it runs and send me an email with an attachment Via Macros,

but when i use QMC it dosen't send and email and it dosen't give me any problems with the macros.

* i did allowed Macro execution on a server together with unsafe macros

so im not sure on how to tackle this??

Urgent help will be beneficial.

Thanks.

Re: How to Run macros in QMC

jerrysvensson — Fri, 02 Oct 2015 11:16:02 GMT

QMC will not run macros.

Re: How to Run macros in QMC

petter — Fri, 02 Oct 2015 11:38:17 GMT

You can send e-mails from a load script by various mechanisms. Using PowerShell (part of any Windows installation) can allow you to use the PowerShell Send-MailMessage command. This has to be invoked from the load script with a load script statment called EXECUTE.

However the right version of PowerShell has to be installed on the server and the Windows administrators has to allow the account which is running the load script to execute PowerShell. This should be possible to accomplish as it doesn't introduce new software but of course the security policy has to be taken into account.

Re: How to Run macros in QMC

andrespa — Fri, 02 Oct 2015 13:13:36 GMT

Hi Thabiso,

You just can run macros if you're using the IE Plugin. Probably you're using Ajax and that's why the macro won't launch.

Cheers,

Andrés

Re: How to Run macros in QMC

Fri, 02 Oct 2015 13:20:19 GMT

Hi Andres,

My Macro runs fine, when running manual reload, but when i deploy it and schedule to QMC and run immediately thats when i can't get the answer im looking for.

Manually: i receive an email with an attachment

on Deployment: model runs but no email.

do i have to enable something in order for my macro to process the step.

Thanks.

Re: How to Run macros in QMC

magavi_framsteg — Fri, 02 Oct 2015 14:24:44 GMT

Another way, unless you want to do as Petter suggests is to make use of Publisher External Tasks:

- Create a batch file

- In said file, issue %PATH-TO-QV.exe%\qv.exe /r path-to-qvw-doc.qvw

- Create an external task in QMC > System > External Task

- OnPostReload macros gets triggered if qv.exe does the reload, NOT if qvb does the reload.

Re: How to Run macros in QMC

Fri, 02 Oct 2015 14:32:47 GMT

Hi Magnus,

seems you understand what i want to do, can you please send a sample screenshot on all theses steps?

as im not so sure on how to tackle this.

Thanks.

Re: How to Run macros in QMC

Anonymous — Mon, 05 Oct 2015 10:33:49 GMT

HI Guys,

im still having the problem with sending an email to with an attachment.

Thanks.

Re: How to Run macros in QMC

jerrysvensson — Mon, 05 Oct 2015 11:17:49 GMT

Didn't Magnus solution work?

Re: How to Run macros in QMC

Mon, 05 Oct 2015 11:21:06 GMT

HI Jerry,

how do i get to Publisher External Tasks?

not so sure about that, if its a Qlikview Publisher one, then i don't have.

Thanks.

Re: How to Run macros in QMC

jerrysvensson — Mon, 05 Oct 2015 11:26:09 GMT

Then you can use Windows Task scheduler instead.

- Create a batch file

- In said file, issue %PATH-TO-QV.exe%\qv.exe /r path-to-qvw-doc.qvw

Schedule the batch file.

Re: How to Run macros in QMC

Mon, 05 Oct 2015 11:30:05 GMT

Hi Jerry,

not sure on how to get to that,

i can only go to Task Scheduler, from there i don't see where i can create In Said File.

Please assist.

Re: How to Run macros in QMC

jerrysvensson — Mon, 05 Oct 2015 11:45:43 GMT

You create batch file on your filesystem and then Schedule that in Task scheduler. If you don't know how to do it I suggest you ask your IT to help you.

Re: How to Run macros in QMC

magavi_framsteg — Wed, 07 Oct 2015 11:44:41 GMT

Hi.

See attached screenshots.

PS: You need QV Publisher for this to work, else you need to do as our good Mr. JERRYSVENSSON‌ suggests here: Re: How to Run macros in QMC

QMC -> System -> Supporting Tasks -> [Publisher Node] -> External Program -> Add Task

Hope it helps.

// Regards

Magnus ÅVITSLAND

Business Intelligence Architect