Robin Glauser


My Blog about Development, Design and my random thoughts.

Creating a Toastmaster Timer with Arduino Part 2: Prototype and Presentation

A bit late, but I just found my old talk on Youtube about the prototype and this old post that I started writing. Originally this was a project from 2017. Part one can be found here. I finally got the parts I needed to build the prototype. After putting everything together according to my schematics, I uploaded the code and … Read More


Automatically configure a lot of Android devices

Are you getting tired from typing the same login and pressing the same buttons on each device you need to configure? In this article I will describe a way to automatically fill in forms and click buttons on identical android devices. In my case, it were about 8 Samsung Galaxy Tablets where I needed to configure the wireless. Now you … Read More


Creating a UML to PHP Generator for StarUML

With the new version 3 of StarUML there wasn’t a UML to PHP Generator yet. I’ve decided to take the existing one for Java (https://github.com/staruml/staruml-java) and rewrote it so it would generate PHP code instead: https://github.com/nahakiole/staruml-php I then submitted it to the StarUML extension Repository and to this date it has already been downloaded over 600 times. If you find … Read More


How to import data from another tab in Google Spreadsheet

Let’s say you have a spreadsheet with two tabs: Contacts and Contest. Now you would like to import some data from one tab into the other. You can do this with the following formula: If you now want to import multiple fields just drag the field like you would do it if you were applying a formula normally:


Selenium Chromedriver not sending exclamation mark

Update: The chromedriver team looked at the issues and currently they won’t fix it as it only happens with non US-en keyboards. So to fix it the computer on which chromedriver gets run must have this keyboard set for it to work without problems. But they may implement a warning if the user doesn’t use the US-en keyboard so people … Read More


Exploring the API of the myBFH application for Android

Instructions Get the Charles proxy application from here: https://www.charlesproxy.com/. Then install the Charles certificate on your android phone according to the instructions here: https://stackoverflow.com/a/31945622 Now install the app and start it, after a bit of loading you should see something similar to this: These are the HTTP requests the app makes. In this screenshot I’ve filtered out only the ones going … Read More


How to use time traveling to stop worrying.

If you don’t have a DeLorean time machine, a TARDIS or a Time Turner you might start worrying that this article isn’t for you. But don’t worry and continue reading. With this article I will show you how you can use the concept of time travel to stop worrying. Even if you don’t have a functional time travel device. I will teach you three … Read More


Speed up your old Macbook by disabling Spotlight for your development folders

I was reading about how the new Macbook Pro’s were having battery problems the first few days of usage. Most people looked at the index process of Spotlight as the source of the problem. Especially if you use a package manager like npm oder composer which creates a massive amount of folders and files. Then it hit me. If I … Read More


Unpacking archives with double clicking on Windows

Something that bothered me for a long time on Windows was the default action of 7-Zip to open the file manager when double clicking on a archive. In 99.999% of the case I use a archive I want to unpack it into a new folder in the same folder I am in. So by opening the manager by default I … Read More


Creating a Toastmaster Timer with Arduino Part 1: Schematics

Sometime ago I was asked to be a time judge at a local toastmaster contest and measure the time for the speeches. This gave me a great idea for a project with my Arduino which I got laying around. I could create a timer which automatically raises the flags with a servo to indicate the time left for the speaker. I started … Read More