You are here

Portable Address Book

2 posts / 0 new
Last post
marthazim
Offline
Last seen: 9 years 6 months ago
Joined: 2008-10-05 14:13
Portable Address Book

Could someone please develop a portable address book with person's name, spouse's name, children's names (up to 10 spaces), business name, business address, personal address, multiple email address, website URL, home phone, business phone, multiple mobile phone, birthday for each person, and notes. Catagories and Sort capabilities for those catagories would also be quite helpful. An import from a spreadsheet, and export to a spreadsheet would be great.

alanbcohen
Offline
Last seen: 5 years 5 months ago
Joined: 2006-01-04 10:47
Try the following in SQLite

Try the following in SQLite (or any other SQL-based database). I know SQLite is free (open source) and portable. You can find it by doing a websearch easily. You will also find related tools like data browsers to assist you. SQL syntax for create table, insert into, select, and other SQL commands are found on the same website. Sorry, the import and export of data is currently beyond my capabilities, but OpenOffice.orgPortable should be able to save most spreadsheet info into a database.

Create table addressbook
( name char(50),
spouse char(50),
child01 char(50),
child02 char(50),
child03 char(50),
child04 char(50),
child05 char(50),
child06 char(50),
child07 char(50),
child08 char(50),
child09 char(50),
child10 char(50),
businessname char(150),
businessaddress char(150),
personaladdress char(150),
email char(50),
website char(50),
homephone char(20),
businessphone char(20),
mobilephone char(20),
namebday date,
spousebday date,
child01bday date,
child02bday date,
child03bday date,
child04bday date,
child05bday date,
child06bday date,
child07bday date,
child08bday date,
child09bday date,
child10bday date,
category char(10),
notes char(254));

Log in or register to post comments