Kaukolämmöstä lämpöpumppuun (Osa 1)

– This content in Finnish only –
Kaukolämpö on vaihtumassa ilmavesilämpöpumppuun. Tästä alkaa juttusarja vaihdoksesta ja käytännön kokemuksista.

Power automate to deliver Mailmerged documents

Power Automate flow to create encrypted email drafts with attachments to a folder in a shared mailbox

Modbus with two master devices (adding a charger for Volkswagen ID.4)

Adding a EV charger with dynamic load management needed a way to connect it as a second master to my existing modbus setup. ICP DAS tSH-735 did the trick!

Multichannel AES/EBU from PC to Genelec monitors

Description of my project building an all-digital multichannel source for my Genelecs. Setup consists of a Windows PC, an RME audio interface and a Mutec audio format converter.

Using GraphAPI for exporting, importing and editing gigantic Sharepoint lists

I hade a need to export, import and edit a Sharepoint list with hundreds of thousands of items. This is how I solved it with the Powershell.

Power Apps with large Sharepoint lists – performance with indices

Getting Power Apps to work with large Sharepoint lists can be tricky – but its doable! When you pay attention to indices you can even keep up a relatively good performance!

Handling errors when Power Apps triggered flow occasionally runs too long

This post explains a way to handle errors when occasionally your Power Apps triggered flow runs too long.

Enhanced computer vision with Raspberry Pi HQ camera

My initial setup using Camera Module V2 ended up being too unstable. I upgraded it using Raspberry Pi High Quality Camera with great results!

ESP8266 controlled staircase LEDs

Dynamic staircase LED lights combining Wemos D1 mini, Meanwell PSU and Prometheus API.

Genelec GLM in the living room

Genelec speakers are marvelous. The slight problem is that the GLM is designed to other kinds of environments than my living room. I will show you what I have done to make the experience smoother.

Teams guests, behind the scenes

Teams guest accounts are brilliant but might some times cause unexpected things to happen. This post reveals details of one given scenario.

Windows 10 Microsoft Store & Missing Install Button

Are you missing Install Button in your Microsoft Store? It might be due to a disabled Microsoft Store Install Service.

Controlling Samsung Signage QB13R-T based on Unifi Protect

I ended up using Samsung QB13R-T as a display for my Grafana dashboards. This is how I control it’s power state based on Unifi Protect motion detection.

Data from home – Info Display

Earlier this year I wrote 5 posts about gathering and visualizing the data from our home. I think I got some valuable results. Having done such effort I felt that I could put the results for a better use. That means having an info display at a wall of our home. I’m planning to write […]

Batch create mailbox folders with GRAPH API

Back to Microsoft 365 and Powershell! This time an example on creating mailbox folders with GRAPH API.

Data from home – alerting and water shutoff (Part 5)

Couple of examples of alerting with Grafana and reacting to those with IFTTT. Building an example of how to protect from water leaks with these techniques.

Data from home – district heating, computer vision (Part 4)

My first touch to computer vision. Reading the display of my district heating meter with OpenCV and importing the results to Prometheus.

Data from home – energy analyzer, requests against webUI (Part 3)

Gathering realtime data from my electricity meter by means of mimicking WebUI calls with Python. Showing the results in Grafana.

Data from home – wireless water meter (Part 2)

Learning to read my wireless watermeter and reporting the results with Grafana. A simple process that took me nearly two years!

Data from home – setup and preliminary results (Part 1)

Description about the setup I have been building for data related to my home. What I wanted, how I did it and what came out of it.