weidner -> computer -> palm -> coldsync de EN
Stand: 2001-12-17
(2001-06-25)

date-titrax

This conduit extracts the titrax logs from the datebook and writes them into a text file or in a SQL database.

Usage

Add the following to your .coldsyncrc file and substitute the places marked with <...> as appropriate: 

conduit dump {
    type: date/DATA;
    path: "<...>/date-titrax";
    arguments:
	Target: Text # or SQL
        Where:  /home/<yourself>/.titrax;
	SQLdsn: dbi:mysql:titrax
	SQLuser: username
	SQLpass: password
}

path is the full path to the conduit and Where names a directory into which the textfile will be written.

The date-titrax conduit extracts titrax logs from the built-in Palm DateBook application, and dumps it into a rather simple text format. Here is an example of the sort of file that date-titrax generates: 

Log-date:     2001-05-21
Project-name: Palm Development
Elapsed-time: 0:55

01-06-21 22:01-01-06-21 22:56
Started working on conduit date-titrax

This format should be fairly self-explanatory. The first line contains the date the titrax log was saved to the datebook; the next one contains the project name; the elapsed time since last saving to datebook for this project on the third line. After an empty line follows the text from the projects note. Every Entry starts with a line named "Log-date:" and is closed by an empty line after the project note.

Subsequent entries follow in the same manner.

Any occurence of 'Log-date: ' at the beginning of a line in the project note (regardless of case) is preceded with a '>' to allow for simple parsing of the titrax logfile.

Alternatively these data can be written into a SQL database.

The schema for the tables with MySQL looks like this: 


CREATE TABLE date_titrax (
  tid int(11) NOT NULL auto_increment,
  tproject varchar(255) NOT NULL default '',
  tdate date NOT NULL default '0000-00-00',
  ttime int(10) unsigned default NULL,
  tcomment text,
  PRIMARY KEY  (tid),
  UNIQUE KEY tproject (tproject,tdate)
) TYPE=MyISAM;

Download

References

  1. ColdSync - a tool for synchronizing PalmOS devices with Unix workstations
    http://www.ooblick.com/software/coldsync/