In other news today...
-
@kazitor oh I don’t fault them, it’s just at the same time it kinda ties my hands in what I can do to appease the dark and vengeful god that is “business requirements” when they ask for a real CSV that is correct (even with leading zeros) and Excel breaks it thus it “fails testing”.
-
@Arantor If I'm actually serious about moving data about, I'll slap it jnto a database (probably SQLite) because then I can have more than one table and some actual metadata too. And Excel can't sabotage it so easily...
-
My one natural enemy is going for my favourite sweets!
-
@Tsaukpaetra said in In other news today...:
@dkf said in In other news today...:
@Arantor The easiest way to deal with that is to give the filename a custom extension so that it isn't so easy to load into Excel with just a double click. Our good old favourite
.dat
would do great for this.I'm partial to .BIN myself.
.BIN there, done .DAT?
-
@DogsB said in In other news today...:
My one natural enemy is going for my favourite sweets!
They may not all be quite as smart as Yogi, but even the dumbest bear knows to steer clear of candy corn and circus peanuts.
-
@Zecc said in In other news today...:
@Tsaukpaetra said in In other news today...:
@dkf said in In other news today...:
@Arantor The easiest way to deal with that is to give the filename a custom extension so that it isn't so easy to load into Excel with just a double click. Our good old favourite
.dat
would do great for this.I'm partial to .BIN myself.
.BIN there, done .DAT?
.WAV-ed and .SND-ed it out. It was a good .RIFF
-
@DogsB
Even bears are polite when stealing
-
@Arantor said in In other news today...:
@dkf said in In other news today...:
@Arantor The easiest way to deal with that is to give the filename a custom extension so that it isn't so easy to load into Excel with just a double click. Our good old favourite
.dat
would do great for this.“But then it’s not a CSV file?”
Yes, I know people that genuinely believe changing the extension mysteriously changes the content.
Or they'll just associate that new file extension with Excel.
-
@dcon that seems like a fairly high bar to clear from the folks I’ve dealt with in this particular world.
-
@dcon said in In other news today...:
@Arantor said in In other news today...:
@dkf said in In other news today...:
@Arantor The easiest way to deal with that is to give the filename a custom extension so that it isn't so easy to load into Excel with just a double click. Our good old favourite
.dat
would do great for this.“But then it’s not a CSV file?”
Yes, I know people that genuinely believe changing the extension mysteriously changes the content.
Or they'll just associate that new file extension with Excel.
Which would probably be the best approach to solve the issue in an Enterprise (read as: domain or Intune managed) environment really… just get the System Admin team to enforce .csv files being associated with Notepad and Robert is your mother’s brother.
-
@izzion then you'll get the users who bitch that they changed it to Excel but it keeps getting reset to Notepad.
-
@loopback0 said in In other news today...:
@izzion then you'll get the users who bitch that they changed it to Excel but it keeps getting reset to Notepad.
Sounds like an escalation to HR
-
@izzion Does that prevent right click -> open with -> Excel? Maybe prevents (or overwrites "always use this program", but opening it once is enough.
-
@HardwareGeek said in In other news today...:
@izzion Does that prevent right click -> open with -> Excel? Maybe prevents (or overwrites "always use this program", but opening it once is enough.
Since it appears that my posts seem to have been taken as serious...
-
I haven’t drunk beer in years but this feels wrong on so many levels.
-
@Arantor Still not as bad as vagina beer.
-
@izzion
And to actually be somewhat serious...I think often, technical people go too far trying to find a technical solution to what is, ultimately, a human problem. Nature will always invent a better idiot, so technical steps should be restricted to what would stop a reasonable person from doing something broken, such that when someone does break your mouse trap you can say "hey you did a non supported thing, stop being stupid" and leave it in their lap.
So in this case, I'd do some combination of:
- Mark the file as read-only before sending it to the users who are verifying it.
- Enforce associating .csv with not-Excel via enterprise means
And then when someone inevitably mangles a CSV file with Excel anyway, that's a them problem. And if they're too noisy about it being a me problem, I can escalate to their manager or HR with "hey, they deliberately circumvented the controls we've put in place to keep them from opening this file in Excel and saving over it, you need to instruct them to not do that"
-
@Atazhaia said in In other news today...:
@Arantor Still not as bad as vagina beer.
I miss five minutes ago when I hadn’t read this.
-
@topspin said in In other news today...:
@Atazhaia said in In other news today...:
@Arantor Still not as bad as vagina beer.
I miss five minutes ago when I hadn’t read this.
It was posted here somewhere ages ago.
In other news, I also miss five minutes ago when I had forgotten about this fact.
-
@izzion said in In other news today...:
I think often, technical people go too far trying to find a technical solution to what is, ultimately, a human problem.
Yep.
So in this case, I'd do some combination of:
- Mark the file as read-only before sending it to the users who are verifying it.
- Enforce associating .csv with not-Excel via enterprise means
Still sounds like too much effort. Slapping a different extension on it and hiding it in Sharepoint will do. The users will never find it once they lose the link you send...
-
@Tsaukpaetra said in In other news today...:
@dkf said in In other news today...:
@Arantor The easiest way to deal with that is to give the filename a custom extension so that it isn't so easy to load into Excel with just a double click. Our good old favourite
.dat
would do great for this.I'm partial to .BIN myself.
.worm.exe
-
@izzion yeah, some squishy human problems will never be solved. No Silver Bullets is interesting to read even now. Most of the technical problems were solved but technical solutions to squishy human problems have made things worse.
-
@Arantor said in In other news today...:
I haven’t drunk beer in years but this feels wrong on so many levels.
Reminds me of https://silverscreenbottling.com/nuka-dark-rum/
For those who don't remember: the bottle is not even rocket-shaped, it's a normal glass bottle in a plastic "sleeve".Except that Bethesda version actually made lore sense in-universe (Nuka Cola was a shitty company known for its shitty products) and out-universe (Fallout 76 was a shitty mess and tie-in merchandise matched).
What is Tesla's lore?
-
-
@boomzilla said in In other news today...:
@Kamil-Podlesak said in In other news today...:
What is Tesla's lore?
"Our cars are cool."
“Sharp angles that would embarrass 80s “neo future” designers are cool.”
-
-
@boomzilla said in In other news today...:
@Kamil-Podlesak said in In other news today...:
What is Tesla's lore?
"Our cars are cool."
"Except when they're on fire!"
-
@HardwareGeek said in In other news today...:
@boomzilla said in In other news today...:
@Kamil-Podlesak said in In other news today...:
What is Tesla's lore?
"Our cars are cool."
"Except when they're on fire!"
That's just the post-global-warming definition of cool
-
-
@HardwareGeek said in In other news today...:
@boomzilla said in In other news today...:
@Kamil-Podlesak said in In other news today...:
What is Tesla's lore?
"Our cars are cool."
"Except when they're on fire!"
-
Unexpected findings were recorded by pyrotechnicians during the survey of the route of the future Prague ring road, between the D1 highway and Běchovice. For example, they came across agricultural magnets. "The magnetometer detects them, they have a signal like a grenade or a large bomb,"
…
Magnets about eight centimeters in size are thrown into the cows' feed in order to bind to themselves everything metal that the cow eatsandso it does not injure it, i.e. various screws, nails, but also wires when they are fed, for example, leftovers from hopplantsplantations.TIL.
-
@Bulb said in In other news today...:
bind to themselves everything metal
The magnets will not bind to brass, aluminum, or other non-ferrous metals. Also, not to most stainless steel alloys.
-
What was the point of buying them then? You need content. I suppose drip feeding it might work.
-
Not hard and fast but general rules of thumb for purchasing software:
If your IT staff need assistance parsing the licensing agreement you’re heading for trouble.
If every interaction requires a member of sales you’re heading for trouble.
If the sales pitch includes community support you should stop engagement immediately.
Its usually easier and cheaper to hire more admin staff to do admin than it is to purchase a new system and force the admin on the rest of the company.
Oracle is never the answer.
-
-
@DogsB said in In other news today...:
Not hard and fast but general rules of thumb for purchasing software:
If your IT staff need assistance parsing the licensing agreementyou’re heading for trouble.
If every interaction requires a member of sales you’re heading for trouble.
If the sales pitch includes community support you should stop engagement immediately.
Its usually easier and cheaper to hire more admin staff to do admin than it is to purchase a new system and force the admin on the rest of the company.
Oracle is never the answer.Simplified version.
-
@Zecc said in In other news today...:
@DogsB said in In other news today...:
Oracle is never the answer.
Depends on the question.
The only acceptable questions for this answer:
- which software vendor has TDWTF collectively formed a hate club around?
- which software vendor mercilessly killed Sun Microsystems to acquire MySQL, VirtualBox and Java amongst other things?
- which company is informally known as Big Red?
- which company is informally known as Orrible?
- which company has a pricing scheme so predatory it is often jokingly referred to as “Larry needs another yacht”?
I will permit directly related questions to the above, e.g. “who owns MySQL”.
-
@Zecc said in In other news today...:
@DogsB said in In other news today...:
Oracle is never the answer.
Depends on the question.
"What is the primary reason for wanting The Big One to come and wipe SF and the Bay off the map?"
-
@HardwareGeek said in In other news today...:
@Bulb said in In other news today...:
bind to themselves everything metal
The magnets will not bind to brass, aluminum, or other non-ferrous metals. Also, not to most stainless steel alloys.
Do you expect communist Czeskoslovensko to have had such modernish alloys?
-
@BernieTheBernie Brass isn't a modern alloy, it is literally older than steel. And some stainless steel did make rounds and wasn't even bad. But I don't think farming machinery ever used either, and nor is baling wire made of them, so they are not a concern.
-
@Arantor Although, they did give the development of Java a well needed and very solid kick in the arse.
-
@Carnage said in In other news today...:
@Arantor Although, they did give the development of Java a well needed and very solid kick in the arse.
Repeat after me: we do not issue compliments to Oracle around here.
Do not make me make you write it 200 times by hand.
-
@Carnage said in In other news today...:
@Arantor Although, they did give the development of Java a well needed and very solid kick in the arse.
It was a solid kick indeed. Java is still butthurt from it.
-
@Bulb said in In other news today...:
@Carnage said in In other news today...:
@Arantor Although, they did give the development of Java a well needed and very solid kick in the arse.
It was a solid kick indeed. Java is still butthurt from it.
I'm not sure Java devs can claim being butthurt -- after all, they voluntarily self-sodomize.
-
@dkf said in In other news today...:
"What is the primary reason for wanting The Big One to come and wipe SF and the Bay off the map?"
Learn to swim, I'll see you down in Arizona bay
-
@izzion said in In other news today...:
I'm not sure Java devs can claim being butthurt -- after all, they voluntarily self-sodomize.
Whom did that ever stop?
In somewhat more serious note, most companies out there were rather pissed by the new Oracle licensing terms and have since banned the Oracle builds of Java from any and all systems they could and stick to the open-source builds since.
-
@izzion said in In other news today...:
@Bulb said in In other news today...:
@Carnage said in In other news today...:
@Arantor Although, they did give the development of Java a well needed and very solid kick in the arse.
It was a solid kick indeed. Java is still butthurt from it.
I'm not sure Java devs can claim being butthurt -- after all, they voluntarily self-sodomize.
Sounds like some people are jealous of the enterprise dev gravy train.
-
@Bulb said in In other news today...:
In somewhat more serious note, most companies out there were rather pissed by the new Oracle licensing terms and have since banned the Oracle builds of Java from any and all systems they could and stick to the open-source builds since.
That's been one of the good things out of all that, being able to get builds from elsewhere. Don't need Oracle's weirdo expensive enterprise Java features, not when I can use the one from Adoptium without problems.
-
@dkf said in In other news today...:
@Zecc said in In other news today...:
@DogsB said in In other news today...:
Oracle is never the answer.
Depends on the question.
"What is the primary reason for wanting The Big One to come and wipe SF and the Bay off the map?"
Nah, this is just a secondary reason, but the primary reason is , so for this thread, it's good enough.
-
@Arantor said in In other news today...:
@Carnage said in In other news today...:
@Arantor Although, they did give the development of Java a well needed and very solid kick in the arse.
Repeat after me: we do not issue compliments to Oracle around here.
Do not make me make you write it 200 times by hand.
That's not punishment. Have him use his penis instead.