DirXML populating

Now that the Novell DirXML Starter Pack is up and running, synching NDS/eDirectory accounts and Active Directory accounts, I needed a way to gradually add existing users to the sync as the desktop group migrated the client from GroupWise to Outlook 2003. Since this would be happening almost everyday for over a month, I didn't want to burn too much time in the iManager interface.

My solution was to first export the entire Active Directory forest as a comma delimited file using the Microsoft CSVDE tool. (Here's an overview from Guy Thomas.) I had previously populated the accounts with DirXML, but had removed the driver for a reconfiguring at one point. Desktop wanted the sync to be enabled as close as possible to the migration day anyway, so it actually helped that the accounts weren't entirely linked. I took the CSVDE export and narrowed it down to just the DN, the GUID and the SAMaccount name.

Next step was an import into UltraEdit (kedit is another good editor) and a save. This broke the DN down into fields for each aspect of the context, and allowed me to perform a search and replace on the first part of the DN with the SAMaccount name inside of Microsoft Excel. (This was necessary as the DirXML starter pack uses the Full Name attribute out of NDS/eDirectory for the Common Name in AD, and I was trying to populate the DirXML attribute on NDS/eDirectory).

This left me in the dilemma of how to get a comma delimited file into NDS/eDirectory, and although the developer version of the ICE command line is supposed to support imports from delimited files, I was never able to figure out the right combination of switches. Instead I found a Novell Consulting tool that takes a CSV and generates and LDIF file.

After a little more search and replace to correct syntax and issues such as an Organization unit (O) being and Organizational Unit (OU) in AD, I had a flat LDIF file of all my user accounts.

As the desktop support team serves up a list of user daily, I perform a find on my master list and stage an import LDIF file for ConsoleOne.