This simple Automate flow plays custom alarm-like sound, when your phone receives a SMS message which contains “alarm” word in it.

It could be useful, when you want for example play custom alarm for specific server events. As it is SMS based, it will not require mobile data transfer turned on.

How to set it up? You will need Automate app to be installed on your phone. Then you can download and import the flow from here:

or set it up yourself following the steps from this video:


Using ffmpeg to convert them to prores

DaVinci Resolve in a Free version doesn’t support importing media ecnoded with popular encoding format. You can find on the internet some solutions to this problem, but they need importing the files to one program then exporting etc… This takes a lot of time. The Coding Cat found a simple solution for this. Just use ffmpeg (avconv should work also) and use a command below:

ffmpeg -i YOURFILE.mp4 -c:v prores -profile:v 3 -c:a pcm_s16le

Replace YOURFILE.mp4 with your file name, and you will need to have ffmpeg installed on your system.

After the process is completed, there will be a new file in “mov” format, that you can import into DaVinci Resolve

Convert all files in the directory

There is a command to convert all mp4, mts, mov files in the current directory. It doesn’t convert already converted files

find . -maxdepth 1 -type f \( -iname "*.mp4" -o -iname "*.mov" -o -iname "*.mts" \) ! -iname "*" -exec sh -c "[ ! -f {} ] && ffmpeg -i {} -c:v prores -profile:v 3 -c:a pcm_s16le {}" \;

Note: It was tested on Linux and Mac. Videos were from Sony A5000, Nikon P900 and GoPro 7

This is a story of making an app called Riskometer. The aim of the app was to prevent coronavirus to spread. I will explain how the idea worked from the programmer point of view. Finally the app didn’t start off, because the polish government (which we were talking with for about 3 weeks) refused it, I’ll explain why in the later part.


In march 2020, in the time of the biggest lockdown, one of my colleges asked me to join the team that is working on the app for preventing coronavirus. In the team there was already about 30 people, but they didn’t have any programmers. I joined, cause I like interesting projects and I thought what bad can possibly happen. Maybe our app will save someone’s life.. That was worth the try.


The idea was simple .. in theory. Google is saving history of location of your mobile device if you have Google account connected – most people have. Now the app should take this data, and analyze it, comparing with location history of people that had covid-19 diagnosed. First, my job was to check out if it is even possible to do with the data that is provided by Google Takeout json files – the only way to get this location history. The big json file in the Takeout contains only GPS coordinates, timestamps and type of transport. The problem with this data was, the GPS coordinates are not accurate here. It can be checked if someone’s path crossed the path with someone infected, but with very bad accuracy – they can be on other side of a street for example. Also checking that someone crossed the path with the infected one was not the point at all. From the government, we’ve get restrictions, when we can assume that someone had a contact with COVID-19 infected person:


  • a person lives in the same house with someone infected by COVID-19
  • a person had direct physical contact with someone infected by COVID-19
  • a person had contact with someone infected by COVID-19 in less than two meters and more than 15 minutes 
  • a healthcare worker or another person that looks after someone infected by COVID-19
  • a person that was in the same plane in the distance of two places (each direction) with someone infected by COVID-19


We’ve focused on the point when you meet infected person for 15 minutes in less than 2 meters. That was not possible to check it just with the GPS coordinates from Google Takeout. Fortunately in the zip package, there was more files that we could use. There was a folder named “Semantic Location History” that contained JSON files for each month with a bit different data. There was more useful data including activities and visited places in the sequence of visited place -> activity -> visited place -> activity..

For example if you were in some place (house, shop, mall) or you’ve travelled from place A to place B indicating which type of transport did you use like car, bus, on foot etc. 

The most accurate result that we could get from the data that worked with the rule “2 meters for 15 minutes” was to detect if someone travelled in a car with infected one. That was very easy to check with this data. There is information about starting place, ending place, starting time, ending time and type of transport. If this parameters equals to the data of another person, that is very highly probable, that those two people was travelling in the same car, so the distance between them must have been less than two meters. 

Other options were to check if someone was working in the same place, if someone live in the same house, if someone was in a shop / barber / dentist etc. where worked someone infected. But they were not as accurate as travelling in the car, so it ended just as additional information in the app that can be shown.


In the first few days of the project we’ve asked volunteers on our Facebook group to get 100 Google Takeout json files (from 100 different people), for the demo. We’ve get them in 3 days, so we could start with creating the mvp. The app was a very simple php (symfony + propel) application that analyzed the json files and put them into the database. After you uploaded your Google Takeout zip file, It just checked if you travelled with someone infected (randomly at first) in a car, or have you been in same place and then displaying you a list of these activities.


The results in this mvp looked like this:



The main problem with the Google Takeout zip packages was providing them by the user. To download the package, user has to login into his Google account, navigate to, from the list of available data select only location history and then click on export. Then he waits until the package is ready for download (may be a few minutes) and then finally he can download the takeout file. After the file is downloaded, he can upload it to the app, or extract the zip package and select json files from only last month. 


The process was too complicated for a regular person, we had to automate it a bit.  From Google there was no any API, or any other way to get this data. There was no way to automate it using just a web application. 


With another programmer who recently joined the team working on bluetooth-based module for the application, we came out with an idea of using WebView component to click-through the whole download process. The only thing that user had to do was to login into his Google Account, with all the steps running automatically in the background. Two of us (with some help in design and styling from other people), we’ve made a working mobile app in just one weekend. It worked as it was expected, the user opened the app, logged into his Google account, and after clicking the start button all the magic happened. In the hidden WebView component, the injected javascript code clicked on each button to finally download the file. After the app detected that the file is downloaded, it unpacked the zip and uploaded required json files to the server and displaying the result.


That was how the final version of the app looked like:





After presenting the app to the government they asked us how much it will be cost for servers for maintaining the server side code. That was really hard to guess. With a help of another programmer that is a specialist in AWS, we’ve came out with the maximum monthly price of €50k (for a whole nation using it, about 0.2 cents for person a month). After this the whole situation all started to be rough. Now the method of gaining the data from users was the problem (GDPR), there was problem that Google may be not able to maintain all the exports at the same time. Even some professor related to the government send an email to everyone involved, that the whole idea of the app is completely wrong, and he presented his research that the GPS coordinates are not accurate, because it can’t be compared to his professional gps. He didn’t even analyze the way of our app worked, but it didn’t matter. After that the whole project was down. The government said that they will pick some other project, and they did. They’ve chosen a company called Polidea that was making an open-source app called ProteGo Safe

Temporarily, We Transfer Files which stands for Temporarily, We Transfer Files, is the Coding’s Cat new web app. If you want to just quickly share a few files with your friend, without registration etc. this service is for you. The files will be removed after seven days.


Get the source code

The second reason why the app was created is to show use case for the upload widget. The whole project was created in just a few hours and if you wan’t to get the source code (NodeJS), send an email on

The Coding Cat got some document that he could not read on his Android phone or iPad showing only error because of read only mode that the mobile devices could not handle. He needed it on other devices than his PC, so he wrote a little ‘hack’  in JS.

Note 1: It was tested on Chrome Browser.

Note 2: It converts pages to jpg images. The Coding Cat thinks it could be done preserving text, but he didn’t have more time for this and jpg solution was sufficient.

Note 3: If you’re getting only part of the document visible, try zooming out your browser and then run the script.

Step by step:

  1. Open the document in Google Docs
  2. Scroll to the bottom of the document, so all the pages are present
  3. Open Developer Tools on separate window and choose the Console tab
  4. Paste the code below (and hit enter)
    let jspdf = document.createElement("script");
    jspdf.onload = function () {
        let pdf = new jsPDF();
        let elements = document.getElementsByTagName("img");
        for (let i in elements) {
            let img = elements[i];
            console.log("add img ", img);
            if (!/^blob:/.test(img.src)) {
                console.log("invalid src");
            let can = document.createElement('canvas');
            let con = can.getContext("2d");
            can.width = img.width;
            can.height = img.height;
            con.drawImage(img, 0, 0, img.width, img.height);
            let imgData = can.toDataURL("image/jpeg", 1.0);
            pdf.addImage(imgData, 'JPEG', 0, 0);
    jspdf.src = 'https'+'://'+'cdnjs'+'.cloudflare'+'.com/ajax/libs/jspdf/1.5.3/jspdf.debug.js'; /* had to set it like this, because disqus was breaking the link.. */
  5. Now the PDF should be downloaded


What it does? It iterates trough the document checking for images (Google Drive stores pages as images) then writes it’s contents to a PDF.

Leave a comment if it works for you.