teichmann@0: 0 - install pysqlite2 teichmann@0: teichmann@0: On Debian GNU/Linux just do: teichmann@0: teichmann@0: # apt-get install python-pysqlite2 ingo_weinzierl@23: # apt-get install python-urwid ingo_weinzierl@23: ingo_weinzierl@23: NOTE: getan requires urwid >= 0.9.9.1. teichmann@0: teichmann@0: 1 - create new time.db teichmann@0: teichmann@0: To create an empty database you need the 'sqlite3' teichmann@0: commandline tool. TODO: This will change. teichmann@0: teichmann@0: # apt-get install sqlite3 teichmann@0: teichmann@1: $ echo '.r schema.sql' | sqlite3 time.db teichmann@0: teichmann@0: 2 - adding new projects to time.db: teichmann@0: teichmann@0: $ sqlite3 time.db teichmann@0: sqlite> INSERT INTO projects (key, description) VALUES ('f', 'FOO'); teichmann@0: sqlite> INSERT INTO projects (key, description) VALUES ('b', 'BAR'); teichmann@0: sqlite> .q teichmann@0: teichmann@1: To import an old worklog configuration you may use: teichmann@1: teichmann@1: ./contrib/convert-projects