topic Re: "Can Execute External Programs" in Qlik Sense in App Development

"Can Execute External Programs" in Qlik Sense

stefanvb — Mon, 26 Sep 2016 15:00:14 GMT

Hi all,

I was wondering about the following.

Previously I have built several QlikView applications which make use of Windows command functions (e.g. "EXECUTE cmd.exe /c del $(File)"). In order to let this work smoothly, I enabled the setting "Can Execute External Programs" in the Script Editor sub-menu.

I would to transfer the script to a Qlik Sense application. Transferring the script is not a big deal but where can I find this option in Qlik Sense?

I understand for Qlik Sense you will need to modify the Settings.ini file located in the folder

(add

[Settings 7]

OverrideScriptSecurity=1

)

However, I see this is not working as I still get the following error:

EXECUTE statement not available in this script mode.

Someone any idea whats going on? Please note the entire script is working fine in QV.

Regards,

Stefan

Re: "Can Execute External Programs" in Qlik Sense

Eugeny_Ilyin — Thu, 29 Sep 2016 09:56:02 GMT

Hi,
File system access restriction ‒ Qlik Sense

Re: "Can Execute External Programs" in Qlik Sense

stefanvb — Thu, 29 Sep 2016 12:11:39 GMT

Thanks for the response but not sure what you are referring to.

I followed the instructions as mentioned in the link disabling standard mode in Qlik Sense but still having the same error.

Re: "Can Execute External Programs" in Qlik Sense

Anonymous — Wed, 26 Apr 2017 14:18:52 GMT

Open C:\Users\{user}\Documents\Qlik\Sense\Settings.ini in a text editor and write two lines.

[Settings 7]

OverrideScriptSecurity=1

StandardReload=0

Re: "Can Execute External Programs" in Qlik Sense

Thu, 27 Apr 2017 21:51:46 GMT

I apply the change in ini file, and work for me. I use R and work fine:

EXECUTE "C:\Datos\LocalDocuments\R\R-3.3.1\bin\x64\R.exe" CMD BATCH "C:\Qlikview_mas_R_2\rpart_script_sinRattle.r"; //rpart_script.r";

Re: "Can Execute External Programs" in Qlik Sense

stefanvb — Fri, 05 May 2017 13:05:51 GMT

Hi all,

Thanks for providing input. Unfortunately both suggestions are not working.

I was thinking this might be related to the fact I am using Qlik Sense Server instead of Qlik Sense Desktop edition.

For now I resolved the issue by scheduling a BAT-script in Windows Task Scheduler which basically does the same.

Regards,

Stefan

Re: "Can Execute External Programs" in Qlik Sense

Anonymous — Mon, 04 Jun 2018 08:50:14 GMT

Hi Stefan,

I am using Qlik Sense Server as you and updated the setting file. It shows no error when reload data in Qliksense but the QVD hasn't been deleted in fact.

You mentioned the BAT- script for your solution.

Do you mean batch script which using the command?

Regards\Helen

Re: "Can Execute External Programs" in Qlik Sense

stefanvb — Mon, 04 Jun 2018 09:28:29 GMT

Hi Helen,

That's correct. Idea was the Qlik application to execute the Windows Commands, however I still haven't found a way to do this in Sense. As a workaround I created a .BAT script and scheduled this using Task Scheduler in order to remove the files on a regular basis.

Commands in the script could look like :

@echo off

XCOPY /Y \\['File server']\Qlik\['Source System']\*.txt "D:\0. Data\1. ['Source system files']"

Regards,

Stefan

Re: "Can Execute External Programs" in Qlik Sense

adrianpautasso — Thu, 07 Mar 2019 15:39:51 GMT

Hi Stefan,

I'm having the same issue. Did you manage some solution for the execution in qlik sense server?

Regards,

Adrián

Re: "Can Execute External Programs" in Qlik Sense

SimonAichmayr — Mon, 19 Oct 2020 09:45:13 GMT

Hi Guys!

My aim is to execute an external program in qlik sense enterprise which load a custom script into the engine. I setted the legacy mode in the qmc and did in the setting.ini the tasks to use the execute statement. When I run my program in the terminal it works but when I run it in the qlik sense hub-script it doesn´t work. No error occured while I run my program in qlik sense. I dont understand why this is not working. I hope you can help me. Thanks in advance!

Re: "Can Execute External Programs" in Qlik Sense

pwagner — Fri, 12 Feb 2021 07:19:24 GMT

@SimonAichmayr and @adrianpautasso

Have you found a solution for your topic?

Best regards,

Patrick