Solved

Importing user accounts

Posted on 2006-06-15
3
205 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Let’s list some of the technologies that enable smooth teleworking. 
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
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…

738 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