ToDo2CSV v1.3

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

A Java desktop application to export the ToDoDB.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 export the internal ToDoDB.pdb to a CSV file.
(Creator: todo, Type: data) of the Palm. It is compatible with PalmOS 1.0 or better.
Up to now, the format of the ToDoDB has not been changed.
It is not the ToDo.dat File used by the Palm Desktop; use Pilo-xfer or other tools
to export the database from your palm to the platform you prefer.
It runs with Java 1.2 or better.

Syntax:
  • java STARTER ToDo2CSV ToDoDB.pdb ToDo.CSV [dateFormatString]

  • JRE STARTER ToDo2CSV ToDoDBD.pdb ToDo.CSV [dateFormatString]
The ToDo2CSV.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.
Some examples:
Formatresult
YYYY-MM-DD2000-11-02 (2nd of November 2000)
DD.MM.YYYY02.11.2000
DD.MM.02.11. (the year will be skipped)
#DD-MM-YYYY##02-11-2000#
DD.GG.YYYY 02.GG.2000 (hups, you do not have to try this ;-))

YYYY will be replaced by the year (4 digits)
MM will be replaced by the month (2 digits with leading zero if less 10)
DD will be replaced by the date (2 digit with leading digits if less 10)
Don not use the ["] in that string, if there is a blank in it enclose it by ["].
The CSV (semicolon seperated) File lists the following fields:

No. Name Type/Size Note
1. UID Number Unique (record) Identifier as INT16
2. DONE varchar true if completed
false if still open
3. CATEGORY varchar Label of the Category the ToDo is assigned to
If empty it will be assigned to unfiled.
4. DUE_DATE varchar due date of the ToDo (Format is the last console parameter)
default: YYYY-MM-DD, empty if untimed.
5. PRIORITY 1 Byte Priority in the range from 1 to 5
6. DESC varchar Description of the event (Varing size, without CRLF)
The line wrap of the palm is substiuted by a \n
8. NOTE varchar Note, attached to the ToDo
9. ... ... hups, nothing more up to now...


Deleted ToDo's will not be listed.
There will be a second file generated with the suffix ifo.
That file will be used to generate a toDoDB.pdb from the CSV file.
Look at the documentation of JToDoCSV2PDB.
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