Solved

Importing user accounts

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
For many of us, the  holiday season kindles the natural urge to give back to our friends, family members and communities. While it's easy for friends to notice the impact of such deeds, understanding the contributions of businesses and enterprises i…
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…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

763 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