Money As Data

Current ‘Digital’ Money As much as many people use banking apps and send money via their smartphones, money isn’t really digital yet. What do I mean by ‘not digital’? Of course it doesn’t mean you need to physically transfer paper money and metal coins to buy a coffee. You can of course do this digitally …

Credentials – Custom Alteryx Tool

Why Saving Credentials is Hard 🔐 Saving credentials for use in an Alteryx workflow is a very common use case. Maybe you use an API and need to save Client keys or secrets and getting these credentials into a workflow without hard coding is tricky. It’s common to either read from a text file located …

Magento Commerce API Fun 🙄

As a consultant you get to work with many different systems, some easy, some difficult and some downright weird. Magento Commerce fits firmly into the last category. For those that don’t know Magento is a very popular E-commerce platform owned by Adobe and used by some of the largest companies in the world. How APIs …

File Hashing in Alteryx

Identifying Duplicate Files Imagine you have a folder full of files, all with different names, where you need to identify which, if any, are duplicates. You could use the file size but it’s not a guarantee the files are exactly the same just because they are the same size. Hashing files is an easy way …

You Should Probably Learn To Code

There’s been a clear trend going on for many years now known as ‘No code’ or ‘Low code’. This essentially describes tools or platforms that provide you with a GUI that abstracts away the underlying technicalities so non-technical users can use powerful software. Doing this has been a huge benefit to business since the addressable …

Web Automation Using Python and Selenium

Selenium is a software library that’s used to automate web browsers. It’s often used to run automated testing but can be used for anything involving a web browser. Since so much software is now running in the cloud and accessible via web interfaces Selenium is ideal for automating lots of manual tasks. There’s libraries available …

Multi-threading API Requests in Python

When making hundred or thousands of API calls things can quickly get really slow in a single threaded application. No matter how well your own code runs you’ll be limited by network latency and response time of the remote server. Making 10 calls with a 1 second response is maybe OK but now try 1000. …

Using Python with One Time Passwords (2FA)

Ever wanted to automate a process involving a vendor website and come across this. Me too 😔 One time passwords (aka MFA, 2FA, or two factor authentication as I’ll say from here on) are something everyone should use and are great for security, not so great for automation. Until recently I thought this was hard …

Do What I Mean!

DWIM (do what I mean) computer systems attempt to anticipate what users intend to do, correcting trivial errors automatically rather than blindly executing users’ explicit but potentially incorrect inputs. https://en.wikipedia.org/wiki/DWIM When I hear about the AI singularity and how no one will have jobs in 10 years I usually just laugh. Computers and software are really, …

Why are Logistics Carriers so Bad with Data?

Just to be clear when I say Logistic Carriers I mean UPS, DHL, DSV, GLS and many other three letter companies that deliver your Christmas presents, but in a business context they are also responsible for B2B deliveries of goods to shops and warehouses. I’ve previously worked in Logistics for many years and so have …