Address2CSV

Last modified 8th January, 2001

written by

Juergen Schwister
Cologne / Germany
http://home.vr-web.de/jSwi
MailTo:Juergen.Schwister@gmx.net

A small framework written in java to list the internal AddressDB
of the Palm.
Name: AddressDB
Creator: addr
Type: data
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 -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, look at http://www.palmgear.com).

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.

Any comments are appreciated.

Kind regards

Juergen Schwister

History