As I like to read, write, think, laugh, test, play and sport... this is an area where I post things that move me. I write in Greek, German or English. Sometimes it is technical, some other times it's not. If you don't mind the variation of content and languages… feel free to join me here.
If you use my Free ICS to CSV converter web service to convert your calendar(s) as a table to be able to import into Excel, Pages, Numbers, or even to Google Calendar you might already know that you can select one or more ics files at once, or enter a url of an online calendar.
Important: My converter converts only files ending in .ics
I was checking the other day what happens for users of Google calendar when they export their calendars. Google exports even if you select just one calendar a zip containing the ics.
So, the zip file cannot be converted and the converter will throw an error.
To use those exported files from Google Calendar, just take the individual ICS files out of the ZIP file and select for the converter.
With Excel you enter data and organise them by columns or rows.
Excel is not a database, so you choose your columns or rows according to your own judgment. Sometimes you find it practical to compare them row by row. Sometimes you consider how many properties a specific data set can accept and go for the columns approach. When however you find yourself in the situation where you need to switch your data from rows to columns or vice versa, the function called Transpose is the feature of your choice.
Transpose and how to use it
Transpose pastes data and switches it from rows to columns, or columns to rows. To use it:
If you like me use Parallels Desktop 16 for Mac on macOS 10.14.6 you’ll find yourself at some point trying to start Parallels Desktop and it alerting
Unable to start Parallels services
The dialog includes a URL for the following KB article with various troubleshooting steps. The first time I had this issue, the only thing helped was logging into macOS Recovery and re-installing the macOS 10.14 (last thing on that troubleshooting list).
However the issue re-occured after I have installed all available macOS 10.14 security updates.
So today after trying again all items of the KB article and as I wasn’t really keen on re-installing macOS 10.14 for Parallels Desktop to run as long as don’t re-install security updates, I did yet another search and found following article on the forum.parallels.com
The solution mentioned there worked for me… so here I am noticing this info, to able to find it, next time my Parallels Desktop refuses to start.
Restart in Recovery Mode (hold down Cmd-R until you see the Apple Logo)
Select Terminal from the Tools menu
Enter chflags restricted /Volumes/Macintosh\ HD/private/var/db/KernelExtensionManagement” (with “Macintosh\ HD” being replaced by the name of your hard drive)