topic Re: Execute from Qlikview load script for Python file in QlikView

Execute from Qlikview load script for Python file

antonaks — Tue, 10 Jul 2018 08:04:08 GMT

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):

EXECUTE C:\PycharmProjects\ODS_Data_Observer\data_observer.py;
EXECUTE Python3 C:\PycharmProjects\ODS_Data_Observer\data_observer.py;
EXECUTE cmd.exe /C C:\PycharmProjects\ODS_Data_Observer\New Text Document.cmd;
EXECUTE C:\...\Python\Python36-32\python.exe C:\PycharmProjects\ODS_Data_Observer\data_observer.py;

"Can Execute External Programs" checkbox is enable.

Re: Execute from Qlikview load script for Python file

antonaks — Tue, 10 Jul 2018 12:27:06 GMT

Re: Execute from Qlikview load script for Python file

dapostolopoylos — Tue, 10 Jul 2018 12:57:49 GMT

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";

Re: Execute from Qlikview load script for Python file

antonaks — Tue, 10 Jul 2018 14:26:37 GMT

I tried this approach too, but it doesn't work.

Re: Execute from Qlikview load script for Python file

antonaks — Tue, 10 Jul 2018 15:14:33 GMT

Re: Execute from Qlikview load script for Python file

marco_almeida — Tue, 10 Jul 2018 15:55:02 GMT

Hi Anton.

Try this:

Execute cmd /C "cd E:\Qlikserver\03.Utils && python script.py"

Re: Execute from Qlikview load script for Python file

cwolf — Tue, 10 Jul 2018 19:29:00 GMT

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

Re: Execute from Qlikview load script for Python file

antonaks — Thu, 12 Jul 2018 09:00:14 GMT

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?

Re: Execute from Qlikview load script for Python file

antonaks — Thu, 12 Jul 2018 09:22:21 GMT

maybe I should make additional tune in Windows?

Because at one PC it works, and in another doesn't.

Re: Execute from Qlikview load script for Python file

antonaks — Fri, 13 Jul 2018 14:41:56 GMT

I solved my issue. It works when Qlik application and script situated in the same folder.