Editing or Removing callouts in ScreenFlow

Of the screen recording apps I have used, Telestream’s ScreenFlow is my personal favorite. While it’s Mac-only, ScreenFlow does a great job of recording desktop and iOS device displays.

Recently, I needed to blur out some sensitive information on a display. Since the callout was created several steps back, hitting the ⌘+Z key combination to undo everything wasn’t a great option.

Ultimately, I found this Telestream blog post which showed how to edit callouts using the Option key. Very handy!

Compare two columns for missing values in Excel

At work this morning, I had to make a list of managed computers with 32-bit operating systems which were not checking into a console. In this article from ExtendOffice, they walked through the process of comparing two columns for duplicate data by using a formula in the third column.

Once I had the formula 1 in place, I formatted the data as a table. Clicking the third column’s header provided the option to uncheck “Select All”, then scroll down and select (Blanks). The resulting view showed the items missing from my list.

 

Automating FTP on the Mac with High Sierra

At work, I was scripting the connection to an FTP server and downloading a website backup.

From articles at Low-End Mac and Mac OS X Hints, this seemed pretty straightforward.

However, the command-line FTP app was removed from recent versions of macOS. A conversation on Stack Exchange explained how to download and install the command-line FTP application.

Now the pieces are in place and that task is automated!

Adding Two-Factor Authentication to a 1Password login

I’ve been using using 1Password since version 2, way back in 2009. As of this writing, the beta of 1Password version 7, and it is a nice update.

Today, while registering for a new web service, 1Password alerted me the web service had Two-Factor Authentication (I will call it 2FA hereafter) and I had not yet enabled the feature. Enabling 2FA is important from a security standpoint. To access your account, a hacker would need your credentials (username and password), plus a temporary code from the 2FA provider.

Back in 2015, AgileBits gave 1Password the ability to act as a 2FA token. However, it had been a while since adding 2FA to a login in 1Password, and I could not recall the process.

Here is an AgileBits blog post that details the process. There’s even a video to make things easier to understand!