view contrib/convert-projects @ 131:3d5232dad59a

Add methods to reset the ProjectList footer When going back from the move state ist must be possible to restore the old footer entry in the ProjectList. The footer may be overriden by the move state to select a project. In this case the old entry should be restored instead of showing a blank footer.
author Björn Ricks <bjoern.ricks@intevation.de>
date Wed, 31 Oct 2012 09:53:57 +0100
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)