view README @ 191:64624032611d

Add function to convert from iso to unix week For evaluation we use the iso week as week parameter which is commonly known in europe. But SQLite internally uses unix weeks which may differ. Therefore convert the iso week to the unix week.
author Björn Ricks <bjoern.ricks@intevation.de>
date Thu, 17 Jan 2013 11:41:36 +0100
parents 13a963546ee9
children b6e91535acb7
line wrap: on
line source
0 - install pysqlite2 

    On Debian GNU/Linux just do:

    # apt-get install python-pysqlite2 
    # apt-get install python-urwid

    NOTE: getan requires urwid >= 0.9.9.1.

1 - create new time.db

    To create an empty database you need the 'sqlite3'
    commandline tool. TODO: This will change.

    # apt-get install sqlite3

    $ echo '.read schema.sql' | sqlite3 time.db

2 - adding new projects to time.db:

    $ sqlite3 time.db
    sqlite> INSERT INTO projects (key, description) VALUES ('f', 'FOO');
    sqlite> INSERT INTO projects (key, description) VALUES ('b', 'BAR');
    sqlite> .q

    To import an old worklog configuration you may use:

    ./contrib/convert-projects </PATH/TO/projects | sqlite3 time.db

    If you want to keep the reverse task order of the original config
    file you might pipe it through tac first.

3 - starting getan:

    $ ./getan.py

    or

    $ ./getan.py mytime.db

    or (for the classic version of 'getan' based on curses):
    $ classic/getan

    or

    $ classic/getan mytime.db
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)