Topic

Automation

A collection of 9 issues

Auto-generated Home Assistant dashboards

Home Assistant is a fantastic platform. I've been sucked into it for quite some time. Creating the dashboards is fun, but finishing them is very difficult. They are a constant work in progress and take quite some time to get right. In the end, the results can be

Manipulating an Excel file with Python

It's one of those things that sound easy but hardly are. There are a lot of libraries and solutions out there that enable you to manipulate Excel files via code. Some of them are expensive, other are open source. A lot of languages have a library to help

Connecting to a Microsoft SQL Server database on macOS using Python

There are always situations where I want to automate small tasks. I like using Python for these kind of things, you can quickly get something working without much hassle. I needed to perform some database changes in a Microsoft SQL Server database and wanted to connect to it using Python.

Continuous integration with Jenkins using a Fake build script

Last time we made a Fake build script for an ASP.Net MVC project. I wanted to bring this to the next level and set up continuous integration for the project. I've used TeamCity in the past and it was ok, it did its thing but there was

Creating a build script for an ASP.Net MVC web application with Fake

Creating a build script, always a hassle to do and one of the things that gets the lowest priority in the backlog. Certainly on small projects. On one of my previous work places MSBuild was used to automate the builds. I had such a bad experience with it that I

Make an AJAX call when the user leaves a web page (using onbeforeunload)

Sometimes you need to send some data to the server before the user leaves your web application. A good example of this is saving data. Instead of giving the user a save button to save the changes he made, the application saves all data if the user navigates away from

Compressing and combining files with JavaScriptMVC

Unfortunately the images to this post were lost during the migration from Blogengine.Net to WordPress This is the third article on JavaScriptMVC, so if you’re interested in more these are my previous posts on the subject: * Finally found what I have been looking for: JavaScriptMVC * The MVC of

Getting the element that has the focus via JavaScript

This is one of those things that you only need on very specific occasions. I needed to get the element that has the focus on a page. Went to Google and found the answer somewhere deep into a forumthread. So for future reference here goes: Internet Explorer supports the document.

Sequentially download multiple files (with jQuery)

Unfortunately the images to this post were lost during the migration from Blogengine.Net to WordPress On my previous job, I was working together with a colleague on a file transfer application which lived in the browser. We were up -and downloading multiple files at the same time and needed