Import AD data from CSV file to 2003 ad
Active Directory, Active Directory 2003, Active Directory Users, AD, CSV, Windows, Windows Server 2003
We have 3500 new ad users. How can
we import their usernames, full names, phone numbers, email addresses from a CSV
file.
Software/Hardware used:
windows server 2003
Software/Hardware used:
windows server 2003
ASKED:
September 24, 2010 4:14 PM
UPDATED:
September 28, 2010 11:36 PM
RELATED QUESTIONS
- Exporting Active Directory user info to CSV
- Group policy across Windows OSes
- Why do Snow Leopard machines bound to Active Directory stop letting the user authenticate after about 24 hours?
- Snow Leopard users authenticating against AD - How?
- Disabling a list of csv ad user accounts and speed up replication
Answer Wiki:
See this <a href="http://itknowledgeexchange.techtarget.com/itanswers/i-want-to-write-a-utility-which-will-read-domain-users-details-from-the-active-directory-and-dump-it-in-a-database/">similar question</a> which recommends the use of the dsquery command. Here's another tip that might help you from <a href="http://itknowledgeexchange.techtarget.com/itanswers/editing-active-directory-users-offline/">another ITKE user's question</a>.
To see all answers submitted to the Answer Wiki: View Answer History.
The tool best suited for your requirement is likely csvde:
http://technet.microsoft.com/en-us/library/cc732101(WS.10).aspx
As my learned colleague above states, it is possible using dsquery/dsadd (or dsmod if they exist) but this is quite cumbersome.
Alternatively, you could use a little custom VBScript or Powershell. Better to learn now and futureproof yourself – there are plenty of examples online and especially from Microsoft’s own Scripting Guy column.