Search This Blog

Saturday, June 09, 2018

Calendars

Another lovely day and the Silver Vixen again made the most of it with some more pottering in the garden. The Gorse Fox spent much of the day in the study. We have a spreadsheet that shows Urban-Cub and Pistol Pete's duty roster and who should be caring for Ellie when they are not available. This is fairly extensive and has a few complexities. Urban-Cub provided an update... confirming that the spreadsheet was the master source and to trust it over and above what her online calendar might say.

This got the Gorse Fox thinking. Why couldn't the spreadsheet also populate her calendar? Well, of course it can. You can create a "csv" file and import it into Google calendar and "voila". This, however,  is a one-off. There is no sensible way to update it, or to erase the mass of old entries and replace them with new entries.

The Gorse Fox was not happy with this and spent several hours trying to find a way that he may be able to remedy this. He thinks he has finally come up with a solution - though it is a little inefficient. He just needs to get some time to sit down and write the code and test it. This, he suspects, will be fairly time consuming and needs to written in a way that Urban-Cub can run it on her computer so there is still a lot of thinking to do.

No comments: