Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear colleagues,
I have issue with Execute statement in load script when I try to run the python file.
Script runs with success when I run it without qlik (just pushed enter on it), or when I input it in cmd file and run from command file.
But it doesn't execute when I use Execute in Qlik load script. Even when I input python script file path in cmd file, and execute cmd.
I'm asking for help.
For information, I have already used this variants (doesn't work):
"Can Execute External Programs" checkbox is enable.
I solved my issue. It works when Qlik application and script situated in the same folder.
up
You should use double quotes in order to make it work...
For example i use the following excute command with success:
EXECUTE cmd.exe /c del "\\QLIKVIEW_SRV\E$\QV_CommonStorage\Actual_tmp.qvd";
I tried this approach too, but it doesn't work.
up
Hi Anton.
Try this:
Execute cmd /C "cd E:\Qlikserver\03.Utils && python script.py"
Hi Anton
I often use Python in QV script and it works without any problems, also with parameters for python script.
For example:
set csvPath='$(sData)\$(sDataArea)\$(vVersion)\Export_PSP.csv';
Store PSP into [$(csvPath)](txt);
let csvPath=Replace('$(csvPath)','\','/');
set pythonExe = 'c:\Tools\WinPython-64bit-3.6.3.0Qt5\python-3.6.3.amd64\python.exe';
set pyScripts = '\\server\Scripts\Py';
EXECUTE $(pythonExe) $(pyScripts)\HR_Counter.py -csv "$(csvPath)";
- Christian
It is very weird situation.
In my local PC (at work) it doesn't works, but in server it works and in my home PC works too.
Maybe I should make additional tune in Windows?
maybe I should make additional tune in Windows?
Because at one PC it works, and in another doesn't.
I solved my issue. It works when Qlik application and script situated in the same folder.