top 50 comments

sorted by: hot top controversial new old
[–] 173 points 1 year ago (19 children)

The client wants to drag and drop their own personalized excel file with no guaranteed formatting or column order or data contract in order to import their data into our system <3

  • source
  • hideshow 19 child comments
  • [–] 27 points 1 year ago (4 children)

    Jesus, this gave me war flashbacks.

  • source
  • parent
  • hideshow 4 child comments
  • [–] 17 points 1 year ago* (3 children)

    Please, do elaborate. Let others feast on your suffering.

  • source
  • parent
  • hideshow 3 child comments
  • [–] 8 points 1 year ago (1 child)

    May I?

    A controlling department wasn't granted any money for digitializing their workflow.

    So these guys created their own solution(s!). Things like dedicated "user interfaces" loading data from tables created by hand. After years these people realized that data formatting is quite the issue.

    They started to put random rules into different tables:

    Two empty lines: New Group Data Record. One empty line: New Subgroup Data Record.

    Excel tables aggregating this data via hardcoded links.

    A dedicated table to start calculations on parent tables.

    They mutated data like this:

    Load data from excel files into one. Manually delete, add or change lines (or columns). Start a collection run from dedicated excel file and load new excel file data and replace old excel file data.

    They had files where 'it was easier to read' when they pivot the data. This was troublesome since some values are intermediate results. Dropping one column may imply dropping another one as well.

    All workflows required manual alignments along the way.

    They were only able to process 10% of the data from a year within a year. Managing millions in cash.

    Their data input came from different internal sources. Programs which were written two decades ago once and without any tests. Talking like VB, macro's from host servers and copy-pasta data from other internal programs.

    And don't get me started on customer tables.. They created a zip-code encoded filesystem hierarchy where each customer data (you guessed it, excel file) was renamed and then saved. In each of these directories where randomly named files if something went wrong; So no actual file patterns to rely on.

    I respect them.

    They creates a diagram for their tables with word. Word! (Didn't know either: you can select the web view in the bottom right corner and you get an infitive canvas..) Madness.

  • source
  • parent
  • hideshow 1 child comment
  • load more comments (1 reply)
  • load more comments (1 reply)
  • [–] 7 points 1 year ago (6 children)

    Strangely enough we actually solved this problem with AI a few months back. We upload the excel file to Gemini and have a prompt to extract the data we need in a specific json format. And it works surprisingly well.

  • source
  • parent
  • hideshow 6 child comments
  • [–] 19 points 1 year ago (4 children)

    How well? Bet your life on it well, or "fewer hallucinations than we would have guessed" well? I've considered and toyed around with openAI models for logging supply room check offs in a JSON format and it went better than I hoped but worse than I needed.

  • source
  • parent
  • hideshow 4 child comments
  • [–] 14 points 1 year ago* (last edited 1 year ago) (2 children)

    Really well. Temp turned down all the way, and Gemini has this new feature to run and execute code.... Not function calling... It can write a small python script, run it and return the output.

    So our prompt explains the excel spreadsheet, then tell it exactly the format we need it in, and then tell it to use python and pandas to read in the CSV, clean it up and reshape it the way we need it to match what we expect and voila.

    So hallucinations are not really and issue with the data as it's simply writing code which then deterministically processes and returns the data.

    Edit to add more info: basically Gemini can create and run a lambda function on the fly. And if you're a coder you can really guide the prompt. Eg "load this into pandas. Then remove all the empty columns. Also remove the total rows. Now unpivot the data so the months are not columns but in separate rows with a column called month.

    You get the idea.

  • source
  • parent
  • hideshow 2 child comments
  • load more comments (2 replies)
  • load more comments (1 reply)
  • load more comments (1 reply)
  • load more comments (5 replies)
    [–] 145 points 1 year ago (34 children)

    I’ve been a professional software developer for over two decades. There is zero chance my job will get taken by an AI any time soon. Anyone who thinks my job is to write code doesn’t understand my job. That’s like saying a bus driver’s job is to turn a steering wheel.

    My job is to turn vague ideas and nondescript feelings into APIs and (sometimes) UIs, then turn those into specs, then split those into tasks, then sometimes I’ll write the code for them and sometimes someone else does. About 90% of my time is turning ideas into plans, and about 10% of my time is turning those plans into code.

    When I was young and was a junior engineer, my job was more to receive the specs from the senior engineers and turn that into code, but even then, I was still designing my own stuff. Maybe more like 40/60 time instead of 90/10.

    Now that I’m a grizzled old man forged in the fires of task management software, I’m doing almost all of the design work myself. I manage a project that has about 250,000 lines of code. An AI isn’t going to be able to build new features into that, let alone decide which features to build in the first place.

  • source
  • hideshow 34 child comments
  • [–] 70 points 1 year ago (12 children)

    Heh, that won't stop a C-level from thinking that you just write code.

  • source
  • parent
  • hideshow 12 child comments
  • [–] 32 points 1 year ago (9 children)

    Yeah, that’s probably true. Remember how all the execs decided to replace cashiers with robots, then the stores started losing money because a. it made stealing a lot easier and b. people would avoid stores that only had self-checkout robots and never had anyone to help you because a robot doesn’t know where the flour is. Now the self checkouts are being decommissioned and we’re going back to regular human cashiers. It turns out cashiers do more than just scan barcodes. But, upper management didn’t get to where they are by being smart.

  • source
  • parent
  • hideshow 9 child comments
  • [–] 18 points 1 year ago (4 children)

    Now the self checkouts are being decommissioned and we’re going back to regular human cashiers.

    Maybe this is North American thing because in Europe they never really got rid of human cashiers, they just had the automated systems alongside the human cashiers.

    I don't know of any store that went over to 100% self-checkout

  • source
  • parent
  • hideshow 4 child comments
  • load more comments (4 replies)
  • load more comments (4 replies)
  • [–] 9 points 1 year ago (1 child)

    It could also be possible that AI doesn't write code but becomes the new software. Hook it up to libraries, contractions, databases and pump it full of the verbatim ramblings from the client, sales guy and manager. Sure, it costs a magnitude more power to run but it's up in no time.

    Then hire a few consultants that used to be senior engineers for an outrageous amount to trace the weird hallucinations and replace the mission critical part with real code.

    The future is going to be wacko.

  • source
  • parent
  • hideshow 1 child comment
  • load more comments (1 reply)
  • load more comments (14 replies)
    [–] 64 points 1 year ago (2 children)

    No, the customer wants a button that does a very specific thing.
    He can't tell you what that is, though. You're the expert!
    Also, can you put in more ads? And make it so the users can't close the tab until they bought something.

  • source
  • hideshow 2 child comments
  • load more comments (1 reply)
    [–] 54 points 1 year ago (1 child)
    load more comments (1 reply)
    [–] 53 points 1 year ago (3 children)

    This is when the AI, in a microsecond, decided to destroy the human race.

  • source
  • hideshow 3 child comments
  • load more comments (1 reply)
    [+] 40 points 1 year ago* (last edited 1 year ago) (1 child)
    load more comments (1 reply)
    [–] 34 points 1 year ago* (1 child)

    I had a client once explain to me that his request for the 75% redesign of his mobile app would be simple because "it's just 3 pages"

    That was the exact quote

    I know that was hardly related to the post, but it reminded me of that and I needed to vent to my therapist (aka strangers on Lemmy)

  • source
  • hideshow 1 child comment
  • [–] 6 points 1 year ago

    I feel you. Just ended coding "a little special case" that resulted in dozens of files changed, all because I refused to make it with dirty hidden hack, and that was a clear-cut technical if-branching even, no vague ideas

    Talking to a client is times that amount of hurdle

  • source
  • parent
  • [–] 31 points 1 year ago (9 children)

    Button that does something? That’s too advanced for me, I’ll use a library

  • source
  • hideshow 9 child comments
  • [–] 22 points 1 year ago (3 children)

    Help, Debian has libbutton only in 1.4.3 and libdosomething is not in my repo. I compiled libdosomething from source, but now it needs libbutton >= 2.4.1 and compiling that version of libbutton fails, as my GCC and make are too old and incompatible!

    I already tried it on my other PC, but that isn't based on glibc, which makes all these dependencies even worse...

  • source
  • parent
  • hideshow 3 child comments
  • [–] 9 points 1 year ago* (4 children)

    cries in left_pad

    It's kind of astonishing how many people leaned on that library just to add fucking spaces to strings

  • source
  • parent
  • hideshow 4 child comments
  • [–] 7 points 1 year ago (3 children)

    It should be in the standard library anyway. Why the hell is it not?!

    I mean yeah, I can write my own function to do the same thing and probably I've done it at some point in some coding exercise as a beginner, but this seems like such a common thing to use, it should be in the standard library of any sane language.

  • source
  • parent
  • hideshow 3 child comments
  • load more comments (3 replies)
  • [–] 25 points 1 year ago

    You know what we, in the industry, call a detailed specification fo requirements detailed enough to produce software? Code.

  • source
  • [–] 24 points 1 year ago (3 children)

    Surprised there's no one in the comments going bat shit crazy that this was made by AI. Are we not doing that anymore?

  • source
  • hideshow 3 child comments
  • load more comments (3 replies)
    [–] 22 points 1 year ago (2 children)

    Managers about to find out the hard way that all the requirements are in the brains of those they laid off.

    I’m sure coding bootcamp and AI will turn them into leet hax0rs.

  • source
  • hideshow 2 child comments
  • load more comments (2 replies)
    [–] 22 points 1 year ago (1 child)

    presses button; nothing happens

    "Well see here! I wanted that button to do something!"

    "Oh but it did! It wasted your time as well as mine!"

  • source
  • hideshow 1 child comment
  • load more comments (1 reply)
    [–] 18 points 1 year ago (1 child)

    Whoa whoa, hold on there! You can't expect a product manager to come up with such detailed specs!

  • source
  • hideshow 1 child comment
  • load more comments (1 reply)
    [–] 18 points 1 year ago
    [–] 18 points 1 year ago (1 child)

    AI slop image, for this gag?

  • source
  • hideshow 1 child comment
  • load more comments (1 reply)
    [–] 15 points 1 year ago (7 children)

    Customer requirements are basically always “I want what my Excel sheet used to do”.

  • source
  • hideshow 7 child comments
  • load more comments (7 replies)
    [–] 13 points 1 year ago (1 child)

    AI Project Manager: Create a button on a webpage that, when clicked, displays an alert saying "Hello World!"
    AI Programmer: "What a sensible requirement! Here you go."
    AI Billing Department: "Project completed, that'll be 10 million dollars."
    Client AI Payments Department: "Sounds right, paid!"

  • source
  • hideshow 1 child comment
  • load more comments (1 reply)
    [–] 12 points 1 year ago (1 child)

    "Can we jazz it up a bit?"

    This is a real request from a real manager. They have played us for absolute fools.

  • source
  • hideshow 1 child comment
  • load more comments (1 reply)
    [–] 11 points 1 year ago* (1 child)

    "Y'know, I've been thinking... The app is missing a couple of things, like This, and That, and it should also do This after That, but not That after This, and maybe even navigate to The Other Thing after 3 Launch events, while also not doing that if the user is under a Pisces moon in the 4th Year of Wilting..."

    "So... you want a Rate the App pop-up with specific trigger conditions?"

    "What?! No! I want one of those prompts with the stars and the redirect to the Store which lets people post reviews of the app, what are you even talking about?!"

    AI Junior Dev: short-circuits

  • source
  • hideshow 1 child comment
  • load more comments (1 reply)
    [–] 9 points 1 year ago

    My wife had her first meeting with Chat Gpt today.

    She went from a random question about her job to the AI offering to taking care of her LinkedIn page, and promoting alternative positions for her.

    It feels to me the product manager is in trouble too.

  • source
  • [–] 9 points 1 year ago

    Me: I need spec -- not just trust code Manager: You always make unnecessary demands, I'm replacing you AI: I would be happy to help you, if you could provide spec? Manager: god fuckin dammit

    I honestly sometimes think to go into business myself just so I can write contracts that say "you will give us a fucking spec" and just keep billing while they fuck around not providing a spec

  • source
  • load more comments
    view more: next ›