Fog Creek Software
Discussion Board




Extracting Exchange Info

I wanted to extract a contact list from the company I work at. Nothing nefarious in mind, I simply wanted to have everyone's name, phone#, email, and location code so that I can feed my PDA and have a backup at home in case I needed to contact someone.

Anyhow, I couldn't find any usable info, so I had to call the Lotus Notes (ugh) admin and was told that Exchange has 80% of the info and Notes has the other 80% ;-). I don't mind stitching data, but he told me that Exchange can only dump out the whole user record (name + ton of sensitive/personal HR info). I haven't worked with Exchange in years, but this seems silly to me.

Can anyone tell me, does my request (name, phone#, email, and location) sound possible from an Exchange point of view without jumping through hoops or dumping personal information?

StickyWicket
Tuesday, September 16, 2003

Yes.

Use ADO & ADSI LDAP Provider

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/_esdk_arch_prog_tech.asp

Click ADO.

--
ee

eclectic_echidna
Tuesday, September 16, 2003

You can open an exchange pst file in MS Access as an ODBC data source.

pdq
Tuesday, September 16, 2003

Also typically in my experience if the data is held as a list of contacts, you can move this to a personal folder and then export as a CSV.

Like a previous poster says, you can access the data as a data source.  If you choose to import or link tables in Access you can do this.

Konrad
Tuesday, September 16, 2003

What version of Exchange? If its more recent than 5.5 then Exchange doesn't hold any contact info at all really, its all stored in active directory.

And there is a *ton* of ways to extract the info you want from that, permisisons...uh.. permitting, of course. LDAP probably being the simplest way.

Robert Moir
Tuesday, September 16, 2003

or you can access the address book through http. if you have an existing ldap client, ldap will be easier; if not, http might be. (or might not--i don't think the address book interface is very nice.)

mb
Wednesday, September 17, 2003

*  Recent Topics

*  Fog Creek Home