topic Re: Execute command does not work in QlikView

Execute command does not work

draghici1109 — Wed, 02 Mar 2022 10:19:59 GMT

Hello,

I want to execute some commands on operating system using the execute command and yet I do not get it executed. I get the message:

EXECUTE statement requires Script (Allow Database Write and Execute Statements) in User Preferences settings
EXECUTE cmd.exe/c chdir C:\Users\wkiv1150\Desktop\BICC\08226000-00-02\DATA

Here is my code:

set vPath = "C:\Users\wkiv1150\Desktop\BICC\08226000-00-02\DATA";
EXECUTE cmd.exe/c chdir $(vPath);
Execute cmd.exe/c findstr /V /R "FeldFesteLaenge" Artikel-Stammdaten_SAP.txt > Artikel-Stammdaten_SAP1.txt;
EXIT SCRIPT;

I set the properties of the tab as follow:

Re: Execute command does not work

Or — Wed, 02 Mar 2022 11:04:50 GMT

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Execute.htm

It looks like you may have missed some steps.

Re: Execute command does not work

draghici1109 — Wed, 02 Mar 2022 11:48:53 GMT

Thank you! Indeed I missed following settings on my desktop QlikView:

Do the following:

On QlikView Desktop Start Page, click the Settings drop-down menu and select Users Preferences...
On the Security tab, select Script (Allow Database Write and Execute Statements) to enable the security override.

The Script (Allow Database Write and Execute Statements) setting must always be enabled if you want to allow Execute statements in the script.
See: User Preferences: Security

Open the QlikView document in which you want to perform the Execute statement, and open the Script Editor by selecting Edit Script... from the File drop-down menu.
In the lower part of the Script Editor window, go to the Settings tab and select Can Execute External Programs.