view contrib/convert-projects @ 273:a5c5675b6fa4

Give more "weight" to the description when displaying the project node entry With this change the project description will get more space in the row then the time. This avoids cutting long description texts even if the there is enough free space. With urwid 1.1 it would even better to user ("pack", time) for this.
author Björn Ricks <bjoern.ricks@intevation.de>
date Fri, 12 Apr 2013 09:34:18 +0200
parents a3fe8e4e9184
children
line wrap: on
line source
#!/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;
}
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)