
written by
Juergen Schwister / Cologne / Germany
mailto:Juergen.Schwister@GMX.NET
http://home.vr-web.de/~jSwi


A Java Jar File to dump the built-in ExpenseDB.pdb of the Palm.
It should be compatible with all kinds of Palm os. Up to now the file format 
of the ExpenseDB has not been changed.
Export the Database using tools like pilot-xfer or backup Buddy.

The labels of the columns are listed in the first line of the dumpfile.

Syntax:

using a JDK:

	java -cp Expense2CSV.jar STARTER  Expense2CSV pdbFileName CSVDumpFileName [dateFormat]
	java -classpath Expense2CSV.jar STARTER Expense2CSV pdbFileName CSVDumpFileName [dateFormat]

if you have just installed the runtime environment:

	jre -cp Expense2CSV.jar STARTER Expense2CSV pdbFileName CSVDumpFileName [dateFormat]
	jre -classpath Expense2CSV.jar STARTER Expense2CSV pdbFileName CSVDumpFileName [dateFormat]



The Expense2CSV.JAR has to be included to the classpath or provide it with
the -cp or -classpath parameter to the Java Virtuell Machine.
Be careful, the Java Runtime environment is case sensitve.

The DateFormatString has to contain the tokens YYYY, MM, DD 
Some examples:

	Format		result

	YYYY-MM-DD   	2000-11-02 (November 2nd 2000)
	DD.MM.YYYY  	02.11.2000
	DD.MM.		02.11.	(the year will be skipped)
	#DD-MM-YYYY#    #02-11-2000#
	"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)
Dont not use the >>"<< in that string, if there is a blank in it enclose 
the whole string by >>"<<.



The columns are:
 1.	UID         -> Unique Record Identifier
 2.	Date        -> Date of Entry depends on the third parameter
 3.	ExpenseType ->  
 4.	Currency    -> 
 5.	Amount      -> just a string, be careful while you parse
 6.	Categorie   ->
 7.	Payment     ->
 8.	Vendor      ->
 9.	City        ->
10.	Attendees   ->
11.	Note        ->

Deleted records will not be listed !
The records in the ExpenseDB.pdb are sorted by Date, no additional sorting is done.
No other database can be listed with that jar file.

The Software is freeware. For commercial use contact the author.

Any comment is appreciated.

Kind regards

Juergen Schwister

------------------------------
History


2001-01-29 v01.22
    - length check to AppInfo removed (on MAC it is 512 bytes ?!)

2001-01-23 v01.21
    - STARTER class is now declared public, otherwise it will not work
      with some environment, expecialy MAC

2000-11-04 v01.20
	- only the indexes of the label fields will be exported.
	  use JExpense2CSVFull to dump the labels as strings
	- a .IFO File is generated, it is used by JExpenseCSV2PDB
	  to generate a ExpenseDB.pdb

2000-11-04 v01.10
	- DateFormat can be supplied by the console (third parameter)

2000-10-18 v01.00
	- initial Release