You just need an HTML file with a table in it (which can be named with an .xls extension) and Excel (or LibreOffice) will automatically convert it into rows and columns.
(File this under things nobody will ever do.)
- have a board outside the door listing which sections or products – bread, toilet rolls etc. – are completely sold out. Have a column indicating roughly when you expect to restock the section.
- large map of the supermarket aisles posted outside entrance / in car park. New or less frequent customers can familiarise themselves with the map before they enter, so they do not get confused or unnecessarily interact with other customers while shopping.
- if entrance has two sets of automatic doors, make one enter only and one exit only
- sell toilet rolls in smaller pack sizes (1,2,4 etc.) not 16, 24 – to make it easier for people who don’t need or want large packs.
- have a staff member whose job it to sanitise handles of shopping baskets or trolleys throughout the day
- purchase UV lamps for each store, to inspect surfaces for germs (staff will need some basic safety training before using these)
- hand washing station for customers, specifically before/as they enter the store
- plastic partitions to help protect (and to an extent, reassure) checkout staff, as have already been used in some countries
- UK Finance (formerly the UK Cards Assocation) to consider raising the £30 contactless limit, to reduce times necessary for customers to touch pin pads
- Add on screen messaging reminding customers to clean hands after using self-checkout machine or PIN pad. Log frequency of use per checkout, so if staff have limited time, they can clean areas most likely to be infected, and reset the counter
- coordinated, staggered elderly / key worker staff hours, so they’re available on different times/days at different supermarkets, not the same time everywhere, to help those working varying shifts or relying on public transport.
- A list of these times to be maintained centrally by council and local press and to be displayed in the supermarket (listing their competitors)
- once of a week, supermarkets to publish heat map of day and hours, indicating when busy / quiet periods are
- give loyalty points for people who shop outside of peak or priority hours
- reverse loyalty points system – award points to people who DON’T panic buy toilet roll or other high demand items, or who regularly buy in smaller quantities. (Trickier for people to game this system if you apply it only occasionally, averaged over multiple visits rather than at checkout.)
- reverse multi-buy offers – cheaper prices for buying smaller quantities of high demand items,instead of rewarding buying in bulk
- suspend Sunday trading restrictions – none of the reasons for having them apply at the moment. It also leads to the policy of ‘letting people in before the tills open’ which again, wasn’t intended for this sort of demand, and will just lead to an increased number of people in close proximity who are unable to leave the store
Home delivery / website:
- static page (one that specifically does not require registration/login) regenerated at regular intervals showing, per store, remaining available delivery slots by quantity and date
- a proper system status page for all supermarkets, with website metrics – e.g. page load time and API failure rate, email delivery time – and customer service metrics: outstanding calls/emails and current wait time for both. Let people check status of email tickets. Heat map showing quiet times to call customer service. Callback option.
- make the list of out of stock items mentioned earlier available online too
- government to provide an API that accepts, say, a postcode and a national insurance number, and will tell you if that person is a key worker. Use this to allow priority choice of online delivery slots etc.
- If there’s an error, say when attempting to book a delivery slot, don’t immediately redirect people all the way back to the start of the process (time consuming for users and increases server load further)
Revised 12:10pm, 22 March 2020
updated 4 December 2021
If you’re a Facebook user…
Sites which aren’t text only, but I highly, highly recommend anyway:
Great if you want to escape the mainstream news agenda, where every news organisation is relentlessly flogging the same story. The Reuters foundation is a charitable part of the Thomson Reuters agency and focuses on under-reported news and regions. Often these are stories you won’t read elsewhere but which are still trustworthy and with excellent photograph.
They cover an increasingly wide range of topics and there is bound to be something you are interested in (e.g. climate, technology, cities…) and which I think would appeal to people across the political spectrum – i.e. you can read it without feeling you’re being lectured. Also, if you’re bored with or not interested in a particular topic, just start from one of the other index pages and you’ll avoid it.
In terms of the design, yes there are (good) photographs, but overall it’s very clean and won’t overwhelm you or your mobile device. Navigation, search and tagging are simple and reliable.
There are opinions but they’re not clearly separated from the journalism and “thoughtful” rather than “shouty”.
- Secondly, I’d recommend BBC Future – this is produced by BBC Worldwide (nothing to do with BBC News Online). They publish less frequently but the articles have more depth.
Why are you wasting my time with sites that have images? I’ve specifically asked for text only news sites and I’ve been angrily looking for them for literally… minutes now. Just give the damn list already.
Well OK, but as you’ve probably already discovered, there really aren’t very many left – I can’t magically create more for you.
In my opinion, it’s only CNN and NPR that have enough mainstream news to be of value and which are strictly text only. The Guardian is one of very few newspapers that has a publicly open API, and someone has built an excellent clutter free way to browse each day’s edition, if you don’t mind it being up to the minute.
Scroll down for more info on each of these.
I’d also note if you have an eReader (loads of types, not just Kindle) you can use press reader.com to manually save a day’s edition of whatever paper/magazine you want and copy it to your device. It’s not perfect (bit slow to generate the file as everything gets watermarked) but it works and if you have a library card, hundreds of publications are available free.
What you should also be doing:
- use your browser’s reader mode (often you can set this to be triggered automatically for stories on particular websites)
- use a save-for-later app, such as Apple’s Reading List, Pocket, Instapaper… (as an Apple user who tries to stay in Safari as much as possible, I’ve switched from Instagram to Reading List because there’s less friction.)
The (theoretical) benefits to text only news sites:
- Save the time waiting for a page to load, or in situations where bandwidth is extremely limited, the difference between being able to access a site and not retrieve a page at all (better chance of success on 3G networks)
- Quicker to browse a list of headlines on a single page than navigate through a long homepage of photos and video thumbnails.
- Save bandwidth used, preserve more of your mobile data allowance
- Increase battery life on mobile devices (there’s little or no JS to load/process, so CPU load is reduced, and because the data transferred over the network is so much smaller the wi-fi or cellular radio on a phone or tablet is on only briefly and uses less power.
- Less distraction (from other elements of the page) more immersion in content (like reading a book)
- No iframes / social media oEmbeds
- Usually no advertising
- Usually no irritations like cookie warnings
- Overall, less stressful
Site by site:
CNN’s text service is the most well-known, I’ve listed what I see as the pros and cons:
- plenty of stories (40)+
- very fast, clean presentation
- few HTML->text conversion issues
- stories presented in a random order with no categorisation / topics
- opinion items mixed with reporting without being labelled as such
- index doesn’t provide date or timestamp
- often no author name(s) on full article
- no direct link back to full versions of each item
- the live audio stream often doesn’t work
- too narrow an agenda – at times in the past year it seemed CNN were only reporting on Donald Trump
NPR – formatting is a bit cruder and only
10 stories on homepage (tip: click ‘News’ and you get 15) (they’ve added more)
The Reuters app isn’t strictly text only but it does have an offline mode and supports iOS dark mode.
- Start a new scratch file (Mac: shift-cmd-N)
- choose ‘MySQL’
- Paste your query in
- Reformat code (Mac: opt-cmd-L)
It’ll colour code and tidy everything, including lining up all the field names and aliases, neatly arranging the joins and the where clauses, plus you can hover over opening or closing brackets and see the opposite bracket highlighted.
This is useful when previewing raw Drupal view SQL and trying to understand it.
If you are trying to add a YouTube video using media > remote video in Drupal 8.7 (media is now part of core) and you stumble across this error – which is not discussed anywhere in the core issue queue that I can see…
The provided URL does not represent a valid oEmbed resource.
the fix is to add this line in settings.php:
$settings['http_client_config']['force_ip_resolve'] = 'v4';
Debugging / cause:
– First verify it’s not a private video (unlisted is fine)
– Optionally you can manually test the oEmbed response in your browser (you should get some JSON data back) – the URL needs to be:
https://www.youtube.com/ombed?url=[an encoded full YouTube URL]
It’s as quick/quicker to look in Recent Log Messages in Drupal first, you may be seeing errors like this:
Client error: `GET https://www.youtube.com/oembed?url=https%3A//www.youtube.com/watch%3Fv%3Dyoutubeid` resulted in a `429 Too Many Requests` response:
Could not retrieve the oEmbed resource.
(which doesn’t tell you anything).
oEmbed requests in Drupal are simple, unauthenticated HTTP GETs – i.e. they don’t use the YouTube API. Nothing particularly wrong about this. However the trouble is YouTube has started blocking IPv6 blocks en-mass; apparently because it’s too easy for people to keep changing IPv6 addresses (if ISPs provide a large pool of them) and use them for spam. Therefore all and any requests over IPv6 may simply be blocked, regardless of how few you’ve made (I can confirm this for Linode servers.)
First, verify this is true for your server by manually grabbing the URL at the command line via wget, with the -6 and -4 switches.
Assuming IPv4 works, you now need to tell Drupal to make Drupal use it. This is easier than expected. Drupal uses the Guzzle HTTP client library, specifically as an HTTP client factory – but as this StackExchange answer explains – part of the default setup automatically merges in values from $settings, i.e. anything you add under $settings[‘http_client_config’].
So make your $settings.php writeable, and configure the force_ip_resolve setting as shown at the beginning of this post.
YouTube queries should then start working immediately.
Even if you’re still running macOS High Sierrra (I’m on 10.13.6) you’ll receive a Safari update (from 12 to 13). This will break a number of extensions – including most adblocking – also a vim-based keyboard extension I was using called Vimmy.
So you may want to avoid upgrading, or do as I’ve done and switch your default browser to Firefox etc. for the time being.
- 32-bit apps will no longer be supported at all (
currently that still includes Acquia DevDesktop – for running Drupal development sites)
- the default shell is going to change from Bash to Zsh
- scripting languages won’t be installed by default (Apple gave Python, Ruby and Perl as examples in a support document, but didn’t specifically mention PHP). It’ll mean Homebrew will need to be installed differently. Presumably it won’t be an issue if you’re upgrading a previous macOS version, but, also presumably, it will be if you’re using a new computer, even with Migration Assistant.
- iTunes has been removed and the Apple Music replacement apparently doesn’t support column view of your music library.
- John Gruber writes that Catalina is a pain to use due to (a) bugs but also (b) excessive permission alert dialogs.
(As usual, my own policy is not to upgrade to a new macOS release until 9-12 months after it’s come out, to allow everything to settle. I write this – post updated Feb 2020 – on a machine that’s still running High Sierra, which should still get support until late 2020 – although again, Apple have never announced support lifecycle dates.)
- Notice Global have added a couple of new DAB+ stations on the Digital One multiplex. Other household radios (including a Roberts Sports DAB 5 – my review) can receive these automatically, but the Pure One Classic (purchased Dec 2009 – £47, Amazon) displays “Upgrade pure.com/upgrade”. I have been putting this off.
- Nervously visit Pure website – seem to remember DAB+ upgrade cost £10 or so. Felt sense of irritation at charging for a feature that ought to be free, and that offering it free will boost chance of repeat custom.
- pure.com/upgrade redirects to http://upgrades.pure.com/uk/update and prompts for serial number.
- Look at slightly worn barcode (sticky label) on back of radio – consists of six digits, two letters, 4 digits, a space then a 9 – is this it? Maybe the final nine is a check digit. (Later: it is, if you remove the two letters in the middle).
- Enter serial number on iPhone, rejected.
- Notice letters are lower case. Enter again in uppercase in case of sloppy programming. Still rejected.
- Probably only supports recent products? Click the “if your product is not listed” link and navigate through Digital Radio/Hi-Fi and One Family. (Each model type has a “Family” suffix – idly wonder how many people will be sufficiently on-brand to understand/care what a “family” is, in this context?) Click Software, then Software upgrade then another Software upgrade link. Browser downloads a PDF telling me to go to upgrades.pure.com/uk.
- Am doing all this on an iPhone in the kitchen where the radio is. Wonder if iOS/Safari or the 1Blocker software I’m using it screwing things up. Go upstairs and load the site there. Same thing, just a PDF.
- Return to upgrades page and read product list properly. Realise One Classic is listed after all, so I should be using the serial number form after all.
- Realise I’ve forgotten the serial number. Go back downstairs with phone. Re-read the bit about the serial number format:
“Serial numbers are normally in a 6 number, 2 letter, 6 number format.”
- Hmm – mine has 6 numbers, 2 letters, but then a gap and 1 number at the end. Move radio around in light whilst squinting at barcode. Is that a scratch in the label, where a number used to be?
- Wonder what to do. Can I get the serial number via the radio’s UI? Poke around the settings menu a bit. Doesn’t look like it.
- Realise I have a number and a barcode, so if I can just scan the barcode… With a unhealthy level of cynicism, open iPhone camera app, knowing that it will scan QR codes, but assuming Apple, whilst having invested considerable developer resource in creating an animated poo emoji, have probably deemed that enabling the camera to scan a linear barcode is too niche of a feature to bother adding support. This assumption is proved correct.
- Wonder if there’s a website that’ll let me scan a barcode, to save installing an app just for this. Quickly abandon that idea.
- Open App Store on phone. Start typing “barcode scanner”. Choose “barcode scanner” from autocomplete dropdown rather than barcode scanner free (likely stuffed with ads etc.?) or barcode scanner uk (what’s so country-specific about a barcode scanner app?).
- Results page:
1st: “QR Code Reader and Creator” (Ad, 191 reviews, 3.5 stars)
2nd: “QR Code Reader” (37.4k reviews, 4.5 stars)
3rd: “BarcodeScanner” (8 reviews, 4 stars)
- Observe, optimistically, that BarcodeScanner doesn’t mention QR codes at all. Looks much simpler / duller than rest. Decide to choose it, based on similarity to own personality.
- Install BarcodeScanner and open it:
Met deze barcode scanner kun je een barcode scannen om de inhoud van de betreffende barcode te controleren en zien welk type codering er gebruikt is.
- (Later determine this is Dutch.)
Press Scan een barcode link at bottom of screen.
- After a couple of attempts, scan successful (red moving horizontal line turns green).
- A number was indeed missing – the ‘1’ had been scratched off. (To the app’s credit, although I can’t copy paste it, it remembers the last number I scanned when I subsequently reopen it, and it tells me what type of barcode it is.)
- Also take a photo of the barcode, go back upstairs and enter number for safe keeping in my notes app.
- Enter correct serial number on website, accepted. Now asked for current software version. Back downstairs to check the radio again, do this bit on the iPhone – which doesn’t seem to handle the enabled/disabled state of the Continue button quite right (remains greyed out, but still clickable).
- Now asked to enter ‘Device Hardware Identifier’. Wonder how secure this needs to be. Wonder how I’m supposed to get that. See it involves holding down Menu button then waiting and holding it down a second time. Presented with a 32-digit hex number on two lines of the screen. Really? Attempt to enter this in full the first time (rejected), verify I’ve typed it correctly, then re-read the instructions and note they only want the top line. Note that they could have just trimmed the first 16 characters of the response or limited the maximum length of the text field. (Grateful I don’t own a different Pure radio, having read account from another user that hardware identifier on Pure One Mini only displayed for two seconds at a time before reverting to radio mode).
- Next page has a link to DAB+ or DMB-R update
- Decide at this point things are going to be a lot simpler if I just take the radio upstairs to where the computer is (I’m going to have to connect it to USB anyway). But first, take a photo of the display, showing the hardware identifier.
- Find somewhere to plug radio in. Inevitably involves having to unplugging something else because power adaptor is too big.
- Enter details on computer again and note so far there’s been nothing about payment (but it hasn’t said the upgrade is free, either).
- Next page has a heading (which I suspect most people won’t notice) saying “Paid software download” , but also doesn’t have any payment info, just a couple of download links (Windows, Mac). Maybe it’s free and they forgot to update it. Also has a bit confirming device hardware identifier and an 8 digit DAB+ unlock key. Copy and paste this into notes app. In all honestly, can’t be bothered to fully read the following four bullet points – but do notice one mentions having to turn the tuning dial to enter the code.
- Download the firmware for Mac. (Extra point to Pure for providing this, as wasn’t confident a non-Windows version would exist).
- Take down box of USB cables from shelf and select an appropriate one.
- Run the installer. Take time to read the instructions carefully.
- Set the radio to update mode as described. Attempt update. App immediately says radio cannot be found.
- First suspicion is that it won’t work properly when running via the extra USB socket on my (wired) keyboard, so instead connect to a proper USB port on rear of Mac Mini (predictably, sockets already fully in use, so have to work out which of three HDDs to disconnect. Requires care as macOS has an external USB connected SSD startup disk. Trace cables and unplug the Time Machine backup drive instead. The drive was in power save mode (not spinning) at the time, but that doesn’t stop macOS complaining that I didn’t eject it first.
- Retry firmware upgrade. (Pure app has a button for this). This time, takes a lot longer (promising), but fails again (not so much).
- Decide to repeat but power cycle the radio first. Fails again.
- Aware that not all USB cables are created equal. Search in box for another. Curiously, seems to have a USB symbol on both sides, thus making it more of a pain to insert the correct way around.
- Radio connected! Update process start, a little bit slow, just over 3 minutes. To Pure’s credit, a copy of your existing firmware is downloaded first.
- Radio has restarted, seems OK. Can receive Radio 3 on BBC multiplex. Go to the update menu and verify the version number has incremented.
- Haven’t been asked for an unlock key. Perhaps I don’t need it after all…
- Put cables back in box and replace on shelf. In doing so, knock biscuit tin onto floor. Retrieve tin (contains actual biscuits) and inspect contents. Mostly smashed.
- Try and tune into a DAB+ station. Opt for Gold. Appears in the station listing twice, once as Gold on local mux I know I definitely can’t get in this room, and as Gold UK on D1 in DAB+ (40k), which is what I need to test.
- Tune in. Display shows “Upgrade – pure.com/upgrade”. Hmm.
- Maybe I’ll retune it just to be on the safe side. Choose Autotune. Wonder as I wait, as I do every time I’ve done this, on the inconsistently of TV/radio tuning menus and whether on not this device has a ‘Purge’ option to get rid of stations or secondary services that no longer exist.
- Station list looks fine (has recent additions), but get identical upgrade message to before when tuning to DAB+ stations.
- Go back to the software menu. Idly try turning the tuning knob and suddenly there’s a DAB+/DMB-R unlock option. Feel stupid about this. although wonder if, as software has been replaced, it could have been rephrased or prompted me to enter the key.
- Realise I left the phone with the code in upstairs. Go back to fetch.
- Correctly guess how to enter it (turning the dial to select the number and A-F – obvious – then pressing the button in to advance to the next one – perhaps not quite so obvious to all). In hindsight, this was perhaps the most enjoyable stage of the process, as it felt a bit like opening a safe.
- Message saying code accepted. Check to see if there is a congratulatory exclamation mark at the end. There isn’t. Wait and if anything else happens, like the message going away or the radio retuning itself. It doesn’t.
- Attempt to tune in again. “Station not available”.
- Power cycle the radio. Repeat.
- Try BBC mux. Fine. (Always much stronger, even though same mast. Wonder why this is?)
- Double check aerial fully extended.
- Try other D1 stations again. Nothing.
- Scrolling “intellitext” freezes and radio spontaneously reboots. Worry about this – is radio too old to cope with new software?
- Remember (possibly apocryphal?) story of TV installer who, unable to get a picture at customer’s house, proceeded to dismantle entire television, only to return, defeated, to office and learn of Emley Moor mast collapse. Decide sensible to check if any transmitter work ongoing.
- Try and remember what the Digital One website address is. Vaguely recall how the site looks – reassuring old fashioned – quite narrow horizontally, as designed when smaller desktop displays prevalent – maybe a purple colour? Suspect list of stations is out of date and lists services that don’t exist anymore, like Oneword and Birdsong. Get mildly depressed at this.
- Remember the domain ‘getdigitalradio.com’ for some reason. Enter it. Ok, this isn’t it, this is that peculiar green one with the animation that looks like it was done in Flash (but isn’t) and the confusing menus/navigation.
- Note Digital Radio UK copyright statement and link to Radioplayer in footer. Who are Digital Radio UK? A consortium, but who exactly? Can’t remember.
- Don’t think this site has any transmitter info, but try the postcode checker anyway. Note, yet again, the choice of colour scheme is confusing: the heading Good reception has a green background, yet the stations underneath it all have a gradient that’s more yellow than green, which implying to me reception will be weaker.)
- Google “digital one”. Top result – ukdigitalradio.com – this is it. Check the news page. No updates since Heart 80s launch and BFBS closure in early 2017.
- Does have a transmitter list – under coverage. Including Google map (to their credit, unlike many sites since Google helpfully broke everybody’s maps when they started charging for the Maps API, they’ve made the effort to register a API key). Doesn’t seem to be anywhere that gives me transmitter status though.
- Decided to try BBC reception site. Signal from same mast, after all. Despite annoyance that they can’t just give me a single page of text, transmitter by transmitter, like on Ceefax, the checker does work properly and they haven’t hidden any technical info – and it shows past faults, including about 10 minutes of downtime for the BBC digital mux on Friday night. Listed as “fault”. Idly wonder cause of this and what, nowadays, BBC / Arqiva consider a good response time.
- No current faults though.
- Move radio around a bit. BBC reception is stable, but not good as normal. Back on Digital One, can get one bar of Classic FM, with a lot of gurgling, if I move radio closer to the window.
- Assume probably due to the weather. (Humid day with thunderstorms.)
- Decide can’t be bothered to test Gold or other DAB+ stations now and go back upstairs and listen to Simon Mayo on Scala via iTunes. (I can receive the SDL multiplex directly off air here, but only if I climb a small hill first…)
- Print serial numbers directly onto products if you can (consider wear and tear, impact of cleaning, fading from exposure to daylight – perhaps place on a shielded internal surface, such as the inside of a battery compartment cover). Barcodes are a useful backup, but use QR-codes for maximum compatibility with smartphones.
- Use serial numbers codes with a consistent format that’s easy for humans to parse. Use dashes where you have separators. Maybe copy something familiar, like the 0000-0000-0000-0000 credit/debit card style.
- Read all the instructions.
- Assume your users won’t read all the instructions.
- Make it clear at the start of a process which software updates incur a charge.
- If you’re asking people to enter more than one code, perhaps you’re doing it wrong. (Can’t a unique hardware identifier give you all the information a serial number can?)
- Allow for common mistakes in your form validation.
- Include the instructions on entering any unlock codes again after completing a firmware upgrade.
- Use straightforward, clear navigation and colour schemes on websites.
- Test things before upgrading a product – e.g. remember to verify if a particular station/multiplex has good reception that day and in that location.
- Store biscuits near ground level.
- Bear all this in mind (including the likelihood of users of all abilities making mistakes) when contemplating marketing material for digital switchover.
Later: reception has improved and I can confirm the DAB+ upgrade has worked. I’m grateful the radio I bought almost ten years ago will continue to work.
P.S. Pure have a list showing which of their radios are DAB+ compatible. It’s worth checking as curiously, it shows that another of their radios, the Tempus 1S, with a rather nicer wooden finish and almost twice the price, and which I bought a year later, isn’t in fact DAB+ compatible, despite having a USB socket.
Be aware that if you’re using Redis to handle a queue, don’t rename your APP_NAME environment variable while there are jobs on the queue, as they will all mysteriously disappear.
This is because the APP_NAME is used as a prefix to the Redis key, so Laravel will fail to find any jobs that have already been added.
'redis' => [ 'client' => env('REDIS_CLIENT', 'predis'), 'options' => [ 'cluster' => env('REDIS_CLUSTER', 'predis'), 'prefix' => Str::slug(env('APP_NAME', 'laravel'), '_').'_database_', ],
Quite a lot has already been written about this, so I won’t repeat it.
Here’s a working rule for Safari tested with the AdBlock extension v2.70, that will leave you on a blank screen at the end of a video.
Adblock rules for Safari: