Add new template zeiterfassung-hierarchy1 * Add template for getan-report for the use case where hierarchical project keys are used to select the workpackages within a project. The grouping within the new template is done the way it is, because a second attribute lookup is not possible in Jinja2, when having just an entry it is not possible to get the `projects[entry.project_id].key`.

#!/usr/bin/awk -f

# Convert classic worklog projects file to SQL statements for inseration in the getan database.
# USAGE:
# ./convert-projects </PATH/TO/projects | sqlite3 time.db

BEGIN { FS=":"; }

/[^# \t]/ {
    printf "INSERT INTO projects (key, description) VALUES ('%s', '%s');\n", $1, $2;
}