view README @ 15:0bb0100b2c8d

Added a script to sort zeiterfassung.txt files by date. Useful to merge them.
author Sascha L. Teichmann <teichmann@intevation.de>
date Tue, 09 Sep 2008 21:43:00 +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)