JToDoCSV2PDB
Last update: 18th November 2001

written by:

Juergen Schwister / Cologne / Germany
Mobile: +49 151 12 11 87 70
MailTo:Juergen.Schwister@gmx.net
http://home.vr-web.de/jSwi



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.


Any comments are appreciated.

Kind regards

Juergen Schwister
wish list
  • much better documentation
Known bugs
  • -none- (so report some, if you find them)

History (YYYY-MM-DD vX.XX)

  • 2001-11-18 v1.3
     
    • added 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.
       
    • added UID is now a simple number, start with 1 and not 0 of you start out of scratch.
       
  • 2001-11-12 v1.2
    • service release

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

  • 2001-05-14 v1.0
    • initial Release