Pandemic Journal, Day 473

This morning got off to a good start – I could smell garlic coming from Gilroy when I went out to pick up the paper. I had breakfast and was ready to make coffee. But the grinder wasn’t working right – I couldn’t get the lid to sit properly, and it felt funny when I turned the handle.

I disassembled it and found that I’d broken a plastic washer (almost the only plastic part!) when I last cleaned it. There was no way to fix it that I could figure out (remember, I hadn’t had coffee yet!). But then Diane reminded me that I had an old Hario grinder that I’d kept when I bought this one four years ago, so I dug it out, only to discover that I hadn’t bothered to clean it before putting it away.

I had managed to get a little coffee ground before I gave up, so I brewed a VERY small cup, cleaned the Hario, and ordered a replacement grinder, which arrived right after dinner, so I’m all set for tomorrow morning.

After that, the rest of the day went swimmingly – we Zoomed to services and visited friends for a pool party with at least a dozen people! Our hosts have some beautiful roses in their yard which I couldn’t resist photographing.

All in all a good, relaxing day. And tomorrow, there WILL be coffee!

Pandemic Journal, Day 472

There are only 65 shopping days until Rosh Hashana, so we are starting to get serious about High Holiday preparation at Shir Hadash. My responsibility for the past few years has been to prepare the invitations for the people who are asked to give a reading or lead a prayer at the service – in a typical year, there are well over 100 slots, each of which requires a customized email, most with an attached cue sheet for the reading.

Naturally, I wrote code to simplify the process; it’s been changed a lot over the years to accommodate changes in membership management systems, but most of it has survived pretty well.

Until this year. I may be away during critical parts of the process, so I wanted to move the code from my laptop to a server so that other people can run it. I thought it would be easy to do – copying my code was trivial, but I needed to install a few Python packages that the code uses – easily done, of course.

When I ran the code, I got an error message from the package that reads Excel spreadsheets, xlrd. It said it couldn’t read a .XLSX spreadsheet, which was odd, because it always had read them before.

I did a bit of Googling and discovered that the author had removed support for .XLSX spreadsheets some time ago and that the package was now unsupported. I probably could have just installed an older version and continued, but I knew that was not a long-term solution.

The GitHub page for xlrd suggests using openpyxl, so I installed it. Its interface is very different from that of xlrd; it’s also easier to understand, but it still requires effort to make the necessary changes.

I wonder how many other programs I have that depend on xlrd?

Shofar

Shabbat Shalom!