Converting JSON into CSV

29 Dec 2017macosbashjq

Recently I needed to analyze some JSON data. Now, I'm no data scientist, so I wanted to convert my JSON data to comma separated (CSV) and "flatten" the data... just so I could use the data in Excel.

And Merry Christmas and Happy New Year!

Continue reading...

Installing High Sierra in a Parallels VM

20 Oct 2017macosparallels

When macOS High Sierra was released around 25th September, I tried to install it in Parallels Desktop Lite. However, both a clean install in a Parallels Virtual Machine (VM), nor an in-place update did not work (the High Sierra VM would refuse to boot). I discovered the High Sierra installer converts the VM file system to Apple File System (APFS). However, Parallels does not support APFS, so here's how to disable the conversion and get High Sierra running in a Parallels.

Continue reading...

iOS 11 "likes" and "not likes"

27 Sep 2017opinionios

I admit, my title is misleading. This is a list of mostly "not likes" with iOS 11. Why few "likes"? Because there is enough written elsewhere singing the praises of iOS 11 and detailing "what's new". Maybe my dislikes will help you decide if (when) you want to upgrade...

Continue reading...

Text Manipulation Cheat Sheet

26 Jun 2017macosbashregex

I recently had the "opportunity" to perform some text manipulation to get data from a huge log file into a spreadsheet. I had done this sort of work a long time ago as a developer, but had forgotten over the years. So I decided to compile a text manipulation cheat-sheet for macOS.

Continue reading...

Setting printer defaults in macOS CUPS

23 May 2017macosprinter

I have experienced a couple of issues printing with the Ricoh printer drivers for macOS - at one location, I simply couldn't print, and at another, I couldn't get it to print "two-sided" (despite the correct duplex settings). In both cases, I reverted to the standard macOS driver, i.e. "Generic PostScript Printer" or "Generic PCL Laser Printer". This post details the steps to set printer defaults like duplex via CUPS.

Continue reading...

Workflow Action to add cheap IDD call prefix

09 Apr 2017iosworkflow

Does your service provider differentiate between standard or "premium" IDD and "budget" IDD like mine does? Typically, the standard + international call prefix will default to the premium option, but to use the the cheaper option, usually via voice-over-IP (VoIP), one has to specific a different carrier-defined prefix, e.g. 12300 (I just made this up, check with your telco). I can't find a built-in way to do this on iOS... enter the Workflow App!

Continue reading...