JDatebook2CSV

Last update: 27^th October 2002
Latest Documentation / zip / sit

written by:

Juergen Schwister / Cologne / Germany
MailTo:Juergen.Schwister@gmx.net
http://home.vr-web.de/jSwi

A small framework written in java to list the internal DatebookDB.pdb (Name: DatebookDB, Creator: date, Type: data) of the Palm. It is compatible with PalmOS 2.0 or better.

PalmOS 1.0 should work too, but isn't tested.

Up to now, the format of the DatebookDB has not been changed. It is not the File used by the PalmDesktop; use Pilo-xfer or other tools to export the database from your palm to the platform you prefer. It runs with Java 1.1 or better.

This software is Freeware, but not for comercial use. Conatct the author for further questions. Syntax:

using a JDK (Java Development Environment):

java -cp Datebook2CSV.jar STARTER Datebook2CSV DatebookDBFileName CSVDumpFileName [dateFormatString] [value Separator]

using the JRE (Java Runtime Environment)

JRE -cp Datebook2CSV.jar STARTER Datebook2CSV DatebookDBFileName CSVDumpFileName [dateFormatString] [value Separator]

The default value for the DateFormatstring is "YYYY-MM-DD" and for the valueSeparator is it a ",".

The File Datebook2CSV.JAR has to be included to the classpath or provide it with the -cp parameter to the Java Virtuell Machine.

The DateFormatString has to contain the tokens YYYY, MM, DD
For a example refer to Documentation of the Date format The CSV (comma seperated values) File lists the following fields:

Name Type Description

UID Number Unique (record) Identifier
Type 1 Byte M = Master Record, means it is an repeating event
S = Slave (is an repeated master event) the related Master record can be found by the UID
U = Unique (none repeating event)
Date String Startdate of the event (Format is the third console parameter; default: YYYY-MM-DD
S_Time 5 Bytes start time of the event (Format HH:MM) 24 is the max value for the hh value If not time is set, there will be an empty String >""<
END_Time String end time of the event. If it is an untimed event, there will be an empty value >""<
DESC String Description of the event
NOTE String Note, attached to the event

Name	Type	Description
UID	Number	Unique (record) Identifier
Type	1 Byte	M = Master Record, means it is an repeating event S = Slave (is an repeated master event) the related Master record can be found by the UID U = Unique (none repeating event)
Date	String	Startdate of the event (Format is the third console parameter; default: YYYY-MM-DD
S_Time	5 Bytes	start time of the event (Format HH:MM) 24 is the max value for the hh value If not time is set, there will be an empty String >""<
END_Time	String	end time of the event. If it is an untimed event, there will be an empty value >""<
DESC	String	Description of the event
NOTE	String	Note, attached to the event

It was really hard work to list all the repeting events. The repeating event will only be listed to the current date (it it is not terminated by a due date).

Repeating events will be resolved to the last event that is in your Datebook.

Deleted events will not be listed.

No other Database can be listed with it.

Any comments are appreciated.

Kind regards

Juergen Schwister

Wish list

-none- (report some!!)

Known bugs

-none- (so report some, if you find them. Thanks to all who already did it)

History (YYYY-MM-DD vX.XX)

2002-03-12 v1.3
- Enhancement Value Separator can be provided by the command line
- Enhancement Dokumentation is HTML Files
- Enhancement Testet with MAC OS 9.1.x; compliant to Java 1.1.8 or better.
- Changed Command line parameters have been changed

2000-11-02 v01.20
- the format of the date (third field) can now be defined as console parameter

2000-10-28 v01.10
- values are now surounded by >"<<
- column labels are now the first line of the csv file
- if start_time or stop_time is not filled (untimed event) there will be a emtpy field >""<
- added a copyright

2000-10-10 v01.00
- initial Release