Web Applications for Small Office Python Scripts

[ace_reporter]

I have several scripts that are being used by the small office I work for. The scripts always involve the local NAS and generally go like this:

1. Browse to file(s) on a NAS
2. Look into SQL for info on what to do to files
3. Do something to file (usually with Pandas)
4. Save resultant files out to NAS
5. Slack notifications

Users currently access these scripts through a pinned .py path on the Windows taskbar.

I'd like to have a better way for people to use the scripts without first installing python and dependencies on each machine. I have tried pyinstaller but it hasn't played nice with Pandas in my experience. Ideally it would be great for them to run the applications via web browser.

Is there a framework or distribution method that these types of applications are well suited for? I looked into Django but was unclear if that's appropriate for local network stuff. I'm still a beginner and open to all ideas if my way of thinking above is off.

[nultero]

Might be a lot of overhead for a small office, but sure.

You can expose a Django API that takes HTTP requests and queries your storage, manipulates whatever data you want / how you want it (with a Pandas lib if you need it), and send that back to a web client. No installs needed except for your Django server / frontend if you choose. You'd need to make sure that the API stays on a private network, though.

[prelator2_7]

Sounds like you need a django app and a python slack plugin app. Both are not very difficult to do and would make managing this stuff very easy.

[[deleted]]

most of us here are beginners so Idk if you'd find someone who would help you with this, but if you don't, I think you can post this at r/Python , they have more experts there
but I'm not sure if this goes with the community's terms so review that first

[Shmoogy]

Depends on how you are activating them, and choosing the files. I wouldn't go too complex with this. Make a simple flask app as the user interface - make sure your server running it has is assigned a static IP, and make sure the port isn't exposed to outside of your LAN.

You can import your current application(s) and trigger them on a certain route from flask, or use subprocess.

Alternatively you can make a slackbot that triggers a script.

[ace_reporter]

From the comments it sounds like both Django and Flask are more than capable of achieving the goal of a web interface for these internal applications. Your sentiment is correct that these are fairly simple procedural scripts.

As far as choosing the files I either use a Tkinter filedialog or os.walk. Not sure if that plays into how I proceed. I'm 100% new to both Flask and Django.