Solved

how to import the User details in Ative Driectory from Excel

Posted on 2011-09-20
5
284 Views
Last Modified: 2012-05-12
Dear Experts
we are using AD 2003, in AD only user account has been created. they are 150 users, now i want to update users details in AD at one single step with Excel Sheet.
1.  i have exported all  user account in the excel sheet.
2. then i have updated all the users accounts details in excel. now i want to import the excel sheet to AD 2003, so that all the users should be updated in signal step


0
Comment
Question by:mshakeb
5 Comments
 
LVL 10

Accepted Solution

by:
gaurav05 earned 500 total points
Comment Utility
Hi,

Instructions to Create a Simple CSVDE Import Spreadsheet
1) Copy my example below and paste into an Excel spreadsheet at precisely cell A1.

objectClass,sAMAccountName,dn
user,Petergr," CN=Peter Graham,OU=Newport,DC=cp,dc=com"
user,Janiebo," CN=Janie Bourne,OU=Newport,DC=cp,dc=com"
user,Edgardu," CN=Edgar Dunn,OU=Newport,DC=cp,dc=com"
user,Belindaha," CN=Belinda Hart,OU=Newport,DC=cp,dc=com"
user,Mayja," CN=May Jamieson,OU=Newport,DC=cp,dc=com"
user,Leroyot," CN=Leroy Ota,OU=Newport,DC=cp,dc=com"

2) In Excel, select the Data Menu and then Text to Columns.  Naturally, choose the comma delimiter. Save the file as .csv for example, Newort.csv

3) Make sure that the 3 LDAP fields are in the first row.  (ObjectClass, sAMAccountName, and DN.)

4) Once you have opened the file in Excel, it is easier to manipulate the values.  For example, you may wish to find and replace dc=cp, dc=com with the name of your domain as we discussed earlier.

 5) When you have finished preparing the spreadsheet to your liking, then Save As and make sure you select Save as type CSV (Comma delimiter).  Since the next step is the command prompt, save the file into an easily accessible folder. E.g. C:\csv.

The Actual CSVDE -i Import Command
After all the hard work in preparing the spreadsheet, we are now ready for the import.  Open the CMD prompt, navigate to the folder where you saved your .csv file.

Type this command:  CSVDE -i -f Newport.csv


let us know is there any issue.
0
 
LVL 24

Expert Comment

by:Sandeshdubey
Comment Utility
Windows server provide you with 2 utility tools to modify existing AD accounts - CSVDE or LDIFDE
http://www.computerperformance.co.uk/Logon/CSVDE_LDIFDE.htm

What you do is to export your AD user accounts into a csv/spreadsheet, modify it and import it back to AD. Easy.

CSVDE
http://technet2.microsoft.com/WindowsServer/en/Library/1050686f-3464-41af-b7e4-016ab0c4db261033.mspx

LDIFDE
http://support.microsoft.com/kb/237677
0
 
LVL 10

Expert Comment

by:gaurav05
Comment Utility
Hi,

ldifde -f Exportuser.ldf -s <Server1> -d "dc=Export,dc=com" -p subtree
-r "(&(objectCategory=person)(objectClass=User)(givenname=*))"
-l "cn,givenName,objectclass,samAccountName"

also check this.
http://support.microsoft.com/kb/276382
0
 
LVL 7

Expert Comment

by:ComputerBeast
Comment Utility
Hi,

Refer to the article:

http://blog.scottlowe.org/2006/06/20/mass-changes-in-active-directory/

Hope it works.

Thank you
Anil
0
 
LVL 1

Author Closing Comment

by:mshakeb
Comment Utility
problem sloved
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

[b]Ok so now I will show you how to add a user name to the description at login. [/b] First connect to your DC (Domain Controller / Active Directory Server) SET PERMISSIONS FOR SCRIPT TO UPDATE COMPUTER DESCRIPTION TO USERNAME 1. Open Active …
In this article, we will see the basic design consideration while designing a Multi-tenant web application in a simple manner. Though, many frameworks are available in the market to develop a multi - tenant application, but do they provide data, cod…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now