How can I use Python script in workflow?

OL Connect Professional Workflow
1

Hi,

I installed Python 3.13.1 on my server but a Python script doesn’t work in workflow. How can I user Python script?

I’ve read a topic about Python and it said about Python 3.7. However, accoding to Python website, the version which has now reached end-of-life.

It would be great if someone could help me. Thanks.

2

Hello @Kiyomi_Kokubun,

Please check the following webpage for more information about how to be able to use Python in OL Connect Workflow:

Installing the Python engine - OL Connect Workflow 2024.2 Help

3

Hi @Marten ,

Thank you for you reply.
I’ve confirmed the link but I still have some issue.

I downloaded Python and installed it successfully, but I don’t understand how to install PyWin32. I downloaded pywin32-b308.zip, but I’m not sure where to place those files. Additionally, when I run ‘pip install pywin32 --upgrade,’ I encounter an error. Do you know how to fix it? The error message is below.

Also, regarding No. 4, I cannot see the win32comext folder under C:\Program Files (x86)\Python313-32\Lib\site-packages. How should I register Python on my server?

image
image1459×708 90.1 KB

4

Can you let us know please what version of Python you have installed?

Not so long ago I was able to execute a Python script by the Run Script Workflow plugin after executing the following steps:

  1. Download the Windows installer (32-bit) for Python 3.13.0 from Python.org and run the installer
  2. Open the Command Prompt application as Administrator once Python for Windows has been installed successfully
  3. Execute the command pip install pywin32 --upgrade to install PyWin32 (see Releases · mhammond/pywin32 for more information)
  4. Check whether the correct environment variables are applied*
  5. Run the command "C:\Program Files (x86)\Python313-32\Lib\site-packages\win32comext\axscript\client\pyscript.py" from the still open Command Prompt application, whereby C:\Program Files (x86)\Python313-32 is the path where Python for Windows has been installed

*See:

Installers for newer versions of Python (found on Python.org) have an option “Add python.exe to PATH”, making it unnecessary to edit the environment variables manually (as described in step 3 of the above procedure).
They also install pip (the package installer for Python) by default. With pip, PyWin32 can be easily installed from the command line using the following command: pip install pywin32 --upgrade.

Note: Newer versions of Python have not been tested and may not be fully compatible with Workflow.

Source: Installing the Python engine - OL Connect Workflow 2024.2

5

Hi @Marten ,

I’ve installed Python 3.13.0. First of all, the install step was done successfully. But second, I could not run ‘pip install pywin32 --upgrade’ even though I used the Command Prompt application as Administrator. Do you know how I can proceed it? Please find the error message below.

image
image1449×759 77.8 KB

6

You may want to search via one of the search engines available on the internet for:

Connection aborted An existing connection was forcibly closed by the remote host install pip

As there appears to be a restriction in place on your environment that prevents the package installer for Python (pip) from installing any packages.

7

Hi @Marten ,

Thank you for the information. It turns out I needed to use a proxy to complete all the settings. However, I still can’t run the Python script in the workflow. I’ve also checked that the system environment variables are correct. Is there anything else I need to do to run the Python script?

image

image
image780×636 54.2 KB

8

Hello @Kiyomi_Kokubun, were you able to fix the below error eventually?

[0002] Starting plugin Run Script - 12:37:41
[0002] W3603 : Error running script.
[0002] Run Script: W1603 : Plugin failed - 12:37:41 (elapsed time: 00:00:00.002)

If yes, have you executed all the steps described HERE? Because I am able to execute the below Python code successfully by running the Run Script Workflow plugin in debug mode, after executing these steps on a virtual machine.

Watch.Log("Hello World!", 2);

Result:

[0002] Starting plugin Run Script - 15:46:56
[0002] Run embedded script...
[0002] Hello World!
[0002] Data file processed : debug119269.dat, size: 12 bytes
[0002] Plugin Run Script completed successfully - 15:46:57 (elapsed time: 00:00:00.814)

(Test executed in OL Connect Enterprise Workflow 2024.2.1.)

9

Hi @Marten ,

Thank you for your concern. When I executed the fifth step of the Python setup procedure, I was able to install it successfully by adding ‘python’ at the beginning of the command. Python also worked on the workflow. Thank you.

1 Like