Convert Bank Transactions XLS to CSV in Python

I’ve written previously on importing transactions to hledger/ledger from KBC bank in JavaScript and PTSB bank in Python. I took different approaches to each: For KBC, you needed to log in and run Javascript which scrape the transaction table and download it formatted as CSV For PTSB, the script automatted logging in, get the transaction table and save locally as CSV Both approaches are valid - but suffer from the same issues: any change the bank makes to it website needs to be updated in the code.

Linux, Freesat and Saorview

I recently replaced a rusty satellite dish and faulty LNB (it has been in use in the house I moved in to for 10+ years I’d guess) and decided to try install one myself. Here in Ireland, the two main broadcast methods of receiving TV are satellite (Freesat / Sky) and terrestrial aerial (Saorview). An issue I have one larger sitting room TV and one small living room TV. I couldn’t get both to be Samsung (out of stock on smallest sizes - which seem to be going out of fashion).

Ubiquiti Unifi with Sonos on a separate VLAN

Update 2023: these instructions are out-of-date for the latest Unifi controller software versions. It's preserved here as written for those who still have older versions. This post uses a file called gateway.config.json and Unifi now say: This article is not applicable to the UniFi Dream Machine models, because all configurations are already available in the UniFi Network user interface. So I take that to mean use of this file is deprecated and it should be possible to do this via the administration webpage.

Ubuntu 20.04 Vagrant with Packer

Ubuntu have recently released the new 20.04 LTS codenamed “Focal Fossa”. I’d also recently seen a tool that piqued my interest, Hashicorp Packer. Packer builds machine images that can be deployed to a cloud or as a virtual machine, or just even a plain disk image. You can even generate many images at once, really simplfying deployment. Very handy if you wanted to create virtual machines for a cluster for example, with a similar but slightly different configuration.

Ubiquiti Home Network

Over the summer, I upgraded my home network to Ubiquiti gear. Ubiquiti do business Wifi, all the way up to covering stadiums. I first heard about them from Troy Hunt and then again from Marco Arment on Accidental Tech Podcast. Ubiquiti are popular in prosumer space - for people serious about good Wifi. So far it’s been an excellent experience and I’d highly recommend it. After setting it up (there is a few moving pieces) it has been running without any intervention from me.

Scraping Transaction Data from KBC Bank

In a previous post, I mentioned importing transactions using ledger/hledger and plain text accounting. As my former bank PTSB recently raised their fees, I decided to move to KBC. I was excited to see, as part of the open payments directive, they have a nice developer portal. I reached out to KBC’s dev team, but alas they are only accepting registered companies, who meet stringent criteria. They told me they hope to open it up soon to end users, I live in hope!

Using IPv6 with Docker Compose on Ubuntu Server

I recently started using PiHole to block ads on my home network. As the name suggests, you install it on a raspberry pi. I left it in situ for about a month, until I decided I wanted to swap out the pi, but keep PiHole. The natural solution to this, is to use a docker container. Rather helpfully, there is a publicly available docker build of PiHole. Simple, right? Well my home network is also IPv6, thus the DNS on the raspberrypi should be also.

Learning Org Mode

Since hearing about org-mode on the web many years ago, I always meant to give it a spin. I only ever found one two problems: Time - Life eh? It's a mode of Emacs for which I'd also have to learn (again time) So I recently set about solving both shortcomings, as painful as it was to dismiss all the effort I put in to my vim muscle memory over the years.

Favourite Podcasts

Over the last while I’ve been collecting wonderful podcast episodes from the hundreds of hours I’ve listened to. I’ve even workshopped some of my favourites with colleagues and friends (they all approve!). Luckily a neat service called HuffDuffer allows you to create a personalised feed from episodes spanning any podcast you see fit. All you need is a direct link to the MP3 or indeed any format audio file. So here it is, my favourite episodes spanning many podcasts.

Python 3 In-Memory Zip File

In Python, BytesIO is the way to store binary data in memory. Most examples you’ll see using zip files in memory is to store string data and indeed the most common example you’ll find online from the zipfile module is zipfile.writestr(file_name, "Text Data"). But what if you want to store binary data of a PDF or Excel Spreadsheet that’s also in memory? You could use zipfile.write() (designed to take binary data) but then you can’t specify a filename (since our in-memory file was never written to a location on disk).

Page 1 of 24