A Forum reader recently asked:
"I have a list of the entire OU structure in an Excel document. I want to do an LDIF import of the OU structure, creating each OU for me. How can this be done? "
And here are suggestions from Edward van der Maas and Aaron Burgemeister ...
Edward van der Maas
Create something like this:
It depends on what the Excel document has it in specifically, and in what format, and how complete it is. You may be able to use ICE (Import Convert Export) via ConsoleOne or iManager (or even the command line) to import directly from a CSV format, but I would prefer to create an LDIF from the file. Excel equations could be used to create the LDIF, as follows:
C1, ="dn: " + A1 + "," + B1 + vbCrLf + "changetype: add" + vbCrLf + "ou:
" + A1 + vbCrLf + "objectClass: organizationalUnit" + vbCrLf +
"objectClass: ndsLoginProperties" + vbCrLf + "objectClass:
ndsContainerLoginProperties" + vbCrLf + "objectClass: Top" + vbCrLf + vbCrLf
In case it is not apparent, the 'vbCrLf' is supposed to create a new line. This would create an LDIF similar to the one Edward created as an example, and would only require you have the short name of the OUs in one column and the context for them in another (on the same row). The forumla could then be "filled down," and you could copy/paste the entire thing to a file (that entire third column, I mean) and run it.
Disclaimer: As with everything else at Cool Solutions, this content is definitely not supported by Novell (so don't even think of calling Support if you try something and it blows up).
It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test, test, test before you do anything drastic with it.