Re: Divers log
damn your eyes! I thought I'd have a quick look at that and I haven't got past the adverts yet!
I'll have to keep it for after hours.
52 publicly visible posts • joined 23 Apr 2016
I know the cause here is not clear but it may be that the sender didn't send a master sheet or hidden worksheets and did what you suggested with a new document but they still include the extra information unwittingly.
In the PSNI case it appears they used a pivot table to select the requested information and then pasted that into a new workbook and sent that. What they didn't realise it that in pasting the pivot table, it could be 'unpacked' and allow access to all the data behind it, including the fields not displayed or requested.
I know whereof I speak because someone once sent me a file in similar circumstances and then nearly filled their pants when I pointed out that they'd not only sent me the staff grades I'd asked for but also the names, NI, DoBs, etc of 22k staff from the CEO down
This will have been down to pasting the contents of an excel pivot table where the extra data was embedded and hidden but easily retrieved. It likely would have been reviewed but that only helps if the person(s) reviewing the data know to look for that error
Also the site posting the info is an FOI site (WhatDoTheyKnow) who receive the file straight from the responder and would have had no reason to expect that the data was not kosher
I'd imagine it's more likely that they used a pivot table to select the data requested in the FOI but then when they copied that informaton to send it on they just used PASTE (CTRL+V) instead of using PASTE VALUES. That meant that the full dataset was embedded in the table and could be uncovered with a few clicks, even if the table had been pasted into a fresh excel workbook
It happened to me where I made an internal request for the numbers of staff at different grades in different roles (the same request as was made in the recent PSNI leak), but noticed the file was far bigger than I would have expected. A couple of clicks later I found I had also been sent the names, dates of birth and National Insurance numbers for all 20K staff in our organisation, all the way up to the CEO. I resisted the temptation to start selling on the Dark Web
hahaha! seriously i have seen people store physical files on top of waste bins by their desks and then get confused/upset when it gets dumped. Equally people also get upset when genuine rubbish isn't removed because they balance it on top of the bin instead of in it, the cleaning staff haven't learned NOT to remove it after the last b0ll0cking they got.
"I've dealt many times with someone complaining they've run out of disk space, then looked in the Recycle bin to find hundreds of thousands of files/folders in there."
But how many times have we seen a story here where the IT bod then goes on to helpfully delete all those files only for the user to ask where the documents from their 'storage' folder went?
You're obviously more conscientious though and tell them what you're going to go, and the consequences, before you empty it.
Too true! I've just been informed of a recent incident at one of our hospitals where a visiting company rep removed a laser filter from an operating microscope to use in another device, without telling anyone, so their foul. But the situation was exacerbated by two doctors subsequently using the microscope who saw a flash from the laser where there shouldn't have been one during a case. In order to confirm there was a fault they fired the laser again whilst both continuing to look through the microscope! It's hoped that the eye damage sustained won't be permanent.
This drove me mad for years but there is a way around it, IF (big IF) you can find the email by a search. Once you find it, open it, click on the body, type CTRL+SHIFT+F to bring up advanced find and then you can search back through BROWSE on the top right to locate the folder
Still buggered if you can't find the email at all though!
And please don't shout at me if everyone knows this. I discovered it a year ago and I'm still chuffed, even when using it every day
"I now how really insecure those cheap safes are."
as are safes and filing cabinets at ultra top secret atomic bomb projects if you read Richard Feynman's memoir, "Surely You're Joking Mr Feynman"
Spoiler
.
.
.
.
.
change the factory default combination numbers before use, but read it anyway, he tells it better
we had an outage at one of our major hospitals when the mains power supply went down after the supplier lost a transformer external to the site. No generator you ask? Oh yes, estates had those and tested regularly, but only under a brown-out condition with the mains still available and not a black test with no external power.
And that's when they discovered that the battery packs necessary to kickstart the gennies were all expired so they couldn't start automatically. It took fifteen minutes to get someone in to restart them manually but you can bet the testing SOP was rewritten very quickly afterwards
well why didn't you do that from the start?
Oh yes, because it'll have been one of those systems that has lots of requirements for your password such as letters AND a number, or at least one upper case, but doesn't tell you that beforehand and instead waits until you get the first attempt wrong and then points out only one mistake!
however... in Trials of an Expert Witness, Harold Klawans, a neurologist, talks about being called in to consult on a case that was somewhat similar.
A hospital porter had been tasked to taking a patient to theatre for surgery. He didn't notice that she had a respiratory arrest and that she stopped breathing for a time. It was spotted by someone else and she was resuscitated but the respiratory centre of her brain was damaged so she was conscious and unaffected cognitively but couldn't breathe without a ventilator. This meant she ended up staying in ICU for some months. As she was awake and aware she got fed up with crosswords and knitting so she asked for a TV which the hospital were only too happy to supply as they were facing a lawsuit from her for their staff member's negligence.
The TV was brought by a porter who had recently been taken off patient transport duties due to his lack of clinical awareness and unwillingness to be retrained in CPR. He brought it to her room, and seeing she was asleep thought it would be a nice surprise for her if he plugged it in so it'd be on for her when she awoke. So what medical equipment did he disconnect to plug in the TV? Yes, it was her ventilator and this was back in 1974 so the machine was not designed to alarm if unplugged. And yes, it was the same porter who'd failed to notice her problem in the first place
at least your MRI did shut down. In this report the kill switch had been disconnected so the two staff in question had to suffer entrapment for several hours until a GE engineer came to shut the system down
https://medicaldialogues.in/ge-pays-rs-1-crore-settlement-to-technician-who-got-stuck-in-mri-at-tata-memorial/
Maybe I'm missing something but is there a reason that the pdf is formatted with a permanent two page layout making it really awkward to read, instead of a single page layout? Is this indicative of how we can expect any digital innovation to proceed, with poor consideration of the end user?
There have been safety alerts issued in the past for curtain rail systems used in healthcare settings where fitters have not followed the manufacturer's instructions because the installation was obvious. The problem has been that the rails in question were anti-ligature systems, designed to drop under a light load so that patients can't hang themselves, Unfortunately some installers would take one look at the set-up and say, "that'll never hold, I'll just put a few extra screws in there to keep that up", with subsequent fatal consequences
I work in the NHS and asked our IT department to install a PC interface card for a thermometer calibrator in a theatre area. I could have done it myself and had done in the past but this time I thought I'd do it by the book. I checked a couple of days later and the nurse I'd liaised with said they'd come out but the guy said it wouldn't fit. Knowing it would as I'd checked it myself previously, I rang them up and got the techie himself who'd been out.
"It's too tall" he said
"It's a low profile case, did you try turning it sideways?"
He grumpily said he'd come out later, but then a few moments later launched into a tirade, calling me a cheeky bastard and the like, before slagging off his supervisor. I was rather startled at this but then realised he'd hung up my end of the call but not his and was still using his headset and talking to the rest of the helpdesk office
The trouble with English is that it's a complete packrat of a language - it has vocabulary and grammar from quite a few other languages grafted onto the fairly simple Germanic roots until the end result is more like a hazel thicket than a mighty oak tree..
hence the famous quote from James Nicoll oft used to silence those who complain that no one speaks "proper" English any longer
"The problem with defending the purity of the English language is that English is about as pure as a cribhouse whore. We don't just borrow words; on occasion, English has pursued other languages down alleyways to beat them unconscious and rifle their pockets for new vocabulary."
MRI scanners usually also have a Big Red Button so they can be shut down in an emergency. As use of this subsequently costs £10K+ to replenish the helium that is vented off and it takes several days to recalibrate it is normally protected by a molly-guard. but sometimes the button is just disconnected as in this case where an acute incident was prolonged by hours whilst they waited for an engineer to shut down the system
https://medicaldialogues.in/ge-pays-rs-1-crore-settlement-to-technician-who-got-stuck-in-mri-at-tata-memorial/
"he worst are people who have never been shown even how to log in without using the mouse to get from the user name box to the password box."
I've had a rep as an IT guru in various NHS settings over the years for knowing esoteric maneuvers such as CTRL-Z and CTRL-V, and no I don't work in ICT