A Forum reader recently asked:
"I'm familiarizing myslef with ICE to import objects into edirectory from a delimited file (csv and/or txt). I've succeded in importing/creating users from a CSV or TXT file with no problems. However, I'm want to know if it's possible to create object other then user objets...can we create External Entities from a delimited file.
I know it can be done from an LDIF file but I need to do it from a delimited file. I'm able to extract any type of information using ICE to a delimited file. For example the following will extract all external entities:
ice -S LDAP -s <server> -d cn=admin,o=organization -w password -b
o=organization -c sub -F"(objectClass=external entity)" -D DELIM -f
c:output.txt -t cn
The problem is when I import this file in to my test environment, it creates everything as user objects instead of external entities."
And here's the response from Jim Henderson ...
You need to export more than just CN. What you might do is take the LDIF file that does the creation and translate it to delimited. You could use a command like this:
ice -S LDIF -f file.ldif -D DELIM -t field1,field2,field3 -f
Make sure you specify all attributes (including objectClass) in the parameters for -t.
Then when you do the import, make sure you use the same list for -t that you used in your conversion from LDIF.
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.