|
My place had an Excel macro doing barcode generation for them in one department. One day 6 months ago the guy who made the sheet quit and within a week the macro quit working and they just shrugged their shoulders and stopped using barcodes. This came back and bit them in the rear end at the next internal audit so my boss loans me out like the cheap trick I am, I get it sorted in six minutes, and strongly recommended they don't use Excel for this. I'll probably be back fixing that macro again before Halloween.
|
#
?
Oct 8, 2018 15:57
|
|
|
|
| # ? Apr 20, 2024 03:53 |
|
|
Arquinsiel posted:Someone in my company has been emailing all the staff that have access to them asking for feedback. Apparently "we don't use them because they are impractical for our purposes" was not the desired feedback. I used a Pro 3 and 4 for a long time and didn't really like them. They really fell down when it came to the dock. About one in four times, things wouldn't come back right or wouldn't work. This was on both the old slidey-dock and the newer brick. That said, we've probably got about 10 total devices, some Pro 4s and some old SurfaceBooks, and most of the people who have them love them. I dunno, maybe the Pro 6 will be a non-turd.
|
|
#
?
Oct 8, 2018 16:19
|
|
|
AlternateAccount posted:I used a Pro 3 and 4 for a long time and didn't really like them. They really fell down when it came to the dock. About one in four times, things wouldn't come back right or wouldn't work. This was on both the old slidey-dock and the newer brick.  Works fine as an office laptop replacement with a dock and a bunch of monitors, but our regular laptops are poo poo anyways.
|
|
#
?
Oct 8, 2018 19:54
|
|
|
tactlessbastard posted:My place had an Excel macro doing barcode generation for them in one department. One day 6 months ago the guy who made the sheet quit and within a week the macro quit working and they just shrugged their shoulders and stopped using barcodes. tell your boss to fix it properly without involving you a strong recommendation will do nothing.
|
|
#
?
Oct 9, 2018 16:37
|
|
|
AlternateAccount posted:I used a Pro 3 and 4 for a long time and didn't really like them. They really fell down when it came to the dock. About one in four times, things wouldn't come back right or wouldn't work. This was on both the old slidey-dock and the newer brick. If the Surface's weren't so goddamn unreliable I'd consider them to be actually quite nice, but no we get a nice array of; digitizer issues, clip on keyboard issues, power up issues, BIOS issues, bricking issues, old ones use the monolith dock new ones use the crappy cable brick. So then we changed over to Dell XPS's which have CPU overheating/throttle issues 
|
|
#
?
Oct 10, 2018 10:02
|
|
|
Super Slash posted:If the Surface's weren't so goddamn unreliable I'd consider them to be actually quite nice, but no we get a nice array of; digitizer issues, clip on keyboard issues, power up issues, BIOS issues, bricking issues, old ones use the monolith dock new ones use the crappy cable brick. I desperately wanted to like mine, I used the 3 and 4 for about two years total before it just got to be way more hassle than it was worth :\ I'll still order a 6 for "testing" and evaluation, tho. Kinda interested to see where the hardware's gotten to.
|
|
#
?
Oct 10, 2018 17:09
|
|
|
I'm gathering I'm lucky a bit that my aging 3 regularly is chugging along daily? It does something hard reboot worthy once in a while is about it.
|
|
#
?
Oct 10, 2018 17:21
|
|
|
LethalGeek posted:I'm gathering I'm lucky a bit that my aging 3 regularly is chugging along daily? It does something hard reboot worthy once in a while is about it. We have half a dozen or so people on 3s who are quickly developing a COLD DEAD HANDS mentality about replacing them.
|
|
#
?
Oct 10, 2018 17:47
|
|
|
Cold dead hands the surfacebook form factor. Laptop in the streets, tablet in the sheets.
|
|
#
?
Oct 10, 2018 19:27
|
|
|
"I'm trying to change the default application for .txt and it's not staying after I logoff." "What are you trying to change it to?" "Excel" eeeeeeeeeeeeeeeeeeeeeeeee
|
|
#
?
Oct 10, 2018 22:10
|
|
|
AlternateAccount posted:We have half a dozen or so people on 3s who are quickly developing a COLD DEAD HANDS mentality about replacing them. incoherent posted:Cold dead hands the surfacebook form factor. Laptop in the streets, tablet in the sheets. The new little surface they are always advertising on NFL games is the S3 all over again. Looked to see if it was any faster but only a tiny bit. If I was super married to keeping mine that'd work.
|
|
#
?
Oct 10, 2018 22:28
|
|
|
hihifellow posted:"I'm trying to change the default application for .txt and it's not staying after I logoff." 
|
|
#
?
Oct 10, 2018 22:31
|
|
|
hihifellow posted:"I'm trying to change the default application for .txt and it's not staying after I logoff." csv file saved as txt that he uses often?
|
|
#
?
Oct 10, 2018 22:41
|
|
|
hihifellow posted:"I'm trying to change the default application for .txt and it's not staying after I logoff."
|
|
#
?
Oct 10, 2018 23:13
|
|
|
nexxai posted:One thing I discovered recently is that if you open a CSV in Excel and don't Save As a UTF-8 CSV format, it ends up saving as a tab-separated TXT file. I don't know what the gently caress happened, whether MS changed something in Office or if I'm a loving retard (or both; probably both) but I can kind of understand it if this person deals with a lot of CSVs. This is probably the case (he's trying to do the same with .csv), but it doesn't stop my Excel PTSD from flaring up.
|
|
#
?
Oct 11, 2018 01:44
|
|
|
hihifellow posted:"I'm trying to change the default application for .txt and it's not staying after I logoff." nexxai posted:One thing I discovered recently is that if you open a CSV in Excel and don't Save As a UTF-8 CSV format, it ends up saving as a tab-separated TXT file. I don't know what the gently caress happened, whether MS changed something in Office or if I'm a loving retard (or both; probably both) but I can kind of understand it if this person deals with a lot of CSVs. Interestingly I used to do customer support for a product that did mass export/import of users in an online portal type environment using these types of tab-separated text files, and only these files. Never figured out why though.
|
|
#
?
Oct 11, 2018 04:43
|
|
|
I'm not down with OPP (other people's programming) Today I superseded forty .bat files that each contained the global admin password in plain text with a single powershell script.
|
|
#
?
Oct 11, 2018 05:23
|
|
|
Ghostlight posted:Today I superseded forty .bat files that each contained the global admin password in plain text with a single powershell script. 
|
|
#
?
Oct 11, 2018 05:41
|
|
|
Ghostlight posted:I'm not down with OPP (other people's programming) Tell me your powershell script doesn't also contain the admin password in plaintext.
|
|
#
?
Oct 11, 2018 05:45
|
|
|
Entropic posted:Tell me your powershell script doesn't also contain the admin password in plaintext.
|
|
#
?
Oct 11, 2018 06:26
|
|
|
I had a hell of a time with ConvertFrom-SecureString a few weeks ago, but surely everyone's using ConvertTo.
|
|
#
?
Oct 11, 2018 07:19
|
|
|
Entropic posted:Tell me your powershell script doesn't also contain the admin password in plaintext.
|
|
#
?
Oct 11, 2018 07:36
|
|
|
nexxai posted:One thing I discovered recently is that if you open a CSV in Excel and don't Save As a UTF-8 CSV format, it ends up saving as a tab-separated TXT file. I don't know what the gently caress happened, whether MS changed something in Office or if I'm a loving retard (or both; probably both) but I can kind of understand it if this person deals with a lot of CSVs. Excel saving CSVs as tab separated files is one of the banes of my existence. The other is Excel removing leading zeros from CSVs when you open them.
|
|
#
?
Oct 11, 2018 12:40
|
|
|
Kurieg posted:The other is Excel removing leading zeros from CSVs when you open them. This poo poo infuriates me when it happens.
|
|
#
?
Oct 11, 2018 13:07
|
|
|
Proteus Jones posted:This poo poo infuriates me when it happens. aaaaaargh One of the codes I work with is 2 numbers, the letter E, then 3 numbers. Excel loves turning that into scientific notation. Switching the cell format to plain text only works about half the time. The worst part is that it turns 10E101 into 1.00E+102, since the last digit is changed you can't even get an idea of what the right thing is at a glance.
|
|
#
?
Oct 11, 2018 13:17
|
|
|
Ah, Excel and CSV. Sigh.
|
|
#
?
Oct 11, 2018 14:49
|
|
|
That poo poo is evil, every single time I want to close out I get stuck in a loop thinking I've not saved properly and check it over until about the third attempt.
|
|
#
?
Oct 11, 2018 16:23
|
|
|
Super Slash posted:That poo poo is evil, every single time I want to close out I get stuck in a loop thinking I've not saved properly and check it over until about the third attempt. It gets me stuck in a loop where I just smash yes on everything, then I don't notice when it says something different. Then I call IT and claim I didn't touch anything it just magically stopped working and WHAT DO WE PAY YOU FOR
|
|
#
?
Oct 11, 2018 16:49
|
|
|
Excel desperately needs an "ID Number" format.
|
|
#
?
Oct 11, 2018 17:05
|
|
|
Renegret posted:It gets me stuck in a loop where I just smash yes on everything, then I don't notice when it says something different. i don't understand people who just mash OK on computer popups like i literally watch it happen in front of me, or people who ask me if it's OK to click next on a screen where the only options are next and cancel... I genuinely don't understand how they're not even bothering to read what their computer is desperately flashing in their faces.
|
|
#
?
Oct 11, 2018 17:14
|
|
Cat Army 
|
The owner of our company wants a floor to ceiling, edge to edge whiteboard with no seams in one of our conference rooms. Then one on the opposite wall in that room as well. I'm not sure what in the hell this has to do with IT, but here we are I guess.
|
|
#
?
Oct 11, 2018 17:16
|
|
|
They think dialog boxes only show obscure computer errors that are for the consumption of and interpretation by techies only. Normal people should never have to see a dialog during normal use of an app. Is what I think the mindset is
|
|
#
?
Oct 11, 2018 17:16
|
|
|
siggy2021 posted:The owner of our company wants a floor to ceiling, edge to edge whiteboard with no seams in one of our conference rooms. Then one on the opposite wall in that room as well. Hope you have your repainting guy on speed dial for the other two walls
|
|
#
?
Oct 11, 2018 17:17
|
|
|
siggy2021 posted:The owner of our company wants a floor to ceiling, edge to edge whiteboard with no seams in one of our conference rooms. Then one on the opposite wall in that room as well. We had one in our old office, right behind where the SMEs sat, and it rocked. But facilities installed it. And it wasn't a board as much as it was a special paint and treatment to the wall.
|
|
#
?
Oct 11, 2018 17:19
|
|
|
Proteus Jones posted:We had one in our old office, right behind where the SMEs sat, and it rocked. We have one of those installed in our conference room. I had no idea it was installed, it was just done quietly over the course of a few days when I was out. One day I went there and someone started scribbling on the wall with a marker and I nearly had a heart attack. It's cool as h*ck though once you get over the completely built in childhood fear of not scribbling on the walls under threat of getting your rear end beat by mom.
|
|
#
?
Oct 11, 2018 17:22
|
|
|
Yeah after looking into it I saw the dry erase white paint and I am considering pitching that to them. I have a feeling they are going to be adamant about wanting an actual board, though. I don't really understand the floor to ceiling concept. Is someone going to be laying on the ground writing at the bottom? Is someone going to stand on a chair to write on the top? If the space isn't going to be utilized then why bother?
|
|
#
?
Oct 11, 2018 18:10
|
|
|
They don't want a seam/border. That's it.
|
|
#
?
Oct 11, 2018 18:24
|
|
|
The Macaroni posted:Ah, Excel and CSV. Sigh. Open office handles CSVs much better. It will pop up a preview screen that lets you choose the encoding, separation character, and format for each column.
|
|
#
?
Oct 11, 2018 18:59
|
|
|
The whiteboard paint is cool, but for some reason people LOVE using it on dark walls. There's like 4 markers that are actually visible on a dark wall, and only for the first few minutes before they dry out and become useless. Also you have to sand the wall REALLY well or erasing anything becomes a huge chore.
|
|
#
?
Oct 11, 2018 19:14
|
|
|
|
| # ? Apr 20, 2024 03:53 |
|
|
ponzicar posted:Open office handles CSVs much better. It will pop up a preview screen that lets you choose the encoding, separation character, and format for each column. Excel does that too.
|
|
#
?
Oct 11, 2018 20:11
|
|
