topic Execute python script in load script in QlikView

Execute python script in load script

Anonymous — Mon, 26 Feb 2018 12:35:56 GMT

Hi,

I am trying to run python script inside my load script in Qlik Sense app.

I know that I need to put OverrideScriptSecurity=1 in Settings.ini

I put

Execute py lib://python/getSolution.py 12 'ble';

and I get no error in qlik sense, bu script is not executed (I think) because inside the script I have

f = open("file.xml", "wb")

f.write(xml)

f.close

and file is not saved.

If I run script from terminal, then script is properly executed.

What could go wrong?

Re: Execute python script in load script

Peter_Cammaert — Mon, 26 Feb 2018 13:13:38 GMT

Can you specify a full path to the python interpreter?

Re: Execute python script in load script

Anonymous — Mon, 26 Feb 2018 16:20:58 GMT

Hi,

My path is

C:\Users\Marko Z\AppData\Local\Programs\Python\Python37-32\python.exe

why? Is there a "right" and "wrong" path for qlik sense?

Re: Execute python script in load script

Peter_Cammaert — Mon, 26 Feb 2018 17:05:04 GMT

You misunderstood me. I meant "can you add a full path to the command you are trying to execute using the EXECUTE script statement".

Most of these EXECUTE problems have to do with the fact that the Windows shell can't find the program to execute. Even cmd.exe may require a full path sepcification before it can be found.

Re: Execute python script in load script

Anonymous — Mon, 26 Feb 2018 17:10:03 GMT

hmmm I can see your point...

Now I try with :

Set vPythonPath = "C:\Users\Marko Z\AppData\Local\Programs\Python\Python37-32\python.exe";

Set vPythonFile = "C:\Users\Marko Z\Documents\Qlik\Sense\....\getSolution.py";

Execute $(vPythonPath) $(vPythonFile);

But it still doesn't work...

any idea?

Re: Execute python script in load script

Anonymous — Mon, 26 Feb 2018 17:19:53 GMT

Is there a way that python would writ in console... so that I would see if it is executing.... I see that if I mistype the path Qlik Sense give me an error

The handle is invalid:,.....

Is this mean that if no error presents, that script is executed? But why then it would not save a file,...

Re: Execute python script in load script

Peter_Cammaert — Mon, 26 Feb 2018 17:26:18 GMT

No idea. Permssions? Can you check whether you python script - when launched via the EXECUTE statement - is able to write to a global directory like C:\Temp?

Re: Execute python script in load script

Anonymous — Mon, 26 Feb 2018 17:30:28 GMT

I am not sure what do you mean by that,... I am sure that Qlik Sense could save file (I exported csv file), but I can't check if python has permissions because the it doesn't display any error. Terminal could save to file,..

Re: Execute python script in load script

Anonymous — Mon, 26 Feb 2018 17:40:03 GMT

My python code is

xml = "Marko"

xml = xml.encode('utf-8')

f = open("C:\\Users\\Marko Z\\Test.xml", "wb")

f.write(xml)

f.close

Re: Execute python script in load script

Peter_Cammaert — Tue, 27 Feb 2018 15:04:38 GMT

Indeed, your attempt to write a file seems straightforward enough. What I meant by my request was to try to write to a global directory that is accessible to everyone (like C:\Temp)

If you start ProcessExplorer or Task Manager, do you see the python interpreter being launched when you run the load script? For a better chance of python.exe being visualized, add some code to your script that takes a while to complete, like a loop.

Re: Execute python script in load script

Peter_Cammaert — Tue, 27 Feb 2018 15:23:07 GMT

Just a question. Did you disable Standard Mode in Qlik Sense Desktop before trying to execute your Python script?

See: Disabling standard mode - Qlik Sense

Re: Execute python script in load script

Anonymous — Tue, 27 Feb 2018 15:24:01 GMT

Yes I did.

Re: Execute python script in load script

Anonymous — Tue, 27 Feb 2018 19:15:33 GMT

You were right. If I move script in C:\Windows\test.py it work.

Now I assume that the problem is space in path....

Any thoughts?

Thank you.

Re: Execute python script in load script

Peter_Cammaert — Wed, 28 Feb 2018 11:31:52 GMT

Put double-quotes around paths that you want to pass as-they-are (including any spaces) to an external program. Double-quotes will be passed along and won't be interpreted by the script engine in this case.

See this subthread for an explanation: Re: Double quotes on Execute statement

Re: Execute python script in load script

aritting — Tue, 11 Sep 2018 18:12:30 GMT

Most of these EXECUTE problems have to do with the fact that the Windows shell can't find the program to execute. Even cmd.exe may require a full path sepcification before it can be found.

Peter Cammaert's answer is most likely the correct one if you get the error message " Error: The handle is invalid."

Even if the execute command runs in QlikView Application on the server the executable may not be in the path for the service account running the qlikview distribution engine.

Check the system Path environment variable in Windows System Properties "Environment Variables"
.

Re: Execute python script in load script

Anonymous — Tue, 27 Nov 2018 07:23:01 GMT

I guess the problem is not with spaces but the directory is not accessible from qlik sense.

Re: Execute python script in load script

jlongoria — Fri, 14 Dec 2018 22:14:03 GMT

This works for me.

I have the following folders/files:

myfolder/qvw/testpython.qvw

myfolder/bin/testpython.qvw

myfolder/data

For QVW:

Go to Settings-->User Preferences-->Security and select the checkbox next to "Script (Allow Database Write and Execute Statements)"

In the load script editor Settings tab, select the checkbox next to "Can Execute External Programs"

QVW Load Script:

// Change path to python.exe per your local installation

EXECUTE D:\ProgramData\Anaconda3\python.exe "..\bin\testpython.py"

Python file:

# Open a file stream for writing

# assume data folder exists...if not, need to create for this call to work

f = open("../data/testpython.txt","w+")

# Write test content to file

f.write("this is a test...this is only a test...")

# Close file stream

f.close()

Re: Execute python script in load script

nategreen — Tue, 20 Aug 2019 18:43:20 GMT

I was able to get the below to work in qlik sense:
set vPyExe = C:\Program Files\Python37\python.exe;
set vPyScript = D:\...\PythonScript.py;

Execute
"$(vPyExe)" "$(vSource)"
;