Reporting automation workflow

Update:

Introduction

I work for a retail company and one of the consequences of this is IT not being a core competency of the organization. This is driven by a variety of factors—from internal customer demand to the sort of talent the organization attracts to where budget money gets allocated—but the net impact is an IT infrastructure and tooling that can be extremely limiting. This is in stark contrast with my peers, many of whom work in tech directly or in closely related fields, for whom provisioning a new VM is as simple as clicking a few buttons on an internal tool.

As an analyst, my work involves a lot of data wrangling. Most of this can and should be automated, but our IT limitations can make this a challenge. Figuring out how to automate with the available tools, which usually don't offer APIs—and if they have reporting at all it's to PDF or RTF documents formatted for printing and faxing (and can't be scheduled), has been a challenge.

These limitations have offered opportunities to get creative. This post outlines some of the convoluted processes I use to automate reporting with constraints on data retrieval, data processing, and report distribution.

Read more

YubiKey OTP, Dvorak input, Karabiner Elements, and Goku

Update:

Introduction

YubiKey 5 NFC
YubiKey 5 NFC on keychain

I use a YubiKey for 2FA. I also use the Dvorak keyboard layout on my desktop machines. The YubiKey OTP emulates a USB keyboard to input the OTP, which means its beholden to the system input layout. This means when you set up the key with Dvorak and try to use the YubiKey on a device whose input is set to QWERTY then the key won't work. This is an acute problem using it with NFC on a smartphone.

For macOS, which is my primary OS, there two good guides out there on remapping the relevant keys for the YubiKey device with Karabiner Elements:

Since I use GokuRakuJoudo to compile an EDN format Karabiner config for easier editing, I needed to rewrite the configuration for the right format.

Read more