Robin Glauser


My Blog about Development, Design and my random thoughts.

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


Printing a bicycle

Yesterday on the 26th of November I gave a speech at the English Toastmasters Club in Bern about 3D printing. How I use it in my daily life and what my process is when repairing parts of my bicycle and other things. You can find the presentation with all the images online: https://docs.google.com/presentation/d/12j1Zav_I4uGXMvdOesYLl-rXYAn1I-mrzoBqnZ5OasU/edit?usp=sharing To record this video I’ve used my … Read More


Everything will get easier

I love this scene from season two of Bojack Horseman. If you haven’t seen the show I highly recommend it. The fact that it’s animated may put you off at first, but put yourself through the first season and you won’t be able to stop watching it. When I was a lot younger and already working and playing on the … Read More


3 ways how to get work done even if you don’t feel like it

Not feeling like doing something. Being to exhausted to do it. Not able to start working on that certain task. We all feel sometimes like we just can’t start to work. The times when we can’t start doing something. So what can we do about that? Lot’s of things. :) 1. Break down your task Starting by trying to break … Read More