ToDoCSV2PDB v1.3

last update: 16^th August 2006
latest Dokumentation / zip / sit

Database name:	`ToDoDB`
Database Creator:	`todo`
Database Type:	`data`
Type:	Freeware

A Java Desktop Application to create from a CSV File the ToDoDB.pdb file

latest change:

2001-11-18 v1.3
- enhancement Category now can be either the index of the Categorie or the Label. If it contains just numbers and is less or equal 15 it is assumed to be a labelindex.
- enhancement UID is now a simple number, start with 1 and not 0 of you start from the scratch.

This is a Java Desktop Application for MAC

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 create the internal ToDoDB.pdb from a CSV file, the values must be surounded by double quotes and seperated by a comma not semicolon!
(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 runs with Java 1.1 or better.

Syntax:

java STARTER ToDoCSV2PDB ToDo.CSV ToDoDB.pdb [dateFormatString]

JRE STARTER ToDoCSV2PDB ToDo.CSV ToDoDB.pdb [dateFormatString]

The ToDoCSV2PDB.JAR has to be included to the classpath or provide it with the -cp parameter to the Java Virtuell Machine.
Have a look at DateFormat for further information about the dateFormatString.

There will be a second file needed with the suffix ifo.
If the filename of the CSV File is ToDoDB.csv the name of the ifo File must be ToDoDB.csv.ifo !
That file will be used to generate a toDoDB.pdb from the CSV file.
It contains the names of the categories, sortOrder etc.
Look at Sample IFO File and the Documentation
Just add the catgories that you use.
No other Database can be created with it.
The Columnlabels must be:

UID
sequence number
DONE
0|false = uncheck, not completed
1|true = checked, completed
CATEGORY
label must be in ifo file, or it is in the unfiled categorie
DUE_DATE
Date in the dateFormatString
PRIORITY
value from 1 to 5
DESC
Text
NOTE
Text

This Software is Freeware. If you like it, use 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

much better documentation

Known bugs

-none-

History

YYYY-MM-DD vX.XX

2001-11-18 v1.3
- enhancement Category now can be either the index of the Categorie or the Label. If it contains just numbers and is less or equal 15 it is assumed to be a labelindex.
- enhancement UID is now a simple number, start with 1 and not 0 of you start from the scratch.

2001-11-12 v1.2
- enhancement service release

2001-xx-xx v1.1
- not Released to public

2001-05-14 v1.0
- initial Release

by Jürgen Schwister @ http://home.vr-web.de/jSwi