Solved

Importing user accounts

Posted on 2006-06-15
3
202 Views
Last Modified: 2010-03-19
I have Excel  spreadsheet that has information about AD users accounts exacly the same as when we create a user in AD.

I would like to export these information to a corresponding OU in AD.

How do I achieve that.

I have read about csvde and ldifde tools but they are not clear.
I have Hyena tool, and don't know if it's able to achieve this

thanks
0
Comment
Question by:jskfan
3 Comments
 
LVL 10

Assisted Solution

by:bbrunning
bbrunning earned 150 total points
ID: 16912631
0
 

Author Comment

by:jskfan
ID: 16913811
that's not enough.
0
 
LVL 10

Accepted Solution

by:
Sorenson earned 200 total points
ID: 16915029
this link has a sample spreadsheet and the code for a vbs app that can be run.  I have done it to create several hundred e-mail contacts in AD but not to create the users.  
http://www.computerperformance.co.uk/vbscript/vbscript_user_spreadsheet.htm

Modify your spreadsheet, like the example, download the Softerra LDAP browser to look at your current LDAP settings on AD http://www.ldapadministrator.com/download/index.php 

Then copy / paste the sample script from the site into a file with a .vbs extension.  Modify the script for your environment (ie change strOU, change strSheet).  Test with a one line spreadsheet...
good luck.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Don’t let your business fall victim to the coming apocalypse – use our Survival Guide for the Fax Apocalypse to identify the risks and signs of zombie fax activities at your business.
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question