Solved

Importing user accounts

Posted on 2006-06-15
3
203 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Setting up a VPN 60 181
Setting up static routes to  sonicwll 4 72
Cisco 2960 unable to add SFP modules to device 9 64
HP 1920 Switch -- IFNET LINK_UPDOWN Errors 3 14
When it comes to security, there are always trade-offs between security and convenience/ease of administration. This article examines some of the main pros and cons of using key authentication vs password authentication for hosting an SFTP server.
Most of the applications these days are on Cloud. Cloud is ubiquitous with many service providers in the market. Since it has many benefits such as cost reduction, software updates, remote access, disaster recovery and much more.
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…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

856 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