Hacker News new | ask | show | jobs
by jellyfishbeaver 987 days ago
Large/medium businesses, too. In finance, we receive countless reports from 3rd parties. I can't tell you how many of them still rely on person A to manually log into our FTP server at a specific time every day and drop an Excel file into a folder. Sometimes it goes on like this for years. I always wonder if that person ever gets sick.. goes on vacation..
3 comments

A scary amount of the finance world runs on batched csv and whatever those || column deliminited files are called, just being FTPd around, processed in batches. Which then trigger more FTP and more file processing.
A long ago company I worked for that subsequently went through a couple of acquisitions still basically had one person in finance somewhere who was basically who you contacted for anything related to our defined benefit pension. I assume the bus factor wasn't literally one as there were legally required annual statements etc. but I assume there would have been some manner of chaos if this person from a no longer existing company wasn't there one day. (About 7 years ago, the benefit administration--now a responsibility of Dell's--transitioned to one of the big benefit administration companies; OI expect the person who had been handling it retired.)
I remember a friend whose company allegedly was putting money from their paycheck into some kind of retirement plan, but there was never any documentation showing where that money went. It was skettttttch
Yeah, I've seen stuff like that in my role as a system integrator. We've built all these automated processes for transforming and moving data from system A to system B, but occasionally we learn about other teams who are using excel and VBA for everything. It's very strange.