Rick Kingslan - Microsoft Certified Trainer
MCSE+I on
Windows NT 4.0
MCSE on Windows 2000
MVP [Windows NT/2000
Server]
"Any sufficiently advanced technology
is indistinguishable
from magic."
--- Arthur C. Clarke
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Charles Oppermann
Sent: Wednesday, January 02, 2002 3:03 PM
To: [EMAIL PROTECTED]
Subject: RE: [ActiveDir] Guide to automating account creation in an AD<<
One big hint for this is to create the data file using Excel is a
classic CSV layout to take advantage of formulas to ease the data entry
issues. Then simply mail-merge into Word to transform it into LDIF
format.
>>You don't even have to convert it to LDIF, you can use CSV files directly. More info taken from the Active Directory Programmers Guide:
Comma-separated Value (CSV) Scripts
Windows 2000 includes a command-line utility, CSVDE, to import directory objects using .CSV files and export directory objects as .CSV files. CSV scripts are targeted for ease-of-use. The first line in the script identifies the attributes in the lines that follow. Columns are separated by commas. The file format is compatible with the Microsoft Excel CSV format, so that files are easily created. Use Excel or any other tool that can read and write .CSV files. A benefit of using CSVDE is that it supports Unicode.
The following CSV file adds an auxiliary class:
DN,adminDisplayName,cn,defaultHidingValue,defaultObjectCategory,description,governsID,lDAPDisplayName,mayContain,mustContain,distinguishedName,objectCategory,objectClass,objectClassCategory,possSuperiors,name,rDNAttID,schemaIDGUID,subClassOf,auxiliaryClass,defaultSecurityDescriptor
"CN=My-Test-Auxiliary-Class1,CN=Schema,CN=Configuration,DC=timtobigboxdom,DC=nttest,DC=microsoft,DC=com",My-Test-Auxiliary-Class1,My-Test-Auxiliary-Class1,FALSE,"CN=My-Test-Auxiliary-Class1,CN=Schema,CN=Configuration,DC=timtobigboxdom,DC=nttest,DC=microsoft,DC=com",Test class used to show how to add an auxiliary class.,1.2.840.113556.1.4.7000.159.24.10.611.11,myTestAuxiliaryClass1,myTestAttributeDNString,description;myTestAttributeUnicodeString,"CN=My-Test-Auxiliary-Class1,CN=Schema,CN=Configuration,DC=timtobigboxdom,DC=nttest,DC=microsoft,DC=com","CN=Class-Schema,CN=Schema,CN=Configuration,DC=timtobigboxdom,DC=nttest,DC=microsoft,DC=com",classSchema,3,domainDNS;container,My-Test-Auxiliary-Class1,cn,X'9a6b3176c5dbd2118bd00000f875b660',top,,
Charles Oppermann, Copper Software
Author, "Microsoft Windows 2000 Active Directory Programming"
http://www.coppersoftware.com/activedir/
