Address2CSV v1.3

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.

Look here to read more about pdb's.
It runs with Java 1.1 or better. Please refer to that documentation to get know more about java.

Syntax:

using a JDK:

   java -cp Address2CSV.jar STARTER Address2CSV pdbFileName CSVFileName

if you have just installed the runtime environment:

   jre -cp Address2CSV.jar STARTER Address2CSV pdbFileName CSVFileName


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.

A File with suffix IFO is created containing the labels shown in the
Address Application of the Palm. It is used for creating a pdb from
the csv file (JAddressCSV2PDB).

Columns in the CSV File


Column Name Type Description
UID Integer Unique record identifier.
Categorie Integer or String You can either provide the index of the Categorie (starting with zero -0-)
or the label of the categorie e.g. "unfiled".
It must be the same string (case sensitive) as in the IFO File [Categorie] Section.
Lastname String  
Firstname String  
Title String  
Company String  
Phone_1_Index integer Index of the Phone Label (starts with zero -0-).
Have a look at the IFO File for further information
Phone_1 String contact information
Phone_2_Index Integer  
Phone_2 String contact information
Phone_3_Index Integer  
Phone_3 String contact information
Phone_4_Index Integer  
Phone_4 String contact information
Phone_5_Index Integer  
Phone_5 String contact information
Display_Tel Integer  
Address String  
City String  
State String  
Country String  
Custom1 String  
Custom2 String  
Custom3 String  
Custom4 String  
Note String  



No other Database can be listed with it.
The "new Line/ line feed" character is replaced by \n, Tab by \t
and "Carriage return" by \r.

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