Adding 400 Users
I need to add 400 users to a new active directory domain. I have all the users in an Excel spreadsheet. Is they a tool I can use to import the spreadsheet into active directory.
Thanks
Networks
I need to add 400 users to a new active directory domain. I have all the users in an Excel spreadsheet. Is they a tool I can use to import the spreadsheet into active directory.
Thanks
by dklippert
Look at the MS Knowledge Base Article:
AddUsers Automates Creation of a Large Number of Users 199878
by rick_b
by roniperk
Since you currently have the name in an Excel spreadsheet, use the CSVDE command line utility to import the names into an Active Directory Organization unit.
Here's a link to using the utility:
http://support.microsoft.com/default.aspx?scid=kb;en-us;300409
This article was previously published under Q300409
SUMMARY
This article describes how to use Csvde.exe to import contacts into the Active Directory. You can use files that are saved by export utilities in a Comma Separated Value(CSV) format to import contact information into the Windows 2000 Active Directory. To modify the file headers and data, you can use a spreadsheet program such as Microsoft Excel. The modified files can then be added as contacts to the Active Directory by using Csvde.exe in Import mode. Csvde.exe is the CSV Directory Export utility that is included with Windows 2000 Server, and is located in the %systemroot%\System32 folder.
The following sample CSV file adds a contact for John Doe to the Sales Organizational Unit (OU) in the MYDOMAIN.local domain. This file also creates the necessary Exchange SMTP addresses so that Outlook clients can select this contact from the Exchange 2000 Global Address List.
To view the file for this example:Copy and paste the following text into a plain text editor (such as Notepad), and then save the file with a .csv file extension:
DN,instanceType,distinguishedName,objectCategory,objectClass,name,cn,
displayName,mail,givenName,legacyExchangeDN,middleName,proxyAddresses,
showInAddressBook,sn,textEncodedORAddress,internetEncoding,mailNickname,
mAPIRecipient,targetAddress
"CN=John Doe,OU=Sales,DC=MYDOMAIN,DC=local",4,"CN=John Doe,
OU=Sales,DC=MYDOMAIN,DC=local","CN=Person,CN=Schema,CN=Configuration,
DC=MYDOMAIN,DC=local",contact,John Doe,John Doe,John Doe,
John@ISP.com,John,/o=MYDOMAIN/ou=first administrative group/cn=Recipients/cn=
John Doe,,SMTP:John@ISP.com;X400
by rick_b
by rick_b
by rick_b
This discussion is closed to new replies.
Sort by Trending