How to get a comma separated LDAP export with ICE

  • Document ID:7013388
  • Creation Date:01-Oct-2013
  • Modified Date:07-Nov-2019
    • Micro Focus Products:
      eDirectory
      Open Enterprise Server
    • SUSE Products:
      SUSE Linux Enterprise Server

Environment

Novell eDirectory on all Platforms
ICE Command Line Utility

Situation

How to get a comma separated LDAP export with ICE

Resolution

You can use ICE Command Line utility to export data from eDirectory to a comma seperated file. This is the syntax of the command line you need to use:

ICE -S LDAP -s <LDAP server> -p <LDAP port> -d <bind dn> -w <password> -C SUB -F <LDAP search filter> -a <comma separated list of attributes to include> -D DELIM -f <export file> -F <data order>

And here is an example to do the query on the local server, logging in as admin.novell with password novell
In this example mapping.txt is:
cn,telephonenumber,title

ice -S LDAP -s x.x.x.x -p 389 -d cn=admin,o=novell -w novell -c SUB -F cn=* -a cn,telephonenumber,title -D DELIM -f c:\export.txt -F mapping.txt

And the export.txt result is:
Tommy,10 204030, Support Engineer

Here is an example of running the same command on a Linux eDirectory server:
/opt/novell/eDirectory/bin/ice -S LDAP -s x.x.x.x -p 389 -d cn=admin,o=novell -w novell -c SUB -D DELIM -f export.txt -F mapping.txt

Additional Information

Formerly known as TID# 10082383