Blog

learnings

A bash script to search a CSV file

coding macos shell regex

I sometimes need to search a huge CSV file (13 MB), containing 21,000 rows and roundabout 40 columns, which Numbers takes half a minute to open. All I need to do is search and display the results of a few columns only... so I wrote a bash script to do this for me - and I was quite specific in that I wanted the results in color!

Continue reading...

Fixing PowerPoint Slide Show on External Monitor

fix macos office

I've been experiencing this problem for a while - when presenting using Microsoft PowerPoint for Mac 2016 (version 15) on an external monitor (or LCD projector), PowerPoint used to both the presentation slide show and the Presenter View on my notebook display, instead of Presenter View on the notebook and the full-screen slide show on the external monitor. Recently, I found the solution!

Continue reading...

Converting JSON into CSV

guide shell

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

guide macos vm

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"

opinion ios

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

coding macos shell regex

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...

Installing MySQL on macOS

guide macos

There are many open source packages that require the "AMP" stack comprising Apache, MySQL and PHP (hence "WAMP" for Windows-Apache-MySQL-PHP and "MAMP" for macOS-Apache-MySQL-PHP). Since macOS 10.12 Sierra already includes Apache 2.4 and PHP 5.6, here's how to add MySQL 5.7.

Continue reading...

Further ways to lockdown apps like Kodi and VLC

guide macos vm

You have have read that CheckPoint, a cyber security research company, has identified vulnerabilities that may allow an attacker to compromise your computer using malicious subtitle files downloaded by popular media players including Kodi and VLC. It's not clear if this affects macOS too, but in light of this threat, here is a summary of how I further "lockdown" any apps I'm unsure of...

Continue reading...

Setting printer defaults in macOS CUPS

guide macos peripherals

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...