• @[email protected]
    link
    fedilink
    524 hours ago

    Reminds me of my first big success at work. There was a weekly report that people wanted generated - it showed how much like each operator had done, how much each warehouse had shipped, how many orders we lost from stock issues, etc. it was a low tech company, so they had someone going through the limited UI, looking up each thing one at a time, copying it into excel, and making the report that way. It took hours, and was error prone from stuff like mis-pasting or accidentally skipping a user.

    Took a look at it and was like you could definitely automate this. Used some very primitive scripting to pull all the info out of the system’s UI and dump it into a TSV. Took like a couple minutes to run it, import into excel, and add the colors. But it was super janky because it was manipulating the UI like a user instead of, like, directly querying whatever underlying data store it was running on.

    Still, management was impressed. I later learned no one actually looked at the report most weeks, so that took some of the wind out of my sails.

    • mesa
      link
      fedilink
      English
      523 hours ago

      Yeah gotta love that report that takes an exorbitant amount of time to make…which is no longer used/only used for a tiny bit each year.