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!
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.
Microsoft PowerPoint 2016 for Mac (aka version 15) has a strange quirk - when I copy and paste images from Preview or most other applications, the image gets copied in Tagged Image File Format (TIFF). The image is practically uncompressed (or possibly minimally compressed), resulting in very, very huge PPTX files! Plus: Removing unwanted font references.
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.
Some time ago, I posted about starting Apache automatically when macOS 10.12 Sierra starts, using the
launchctl command to add Apache to the
launchd Launch Daemon/Agent Manager. For those familiar with Windows, this is akin to managing Windows Services.
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.
So I got a new MacBook for work and I didn't realize upon next reboot, the enterprise profile had mandated FileVault encrypt the start up disk, and Apple had recommended an upgrade to macOS Sierra at the same time! You can imagine triggering both simultaneously upon reboot didn't go well at all!
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!
Apple acquired Workflow today, and Workflow is now free in the App Store! Workflow (http://workflow.is)is a powerful yet simple rule-based automation tool. One pre-built workflow is to lookup your next calendar meeting, retrieve the location if there is one, and pop up directions in Maps - all this from a single button click.
If you are new to Workflow, here is a short tutorial to use Workflow to track travel expenses.
Since 2012, all apps on the Mac App Store must run in an app sandbox, which restricts access to system resources unless explicitly required. The secure sandbox isolates the app and defines access controls, protecting users from malicious code with undesired behaviour.
Here's how to setup a sandbox for an app downloaded from outside the Mac App Store.