JToDo2CSV v1.1
Last update: 14^th Mai 2001

---

written by:

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

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:

Format	result
YYYY-MM-DD	2000-11-02 (2nd of November 2000)
DD.MM.YYYY	02.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.

This Software is Freeware. If you like it, use it.

Tested on Palm OS 2.0, 3.1, 3.2, 3.3, 3.5, 4.0.

Any comments are appreciated.

Kind regards

Juergen Schwister

---

wish list

• -none-

Known bugs

• -none- (so report some, if you find them)

History (YYYY-MM-DD vX.XX)

• 2001-11-10 v1.3
   
  • 
    CSV Format has changed !
  • ADDED CATEGORY columns after COMPLETED column
  • CHANGED Format of the UniqueRecordID has changed from byte[3] to INT16


• 2001-09-26 v1.2
   
  • FIXED If no due date was specified there was one field missing instead of an empty field


• 2001-05-14 v1.1
   
  • ADDED a ifo file is generated. (Needed for JToDoCSV2PDB)


• 2000-11-09 v1.0
  • initial Release