fMakeLDIF - Convert CVS files to LDIF

Novell Cool Solutions: Cool Tool

Rate This Page

Reader Rating from 3 ratings

Digg This - Slashdot This

In Brief

Convert CVS files to LDIF and pipe to ldapmodify IE.

Vitals

Product Categories:: eDirectory
Secure Identity Management

Functional Categories:: LDAP (Lightweight Directory Access Protocol)

Posted:	24 Apr 2006
File Size:	6KB
License:	Free
Download:	/coolsolutions/tools/downloads/fmakeldif.zip
Publisher:	Frode Sjovatsen

Disclaimer

Please read the note from our friends in legal before using this file.

Details

I often need to modify or add a lot of users and I get the data from some system in cvs format. To quickly convert these data to ldif I wrote this tool. I've only tested it on Windows but it should work on Linux as well. Perl must be installed to make it work since this is a perl script. Type makeldif.pl -h to get help:

Usage: makeldif.pl -t <template> -a <attrib> [-o <output>] [-s <seperator>] [-h]

Options:
-t file Template file. This file is the template of the LDIF code to be generated. Use *1..*n as variables to be replaces from the attribute file.

-a file "Something"-separaded file with attributes to be replaced by the variables in the template. Ie.:

                      attrib.txt file
                     ---------------
                     user1;locationA

                      template.ldif file
                     ------------------
                      dn: cn=*1,ou=users,o=myorg
                      changetype: modify
                      replace: l
                      l: *2

This will generate:

                      dn: cn=user1,ou=users,o=myorg
                      changetype: modify
                      replace: l
                      l: locationA

-o file The file to write LDIF code to. If not specified it will be written to <STDOUT>.

-s sep The separator for the attribute file. If not specified ';' will be used. Use tab for \t (tabulator) and space for whitespace.

-h Prints this help text.

Ie.: makeldif.pl -t template.file -a attrib.file -o new.ldif -s tab

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

Reader Comments

Work very well
To work with >10 variables, replace:

for ($j = 0; $j < $attribCount; $j++) {

with:

for ($j = $attribCount; $j >=0; $j--) {