Expense2CSV v1.22

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

A Java desktop Application to export the content of the ExpenseDB.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 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.

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