Datebook2CSV v1.4

last update: 1st April 2007
Latest Documentation / zip / sit
Database name:DatebookDB
Database Creator:date
Database Type:data
Type:Freeware

A Java desktop Application to export the content of the DatebookDB.pdb to a CSV file

latest change:

This is a Java Desktop Application for MAC, Windows, Linux and all Plattforms supporting Java 1.1.8 or better.
To run this software you need a Java Runtime Environment (JRE) or Java Development Kit (JDK).

You have to install a Jave Runtime Invironment like it is distributed by SUN, IBM or Apple. Up to now it has no GUI. It is a comand line driven utility. For Apple you can use Tools like JShell or JBindery to run the Application from the shell.

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

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.

Tested on Palm OS 3.3, 3.4, 4.0 and 5.0.

Any distribution of that Software via CD-ROM, Internet or other media without the permission of the author is not allowed.

This software can be used free of charge, except for commercial use. Please refer to the licence agreement for further details. Conatct the author if you have any further questions.

These applications are distributed as archives files. To extract the original files from an archive, you can use WinZip (.zip) for Windows or StuffIt Expander (.sit) for Macs.

Any comments are appreciated.

Kind regards

Juergen Schwister

wish list

Known bugs

History

by Jürgen Schwister @ http://www.jSwi.de