At FSFE, each staff member used to send weekly timelog reports to a council via email. This instance has been created to automate this process.

Automation Steps

The process consists of several steps:

1. A dedicated account on our Nextcloud is created, that has access to the timelog.txt files of all staff members.

2. This account is mounted in a Docker container with help of davfs2.

3. In the Docker build process, report.sh file is copied into the container. Additionally, gtimelog-utils is cloned so that weekly.py can be used. See the Dockerfile.

4. Drone builds the container through Docker-Compose using the Drone Secrets.

5. Every Monday at 02:00, report.sh is executed, applying weekly.py to all timelog.txt files and generating the report from two weeks ago for each staff member. The cron job is set in drone settings.

Run Localy

Docker-compose wants to have the following environment variables:

NEXTCLOUD_URL NEXTCLOUD_USERNAME NEXTCLOUD_PASSWORD

You can either store the values in Drone Secrets or create an .env file for this purpose.