Modify project selection The new project selection has two advantages: 1. It's possible to create and run e.g. projects a and aa Therefore it is possible to create a hirarchy again. 2. When inserting the project key only letters for valid projects are accepted. E.g. two projects exists aa and ab. In that case it is not possible to insert ac. Only a will be shown in the footer.

#!/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;
}