view README @ 11:feb6bb4427fe

Applied a variation of Stephan Holl's zeiterfassung.non-utf8-chars-in-db.patch to force the encoding given by --encoding=.
author Sascha L. Teichmann <teichmann@intevation.de>
date Mon, 04 Aug 2008 12:32:46 +0200
parents 1513c716eef0
children 9c4e8ba3c4fa
line wrap: on
line source
0 - install pysqlite2 

    On Debian GNU/Linux just do:

    # apt-get install python-pysqlite2 

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 '.r 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 

    or

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