> cool solutions home   > cool tools home
LDAP2CSV
Outputs an LDAP Search in CSV format
Reader Rating    from ratings rate this article
View a Printer Friendly Version of this Page Send this page to a friend
vitals
Posted: 15 Mar 2005
File Size: 6KB
License: Free
Download 1:  ldap2csv.pl
Publisher: Jim Schnitter
E-mail: JSchnitter@TAKETHISOUTnovell.com
disclaimer
Please read the note from our friends in legal before using this file.
details

What makes this tool unique is that it can handle attributes that have multiple values. The administrator specifies the attributes and the maximum count for each one. The program discards values that exceed the count and provides null values for attributes that don't match the maximum count. You run the utility like this:

ldap2csv.pl -h < host> -D < user> -w < password> -b < base> -f < attributes file> < filter>

Example:
ldap2csv.pl -h 192.168.1.2 -D cn=admin,o=novell -w novell -b ou=people,o=novell -f attrs.txt objectclass=user

  1. The user and password are optional. If not specified, an anonymous bind will be done.
  2. The attributes file must be in this format:


  3. attribute_name, count
    attribute_name, count

    Here's an example attributes file:

    description,1
    cn,2
    mail,3
    sn,1
    fullname,1
    telephonenumber,1
  4. You'll need to download and install the perl-ldap-0.3202 module from www.cpan.org/. (This is already present on NetWare 6.5.)

Platforms: I've tested it on SLES9 and NetWare 6.5.