25

All B2B solutions boil down to "How I import your Excel"

Comments
  • 6
    Or export to excel,
    Or macro in excel,
    Or excel.... fuck me dead so much excel, seriously I do more excel then I do anything else 😢

    I do enjoy csv to sql imports though, big data just got easy, and then export back to excel and make everyone think your the excel master 😁
  • 0
    @C0D4 One time, about 14 years ago, I was esked to make a server monitoring excel shit which sends emails ;p ;p ;p

    I was young. I did it. But no... that shouldn't exists
  • 1
    Thank God for powerbi
  • 2
    Storytime: In early 2021 I interviewed with 3 or 4 different companies, all extremely well paying and very successful, but yes, their apps all boiled down to "import or export your data into our tables or *GASP*, even import your CALENDAR data, and we'll add a layer of fun easy drag and drop logic!" yawn.
  • 2
    @tosensei CSV is not much better, fucking customers never encode them properly...
    - UTF-8 encoded ISO-8859-1 chars, sometimes the opposite
    - newlines (0x0a) within strings making most CSV parsers to read it as a new row
    - missing column spearators
    - too many column setarators
    - mixed column separators

    In the case of the newline problem, I had to write my own CSV parser with a custom state machine. I'm not a huge fan of Excel either, but at least shit like this doesn't happen there.
  • 0
    @tosensei Yeah, that's a valid point, f the customers 😄
  • 5
    Also pdf
    Fuck pdf
  • 4
    Excel: the database, programming environment and client app all in one single sharable file!
Add Comment