Robin Glauser


My Blog about Development, Design and my random thoughts.

Das gedruckte Velo

This is the Swiss German Version of the Speech Printing a bicycle, which I gave last Year at the Rhetoric Club Solothurn Meeting on Zoom on the 14th of December. I used OBS with PowerPoint with a magenta background, so I could put the slides over the Camera Feed. For the camera I used my iPhone with the obs.camera Plugin. … Read More


Building a joke machine with an ESP8266

I had a few ESP8266’s lying around and some OLED Displays and wanted to do a project with them. So, I decided to put a joke API (http://official-joke-api.appspot.com) I discovered earlier to use. Wire up your display to the ESP8266 according to the following schematics: Then add the following code to your ESP8266 with the Arduino Application. You need to … Read More


Create dynamic virtual hosts on XAMPP with Windows

I just tested it and it still works in 2020 with the newest XAMPP Version. This is a short tutorial how the get up and running with dynamic virtual hosts with XAMPP on Windows. The goal of this tutorial is to be able to create a directory like “local.mywebsite.com” in your C:\xampp\htdocs\ to add a virtual host dynamically. First of we … Read More


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