Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Take a look here: QV 12.10 “Can Execute External Programs” is back | Qlikview Cookbook
- Marcus
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
It's correct. It is a server wide setting that will allow executing external programs if the script allows it.
Thank you Miguel Angel
In that case, I think I will have to find another solution than Execute!
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