Novell is now a part of Micro Focus

Using LDIF to Import Users into NDS

Novell Cool Solutions: Tip

Digg This - Slashdot This

Posted: 10 Mar 2004


On a new NetWare 6 server, how do I create an LDIF file to import over 1000 users into an NDS I'm creating from scratch? I would be creating about 1100 student users (into the same OU) and want to create home directories at the same time -- as well as add them to groups.

Answer from down under (Robert Shera, Canberra, Australia):

I switched to LDIF this year from UIMPORT, and once I got the hang of it it was much easier. I do the following:

  1. Export the student data from your admin package to an Excel file.
  2. Create a Word document to mail merge the data from Excel into the required LDIF format.
  3. Merge the data to a new file, and save it as a text file.
  4. Import the data using the ConsoleOne Wizard or iManager.

I've attached a dummy Excel file and Word document to show you what I use.

(I do a bit of fancy stuff in my SQL extraction from the admin package. I create the last two columns of the spreadsheet with modified first names and surnames to construct the email addresses. These have spaces, apostrophes, etc. removed.)

I also use Homes, a free product from to create the user home directories in the format I want (Users\School Year\First Name Last Name). There is a cheap ($20? approx) version that will also let you apply a template during the creation process if you need this.

It works well for me.

If you have any questions, you may contact Robert at

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

© Micro Focus