Hacker News new | ask | show | jobs
by cartesius13 702 days ago
Everyone does thing is stupidly inefficient ways.

For example, we need technical drawings of parts, the only way is through a web interface that fetches from some remote server and you can only do one at a time. So you will often see people copy pasting (or even typing if they're reading from paper) each item code one by one and printing one by one. Another common thing, we use SAP for most things but Excel is required for some stuff by my direct leader but also higher management and there's a lot of sort of awkward getting things out of SAP and into spreadsheets in the right format. So here some basic data manipulation is needed and you see literally everyone doing everything manually most of the time.

In general, I just want to not be wasteful and do repetitive things manually while using a computer with Windows, which is something I'm not used to

Using tool websites is a bit annoying since so much stuff is just blocked

2 comments

Assuming credentials there are many ways to browse | fetch files from remote servers that aren't web based - if you can work out a command line that accesses the remote server and logs in then file access in a batch fill or powershell script can follow.

Something in HN: CLI tools for CSV, etc. might click for you: https://news.ycombinator.com/item?id=16784850

I'd look into writing and running your own browser extension for any of the web-based stuff. Javascript is more expressive (I believe) than AHK scripts and can easily manipulate the DOM/HTML to extract and parse data, fill in fields, or even do additional remote logins and fetches -- all without anything your admin has to install.

I don't know if your SAP is a desktop app or a website, but if it's a website, you can probably transform its output (or its AJAX calls) into some other format. Not too sure how you'd get it into and out of Excel after that (maybe via API if there is one, or you can generate a VBscript and use AHK to run it in Excel?)