Dec 18 2020 update: The Amazon export URL appears to be functional again, which is great news. However, the data is in a completely different format than what's provided by the Chrome extension, so it needs to be massaged to work with my spreadsheet. For now, if you want to use my workbooks, keep using the Chrome extension. I'll see about modifying the spreadsheet to work directly with Amazon's data.
Recently I was trying to enter our Amazon purchase details into Quicken—the transactions download automatically, but they're generically assigned to "Shopping." I was using Amazon's order history page to match transactions and assign categories, but it was slow and painful going given the layout of the orders page.
I thought there must be a simple way to download your Amazon purchase history—once downloaded, I could use a spreadsheet to search my transactions. As it turns out, there is a way, but it's far from simple. Nonetheless, after way too much work, I now have an Excel workbook that makes it very easy to find any of our historical transactions. I enter a year and amount on my Search sheet, and any matches appear immediately:
Getting from "this should be possible" to "it works!" was (as usual) more of a challenge than I anticipated, but it is now working as I wished.
This morning, I was reading about Henrique Prange's friend's stolen iPhone, and the financial damage the thieves inflicted in only a few hours time—yikes! I've got six-digit codes on all my iOS devices, which suddenly felt like not nearly enough.
Executive summary: I love this keyboard. I was on a road trip recently, gone for 12 days straight with nothing but a MacBook Air (of the 'broken butterfly' generation). As soon as I got home and switched back to my iMac, I was reminded of just how much better this keyboard is than the one built into my Air…and the one that came with my iMac.
(Note: The "Mac" in the name simply means that you're getting a keyboard with Mac-specific symbols on the Command and Option keys; I'm pretty sure the Windows version would work just as well, but without the Mac-specific look.)
This review won't be quite as thorough as that of my mouse, mainly because there aren't as many nifty features—it is "just" a keyboard, after all.
If you're a Tesla owner, perhaps you'll find these apps as useful as I have…
The first is a macOS app called Tesla Tunes that overcomes some limitations of Tesla's USB music player: It automatically converts Apple Lossless (which the Tesla can't play) into FLAC, which the Tesla can play, and it offers some rudimentary support for playlists, which aren't supported at all in Tesla's player.
It's quite old, having been last updated two years ago, but it still works well—I prefer USB to streaming over Bluetooth from my phone, which is the other option.
On Twitter, I've shared my distaste for Catalyst apps, as many of them just don't "feel" right to a long-term Mac user. I know that's vague, but today, the vagueness ends, thanks to a deep dive into Apple's recently-released Developer app for macOS. No, the deep dive isn't this blog post you're reading now, but rather one by Martin Pilkington.
He has written a great analysis of the numerous issues with the Developer app. (And importantly, he filed bugs on everything he listed.)
Many of the issues aren't specific to Catalyst, but reflect poor attention to the details that make a Mac app look and act as a Mac app should. Here are but a few of the examples from Martin's analysis:
The focus ring on the search field has square corners • The search field focus ring does not go away if you click elsewhere in the app • Doesn't show window title when toolbar is hidden • Content size is too small • Can't collapse groups in the sidebar • Find toolbar does not share search string across OS
I strongly encourage you to read Martin's article, as it puts into words just why I find many Catalyst apps so annoying to use. In addition, I'm going to provide a couple more examples—using the same Developer app—showing just how non-Mac-like a Catalyst app can be…
Update: The poll is now closed, and the results weren't even close…
Snow Leopard wins in a landslide.
With the 2020 (Virtual) WWDC about a week away—and with it, more than likely, the reveal of Yet Another New macOS Version, I thought it might be interesting to run a little poll…
What is your personal all-time-favorite version of macOS/Mac OS X? Instead of trying to add a polling plug-in here, I quickly created one using surveyplanet. It's set to full anonymous mode, so no IP info is collected—it's just for fun…
The other day, I was working on some Smart Albums in Photos, adding a Smart Album for each of the lenses I use with my FUJIFILM X-E3 camera. This seemed like a simple task; each Smart Album just needed to check two conditions:
Camera Model is X-E3 [and] Lens is 16.0 mm f/2.8 (as one example)
But after creating my Smart Albums, I noticed that some photos were missing, so I did a bit of experimenting. What I found was that Photos showed different values for the Lens field—even when the same lens was used on the same camera. Here's an example:
The only difference between those two photos is that one was taken in RAW mode, the other in one of my camera's JPEG modes.
I mostly shoot photos on my iPhone, because that's what I'm usually carrying. But when I want to go out and really take photos, I take my Fuji X-E3. The Fuji can take photos five different ways: At two levels of JPEG quality (fine and normal), those same two JPEG quality levels with an attached RAW version, and RAW only.
Most of the time, I shoot in the highest-quality JPEG format, which is more than good enough for my needs. But there are times, such as when shooting landscapes or flowers, when I want to have the original RAW file to edit, so I shoot in the RAW plus highest-quality JPEG mode.
The problem is that RAW images are huge—the Fuji's RAW files are over 50MB each, versus anywhere from 7MB to 14MB for a JPEG. Because of this, I try not to import the RAW+JPEG files into Photos. Instead, I import to a folder, then edit the RAW photo in a photo editor, output a final JPEG, and import that to Photos. (In very rare cases, I'll keep the RAW version, for a photo I may want to edit more in the future.)
Unfortunately, I wasn't so smart in the past, and I imported many RAW and RAW+JPEG photos to Photos—and I don't need the RAW versions at all. Some are pure RAW, and these I can easily find and fix (export, convert to JPEG, re-import). Unfortunately, most are in the RAW+JPEG format, and that's a problem: Once such photos are in Photos, there's absolutely no way to find them—which means there's no easy way to remove them.
A commenter asked if there were any way to view the charts using a built-in tool, as purchasing Keyboard Maestro for just this one task is expensive (and a waste of Keyboard Maestro's capabilities). And in reality, when I first started working on my solution, I started in Automator…but quickly grew frustrated by its inability to do even basic text manipulation.
But then today, I remembered I can use AppleScript in Automator to work with the text, and the solution came together quickly after that: A new Service that appears when you right-click on text in a Terminal window:
Yesterday, I noticed that the Stocks Dashboard widget in Mojave was no longer working. I couldn't find a similar (small window, always there, only stock prices) app that did what I wanted, but I did discover mop, a Go program that runs in Terminal. Using mop and Terminal's ability to save a window layout, I was able to craft a solution that worked for me.
Then commenter smayer97 asked…
Any solution to replace the mini-graphs at the bottom of the old Dashboard widget?
I didn't pay much attention to the graphs in the widget, so I hadn't considered them in my solution. And there's no way I was going to find a tidy graphing solution that also worked in Terminal. What I came up with isn't quite as convenient as having the graphs available at all times, but it's pretty close—I just have to click on a ticker symbol while holding down some modifier keys:
As you might have guessed, this is powered by a Keyboard Maestro macro, and I love how well it works.