annotate 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
rev   line source
0
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
1 0 - install pysqlite2
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
2
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
3 On Debian GNU/Linux just do:
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
4
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
5 # apt-get install python-pysqlite2
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
6
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
7 1 - create new time.db
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
8
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
9 To create an empty database you need the 'sqlite3'
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
10 commandline tool. TODO: This will change.
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
11
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
12 # apt-get install sqlite3
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
13
1
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 0
diff changeset
14 $ echo '.r schema.sql' | sqlite3 time.db
0
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
15
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
16 2 - adding new projects to time.db:
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
17
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
18 $ sqlite3 time.db
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
19 sqlite> INSERT INTO projects (key, description) VALUES ('f', 'FOO');
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
20 sqlite> INSERT INTO projects (key, description) VALUES ('b', 'BAR');
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
21 sqlite> .q
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
22
1
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 0
diff changeset
23 To import an old worklog configuration you may use:
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 0
diff changeset
24
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 0
diff changeset
25 ./contrib/convert-projects </PATH/TO/projects | sqlite3 time.db
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 0
diff changeset
26
3
1513c716eef0 - Added total sum of all projects.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 1
diff changeset
27 If you want to keep the reverse task order of the original config
1513c716eef0 - Added total sum of all projects.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 1
diff changeset
28 file you might pipe it through tac first.
1513c716eef0 - Added total sum of all projects.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 1
diff changeset
29
0
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
30 3 - starting getan:
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
31
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
32 $ ./getan
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
33
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
34 or
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
35
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
36 $ ./getan mytime.db
7eb7886ed8fd Initial import.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
diff changeset
37
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)