Photo by Shahadat Rahman on Unsplash

We have a problem with data. Without context, data is just bits and bytes.

This article explores a novel paradigm for tracking context and lineage alongside derived data.

It proposes the use of block chain technology, similar to the approach adopted for Non-Fungible Tokens, as a solution to the problem of how to track unconnected context and domain expertise to any dataset.

What is data?

Have you ever really thought about that? I mean in a philosophical ‘why-is-it-there’ kind of way. What really is data?

Everything our senses perceive is data, though its storage in our cranial wet stuff leaves…


From Arduino.cc (https://www.arduino.cc/en/Main.ArduinoBoardMKRFox1200)

Solving a Frustration at Home with Sigfox

Over this past weekend I had an opportunity to develop my first IoT solution.

Problem Statement:

We have a prepaid electricity meter at home, and often we overshoot our consumption predictions. When the electricity went out one evening recently, plunging us all into darkness, I knew I’d found my first IoT project!

Necessity being the mother of invention …

PoC Definition

My PoC definition was: Build an IoT solution that monitors the electricity meter and detects when the ‘electricity running low’ LED comes on. …


This is a bit of a niche post, forgive me. But it does show how a knowledge of open source techniques (particularly Python) can get you out of many a sticky situation.

I recently helped implement SAP BW/4HANA at a local subsidiary of a Tier 1 global retailer. This was completed with the assistance of a 3rd Party testing team. They were not an SAP shop and had high expectations for how the documentation would be completed as an input to their testing activities.

We decided to use the self-generated documentation in SAP BW/4HANA to document our data flows and…


Photo by Kym Ellis on Unsplash

I’m on a project to implement SAP S4/HANA, and before Xmas I received a request from a member of the business to fully automate the processing of vendor invoices.

The business representative in question is new to SAP and the concepts of ERP solutions. So I explained all of the benefits of an integrated enterprise-wide solution, how the financial accounts are posted to automatically when performing operational tasks and how the integrated analytics provide real time insights. He was excited by all of that but was also eager to explore the automation of capturing vendor invoices, in other words without…


Photo by Shotlist on Unsplash

I work a lot with the SAP HANA database, and I write hobby code in Python. This week I had the opportunity to bring the best of these 2 worlds together to create a simple Python app that helps me keep tabs on the health of our SAP HANA database.

If you have ever needed to run health checks on your SAP HANA database you will have come across SAP Note 1969700: Statement Collection for SAP HANA. It contains a set of individual SQL statements, prepared by SAP for analyzing SAP HANA databases. …


Photo by Finding Dan | Dan Grinwis on Unsplash

(because life’s too short to waste it on manual tasks)

This post will guide you to extract specific attributes of calendar entries stored in Outlook, group them by date and download the result to a .csv file.

My current project requires us to account for what meetings we attended each day, and I use this code to help me prepare my project timesheets. Maybe it helps you too.

I’ll show you how to do the following:

  1. Use win32com.client to access your local outlook calendar
  2. Filter the appointments collection to a specified date range
  3. Extract specific attributes
  4. Group the results by…


Photo by Arno Smit on Unsplash

(because life’s too short to waste time on manual tasks)

This post will guide you through how to use a Python script to classify entries in a Jira Activity Stream, and group them by date and category.

My current project requires developers to account for what Issues they have worked on each day, and I use this code to help me prepare my project timesheets

I’ll show you how to do each of the following:

  1. Use Requests with authentication and certificates to gain programmatic access to the Jira Activity Stream
  2. Navigate an RSS feed with BeautifulSoup
  3. Extract elements from an…

Andrew Jabbitt

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store