Address2CSV - Full v1.2

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

A Java Desktop Application to export the AddressDB.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 small framework written in java to list the internal AddressDB of the Palm.

The output file is a CSV (comma Seperated values, ok here is a semicolon used) It is not the File used by the PalmDesktop; use Pilo-xfer or other tools to export the database from your palm to the platform you prefer. It runs with Java 1.1 or better.

Syntax:

using a JDK (Java Development Kit):
   java -cp Address2CSVFull.jar STARTER Address2CSVFull pdbFileName TXTDumpFileName

using a JRE (Java Runtime Environment):
   jre -cp Address2CSVFull.jar STARTER Address2CSVFull pdbFileName TXTDumpFileName

Be careful, the Java Runtime environment is case sensitve.

Deleted records will not be listed. The column labels are in the first row of the File. Most of the labels are localized, the values are in the AppInfo Area of the AddressDB.pdb

Columns in the CSV File
# name description
1. UID Unique record identifier
2. Categorie Name of the categorie
3. Lastname Label is localized (it depends on the language of the Palm OS you are using)
4. Firstname Label is localized
5. Title Label is localized
6. Company Label is localized
7. Tel_1_Label Label of the first contact information
8. Tel_1 first contact information
9. Tel_2_Label Label of the second contact information
10. Tel_2 second contact information
11. Tel_3_Label Label of the third contact information
12. Tel_3 third contact information
13. Tel_4_Label Label of the fourth contact information
14. Tel_4 fourth contact information
15. Tel_5_Label Label of the fifth contact information
16. Tel_5 fifth contact information
17. Display_Tel Number of the Phonenumber to display
18. Address Label is localized
19. City Label is localized
20. State Label is localized
21. ZipCode Label is localized
22. Country Label is localized
23. Custom1 Label depends on the defined value
24. Custom2 Label depends on the defined value
25. Custom3 Label depends on the defined value
26. Custom4 Label depends on the defined value
27. Note Label is localized
No other Database can be listed with 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

Known bugs

History

by Jürgen Schwister @ http://www.jSwi.de