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?"
Yes, O2003 BCM should help you out here. I was "lucky" enough to get in on beta and though it was particularly buggy and slow (expected in a beta) it offered a lot of features including what you are looking for.
Sadly, you will have to wait a month or two and fork over a couple hundred bucks-- but it seems like you have those kind of resources.
The New Root Council, kickin' ass sinc
Place a Rolodex in a central location. Perhaps by the coffee machine.
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
If I were you, I'd take advantage of the glut of unemployed coders and have someone make you a web-based frontend to a perl or C based backend solution for this problem. Perl would probably work fine. It's kinda what it's designed for. Something like this would be pretty damn easy actually. Then you could/would have an application that does exactly what you want it to do, and the source to make modifications down the road if you need it.
For every annoying gentoo user, are three even more annoying anti-gentoo crybabies. Take Yosh from #Gimp for example.
Have someone make you a webmin module that does this and be the hero that shares it with the world.
For every annoying gentoo user, are three even more annoying anti-gentoo crybabies. Take Yosh from #Gimp for example.
SunOne/IPlanet/Netscape directory server has a nice gooey GUI for adding/searching/modifying. Searches can be done via web-browser...
So, just make an OU for contacts, dump the contacts in with Perl, create accounts for your salesy people and give them admin privilege of the contacts ou. It'll take a little time to get all the bugs worked out and lusers trained, but it will be functional from the start. I think.
Then you hire someone to come in and write a couple of little Perl CGI's using the PerlDap module or the variety of others available. I've been messing around with one that allows lusers to update a few of their records via Apache (perl modules CGI, PerLdap; Apache module mod_auth_ldap). Not too hard.
"You may all go to hell and I will go to Texas"
Sen. Davy Crocket to US Congress, Nov. 1, 1835
#!/usr/bin/perl
use Text::vCard;
use Net::LDAP;
# remainder left as an exercise for the poster.
Hi,
I made a little ruby-script (my first!), which achieves something like that.
It's far from perfect, but works for me.
download it here
The archive containt a procmailrc, because i'm invoking it via an extra email-address. you will need ripmime
The script uses the vcard-Class from ruby-lang.org, which is included in the archive.
There are only 10 types of people in the world: Those who understand binary and those who don't.
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.
Me and my friends here in India would be loving to help you out of your predicament. My team consists of the finest young plucky software engineers versed in all the latest technologies and will eagerly do this for you for only $10 total. This includes a complete set of documentation and followup, project management and five happy programmers to code your solution using on the best of software development methodologies. All for only $10.
Of course then we have your entire contact database which we can either use for our own personal profits (legal or otherwise) or maybe we just sell it to all your competitors for a nice tidy profit. Then you will be fuxored pretty bad, but hey - at least it only cost you $10.
Glonoinha the MebiByte Slayer
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