|
Re: Coronavirus
Quote:
Originally Posted by Damien
Appranrtly they had the database in Excel. Not sure if that means they had some of interface on top of Excel or where literally just using Excel itself.
|
What the whatting what?
Quote:
The problems are believed to have arisen when labs sent in their results using CSV files, which have no limits on size. But PHE then imported the results into Excel, where documents have a limit of just over a million lines.
The technical issue has now been resolved by splitting the Excel files into batches.
|
https://www.dailymail.co.uk/news/art...el-glitch.html
Glitch, my arse - who in (insert appropriate diety’s here) name uses a million+ line spreadsheet, besides complete amateurs? I spent most of the last 20 years getting home-grown systems off spreadsheets and migrated to ‘proper’ IT systems, because the spreadsheets tend to have no documentation, ownership, or resilience.
This is NOT an IT glitch. It’s using a spreadsheet to do the job of a database. It’s not fit for purpose. It’s trying to hammer a nail in with a roll of sandpaper; the tool doesn’t suit the job.
__________________
Thank you for calling the Abyss.
If you have called to scream, please press 1 to be transferred to the Void, or press 2 to begin your stare.
If my post is in bold and this colour, it's a Moderator Request.
Last edited by Hugh; 05-10-2020 at 16:05.
|