teichmann@1: #!/usr/bin/awk -f teichmann@1: teichmann@1: # Convert classic worklog projects file to SQL statements for inseration in the getan database. teichmann@1: # USAGE: teichmann@1: # ./convert-projects </PATH/TO/projects | sqlite3 time.db teichmann@1: teichmann@1: BEGIN { FS=":"; } teichmann@1: teichmann@1: /[^# \t]/ { teichmann@1: printf "INSERT INTO projects (key, description) VALUES ('%s', '%s');\n", $1, $2; teichmann@1: }