Slashdot Mirror
Moving Outlook/vCards to an LDAP Address Book?
T-Suit asks: "I'm looking for a way to move 1000+ vCards (the result of painful consolidation after going through our sales' team personal Outlook contacts) into OpenLDAP, so that we can access them from all plaftorms. I've looked at Dawn, but its LDIF export is too crufty for ldapadd and it doesn't solve the issue of how to update those records easily, so I'd also need some kind of 'master GU' to edit them remotely. Along the way, I must say I am amazed at the lack of good LDAP-only contact manager apps for Windows, Linux and Mac OS X. Besides Evolution (which behaves strangely for me and doesn't show all the fields Outlook entries have), all 'nice' 'shared address book' tools I see are limited, web-based or rely on a SQL database. LDAP Management apps (such as diradmin) allow me to edit all fields, but are not for casual users (or available on Windows). Any suggestions on how to both import and maintain this data?"
You could take a look at an application called GroupWise by Novell. It is web based and offers a powerful backend. It has powerful LDAP tools that can be viewed and edited on any platform. Also, it is widely scaleable. But it is a tad on the slow side. A small price to pay if it gets the job done, huh?
The New Root Council, kickin' ass sinc
I have found LDAP Browser/Editor to work pretty good. Java app.
LDAP Explorer is a decent web interface.
What I did was to use Dawn to produce an initial .ldif file. Then I wrote a little script to massage entries based on the dn's and ou's that I wanted to use. Create said dn's and ou's via a seperate, hand crafted .ldif, a quick little exercise, bring in your massaged .ldif, and you're set.
To manage, phpLDAPadmin is the best tool I've found so far.
Outlook, Mozilla, etc. can all access as clients.
I also recommend LDAP System Administration by Gerald Carter, though with some reservations. It provides a decent grounding in LDAP, but won't be an end-all-be-all definitive resource.
We used a program called AddressMagic to convert the 7000 or so Outlook "Contacts Folder" contacts to LDIF in an attempt to get them into OpenLDAP. Much like you our efforts were in vain. Outlook's got too much crap in there that's just plain undocumented but our office staff use (categories being the biggest one).
I've been playing with Exchange4Linux -- Crappy name but some really nifty software. Everything is stored in PostgreSQL -- everything -- This is both a good thing and a bad thing; Postgres is well up to the task, but the E4L server software is quite slow at the moment. They've written it in Python, and it talks to the proprietary Outlook connector via CORBA. Why CORBA? I dunno; it doesn't talk through firewalls worth a shit. :-(
I've successfully imported our 4000 contacts without even blinking. I also imported an additional 3.2GB of email, journals, notes and schedule data. Postgres just took it in and asked for more. This is on a server with an UW3 disk subsystem and 1G of memory.
Looking at the DB any "pure" MAPI object is stored in plain english, both by parameter name and value. Any Outlook-specific crap is stored with MAPIhexstringhere names and whatever data format Outlook uses for the data. It would be dead simple trivial to convert that into LDAP, but why bother when PostgreSQL has an LDAP frontend you can probably get working.
The nicest thing about E4L is that the Outlook guys lose zero functionality and (when completed) the IMAP, LDAP and iCAP frontends will give full connectivity to the entire OSS crowd. E4L is planning on making money selling Outlook connector licenses (which aren't that dear, really) but as I mentioned earlier, the server is 100% OSS and free (beer and libre). I realize that oGo is out there but to be honest, oGo looks enormously complex and it's written in a hideous language. I'd rather spend my time learning Python than Objective-C any day, thank you very much. E4L's got a single unified backend (PostgreSQL) which is scalable and solid, and with some more work (moving more into stored procedures, using the LDAP frontend, etc.) it will be an Exchange killer. It already works flawlessly with Outlook, as I mentioned.
I've just been through a sort of similar exercise.
We regularly receive a corporate address list of some 150,000 addresses.
The Exchange GAL was slowing down, so a decision was made to move these addresses to OpenLDAP.
It does the trick alright, but mapping the fields was like trial and error. The OpenLDAP forums and Google helped a lot there.
Now Outlook clients add a directory service and point it to the LDAP server. Remember to install the MS patch/registry hack else resolving addresses from the To: box will time out. Also get the LDAP indexing right cause that's slow too.
I think you can edit addresses directory from outlook, or am I confused with Windows Address Book. Or am I just confused.
Anyway, Reply if you want those mappings?
File Import and Export... [starts wizard]
Export the suckers as csv/Excel
import into new favorite address app
retain users
long way but should work
The Singularity is closer than you think
Quant
Have you considered reading all the cards in and writing them to a CSV or TAB delimited file? :p ).
This should be trivial (maybe 5 lines) in perl if you know the format of the cards (spec available at http://www.imc.org/pdi/, assuming MS followed the spec
Then, you could import the one file into your new ldap database, and use whatever you want to manage it after that.
Nothing to see here; Move along.
These tools may be worth checking out too...
http://rolodap.sourceforge.net/
http://ldap-abook.sourceforge.net/
http://sourceforge.net/projects/directorymanage
iF yOu WAnT to C YOUr iP agaIn gAThEr tWO MilLIon dOLLArS IN Non - cONsEcuTivE TweNtY's AnD AWaiT FuRThER iNstrUctIoN