Embeding Python Scripts in Wordpress

Question

Greetings fellow reader.

I made a python program which runs locally, it takes an .xls file and performs some actions, and finally it exports another .xls file.

These are the libraries:

from selenium import webdriver
from PIL import Image
import pytesseract
import os
import openpyxl
from solve import solve_cap
from openpyxl import load_workbook
import cv2
import time

Right now, I want to make this program available to be used in a webpage, so anyone can upload an .xls file and will recieve back the modified file, either by mail or a temporary download link.

My problem is that I do not know how I can make this happen, my websites are on wordpress, so I would like to use wordpress in future, but if needed I can change the platform.

The initial idea was to run the script in a virtual environment, create a dedicated e-mail address for the program, and have a contact form on wordpress which sends the necesarry data to the email, after that I would parse the email, take the .xls, perform the necesarry actions and send it back.

If you are running the script locally only you can just connect to your wordpress folders using FTP. — Ninad Gaikwad
– Ninad Gaikwad, Commented Sep 19, 2018 at 6:46

Dominique Barton · Accepted Answer · 2018-09-19 06:58:34Z

2

Well, Wordpress is written in PHP so that's going to be a bit of a problem. However, there are other solutions:

You rewrite it in PHP (I suppose you don't want that ;))
You use your proposed mail solution
You create a dedicated web service

I'd definitely aim for the dedicated web services. I suppose you're using it as a CLI script? In that case, you need to pack that thing in a web service. There are excellent frameworks out there, such as:

I'd check out Flask (which is using Werkzeug in the background), because it's quite simple and straight forward. Just check out their first tutorial and you can see if it fits you. Django is a bit oversized for your use case tbh ;)

From there on, I'd try this:

Put your XLS converter in a Flask project
Deploy it on your web server (via uWSGI, see the docs docs on how to deploy it on a webserver)

If you want to do more fancy and you're experienced in PHP, you can also create your own Wordpress "backend" plugin which automatically sends the XLS to your web service via POST (don't need a complicated API here).

If you only need it for the users on the front end, a normal <form action="{url of your web service}" method="POST"> is enough.

That's my two cents :)

edited Sep 19, 2018 at 6:58

answered Sep 19, 2018 at 6:45

Dominique Barton

9188 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dominique Barton Over a year ago

Here's an example to start (didn't test it): gist.github.com/domibarton/df2b7d1135c49dc99622283645f88478 You might want to read the docs, as it has a lot of code snippets / examples. Have a look at templates, static files & file uploads :)

Iura Rusu Over a year ago

Hey, thank you very much, I will look into Flask, the thing is that in order to run the script I open a webdriver, hope it supports that.

Collectives™ on Stack Overflow

Embeding Python Scripts in Wordpress

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related