topic Re: Allow Execute in Script (from QMC) in QlikView

Allow Execute in Script (from QMC)

emmanueld — Mon, 15 Oct 2018 09:26:42 GMT

Hi Community!

I am struggling with "Execute" instruction in Qlikview's script. I want to execute a .vbs script that is stored beside the qlikview app, and I'm using the following instruction :

EXECUTE cmd /c BATCH\unzip.vbs > BATCH\unzip.log;

It works fine when run on the client interface, but required me to disable a security pop-up message by checking the box :

Settings > User Preferences > Security > Script (Allow Database Write and Execute Statements).

However, is there a way to allow the execute statement even when the app is reloaded from the QMC?

The Execute statement is ignored when doing so.

Since the setting is a "user preference", I reckon it does not apply to other users (including service account used to run from the QMC), so that would be why it doesn't work.

Thanks for your help

Emmanuel

Re: Allow Execute in Script (from QMC)

marcus_sommer — Mon, 15 Oct 2018 14:09:13 GMT

Take a look here: QV 12.10 “Can Execute External Programs” is back | Qlikview Cookbook

- Marcus

Re: Allow Execute in Script (from QMC)

emmanueld — Mon, 15 Oct 2018 14:32:33 GMT

Thank you Marcus,

I'm on QV11.20 SR12, so from what I understand of the topic you linked, I cannot allow the Execute on my app without allowing it on all other qvw's, is that correct? That would be a problem 😕

In SR11+, Execute may be allowed or disallowed for all qvws via the “AllowExecuteCommand” setting

Re: Allow Execute in Script (from QMC)

Miguel_Angel_Baeyens — Mon, 15 Oct 2018 14:35:30 GMT

It's correct. It is a server wide setting that will allow executing external programs if the script allows it.

Re: Allow Execute in Script (from QMC)

emmanueld — Mon, 15 Oct 2018 14:42:29 GMT

Thank you Miguel Angel

In that case, I think I will have to find another solution than Execute!

Re: Allow Execute in Script (from QMC)

marcus_sommer — Mon, 15 Oct 2018 15:06:52 GMT

Maybe you could use a normal windows-task which checks each n minutes (within a certain time-frame) the value of a text-file which you could create through the script, for example with:

SetParameter: load 'run' as run autogenerate 0;

store SetParameter into SetParameter.txt (txt);

and afterwards you chnaged the parameter again in 'stopp'.

- Marcus