LDAP2CSV

Novell Cool Solutions: Cool Tool

Digg This - Slashdot This

In Brief

Outputs an LDAP Search in CSV format

Vitals

Posted:	15 Mar 2005
File Size:	6KB
License:	Free
Download:	/coolsolutions/tools/downloads/ldap2csv.pl
Publisher:	Jim Schnitter

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:


attribute_name, count
attribute_name, count

Here's an example attributes file:

description,1
cn,2
mail,3
sn,1
fullname,1
telephonenumber,1

3. 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.

Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com

Reader Comments

• nice try but at the first glance some major bugs: CSV Header is incorrect (attribute1 instead of attribute) Sort order is random, but consistent inside the csv Umlauts Ä are not handled correctly