Exporting Outlook Contats to MySQL database

Butters · 4 Jan 2008 at 12:56

Does anyone know of a way to do this or able to provde a quick tutorial or link.

I seem to be hitting a dead end here.

marc2003 · 4 Jan 2008 at 13:15

export to a csv file, open the the file in excel. delete all the columns you don't need. with a little tinkering, you should be able to prepare the file ready to import into mysql.

dan^uk · 4 Jan 2008 at 13:52

1. Export the contacts in outlook as a csv file (windows format) , save as c:\contacts.csv.

2. Execute this MySQL statement (which creates a table called contacts in the active db):

CREATE TABLE IF NOT EXISTS `contacts` (
`Title` varchar(255) default NULL,
`First Name` varchar(255) default NULL,
`Middle Name` varchar(255) default NULL,
`Last Name` varchar(255) default NULL,
`Suffix` varchar(255) default NULL,
`Company` varchar(255) default NULL,
`Department` varchar(255) default NULL,
`Job Title` varchar(255) default NULL,
`Business Street` varchar(255) default NULL,
`Business Street 2` varchar(255) default NULL,
`Business Street 3` varchar(255) default NULL,
`Business City` varchar(255) default NULL,
`Business State` varchar(255) default NULL,
`Business Postal Code` varchar(255) default NULL,
`Business Country` varchar(255) default NULL,
`Home Street` varchar(255) default NULL,
`Home Street 2` varchar(255) default NULL,
`Home Street 3` varchar(255) default NULL,
`Home City` varchar(255) default NULL,
`Home State` varchar(255) default NULL,
`Home Postal Code` varchar(255) default NULL,
`Home Country` varchar(255) default NULL,
`Other Street` varchar(255) default NULL,
`Other Street 2` varchar(255) default NULL,
`Other Street 3` varchar(255) default NULL,
`Other City` varchar(255) default NULL,
`Other State` varchar(255) default NULL,
`Other Postal Code` varchar(255) default NULL,
`Other Country` varchar(255) default NULL,
`Assistant_s Phone` varchar(255) default NULL,
`Business Fax` varchar(255) default NULL,
`Business Phone` varchar(255) default NULL,
`Business Phone 2` varchar(255) default NULL,
`Callback` varchar(255) default NULL,
`Car Phone` varchar(255) default NULL,
`Company Main Phone` varchar(255) default NULL,
`Home Fax` varchar(255) default NULL,
`Home Phone` varchar(255) default NULL,
`Home Phone 2` varchar(255) default NULL,
`ISDN` varchar(255) default NULL,
`Mobile Phone` varchar(255) default NULL,
`Other Fax` varchar(255) default NULL,
`Other Phone` varchar(255) default NULL,
`Pager` varchar(255) default NULL,
`Primary Phone` varchar(255) default NULL,
`Radio Phone` varchar(255) default NULL,
`TTY/TDD Phone` varchar(255) default NULL,
`Telex` varchar(255) default NULL,
`Account` varchar(255) default NULL,
`Anniversary` varchar(255) default NULL,
`Assistant_s Name` varchar(255) default NULL,
`Billing Information` varchar(255) default NULL,
`Birthday` varchar(255) default NULL,
`Business Address PO Box` varchar(255) default NULL,
`Categories` varchar(255) default NULL,
`Children` varchar(255) default NULL,
`Directory Server` varchar(255) default NULL,
`E-mail Address` varchar(255) default NULL,
`E-mail Type` varchar(255) default NULL,
`E-mail Display Name` varchar(255) default NULL,
`E-mail 2 Address` varchar(255) default NULL,
`E-mail 2 Type` varchar(255) default NULL,
`E-mail 2 Display Name` varchar(255) default NULL,
`E-mail 3 Address` varchar(255) default NULL,
`E-mail 3 Type` varchar(255) default NULL,
`E-mail 3 Display Name` varchar(255) default NULL,
`Gender` varchar(255) default NULL,
`Government ID Number` varchar(255) default NULL,
`Hobby` varchar(255) default NULL,
`Home Address PO Box` varchar(255) default NULL,
`Initials` varchar(255) default NULL,
`Internet Free Busy` varchar(255) default NULL,
`Keywords` varchar(255) default NULL,
`Language` varchar(255) default NULL,
`Location` varchar(255) default NULL,
`Manager_s Name` varchar(255) default NULL,
`Mileage` varchar(255) default NULL,
`Notes` varchar(255) default NULL,
`Office Location` varchar(255) default NULL,
`Organizational ID Number` varchar(255) default NULL,
`Other Address PO Box` varchar(255) default NULL,
`Priority` varchar(255) default NULL,
`Private` varchar(255) default NULL,
`Profession` varchar(255) default NULL,
`Referred By` varchar(255) default NULL,
`Sensitivity` varchar(255) default NULL,
`Spouse` varchar(255) default NULL,
`User 1` varchar(255) default NULL,
`User 2` varchar(255) default NULL,
`User 3` varchar(255) default NULL,
`User 4` varchar(255) default NULL,
`Web Page` varchar(255) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

3. You then use MySQL infile statement to load the csv.

LOAD DATA LOCAL INFILE 'C:\\contacts.csv' REPLACE INTO TABLE `contacts`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\r\n';

OR use phpMyAdmin with these settings:

Butters · 4 Jan 2008 at 13:58

Cool, thanks

Two quick questions,

My personal contacts have sub contacts (under contacts), but when I export, it only exports the information held in 'contacts' not any of the contacts sub folders.

Is there a way around this?

Also, is it possible to export public folder contacts (from an exchange server) in a similar way as they do not appear in the list when going through the export wizard.

Butters · 4 Jan 2008 at 14:28

Ok, What I'm doing is using exporting the public folders to a PST file then using the above method, although I still can't see a way around my first problem.