?
Solved

Import fiields into AD from Excel

Posted on 2009-04-04
4
Medium Priority
?
809 Views
Last Modified: 2012-05-06
Hi

I have an excel sheet with the following columns. I need to import into AD to populate contact fields etc.The accounts are already created
the fields are:

User logon name  

Description:  (if entry exists, don't overwrite)
Office:  (if entry exists, don't overwrite)
Telephone Number:

Mobile:

City:

Title:
Department:
Company:

Manager
      Name:  if i input a user logon name, will this resolve?


I will run from workstation with Adminpak (w2k3) installed & excel. Domain admin rights.

Any help would be much appreciated, I am hopeless at scripting..

TIA
0
Comment
Question by:Danno2013
[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
4 Comments
 
LVL 9

Accepted Solution

by:
tl121000 earned 1500 total points
ID: 24068988
use this it works...


    • or go into ASDI edit -
    • don't change anything in ASDI edit just view and search for attrubutes if need be.

0
 
LVL 9

Assisted Solution

by:tl121000
tl121000 earned 1500 total points
ID: 24069013
The only drawback with this that I have found is that you need to lax your password policy in AD under the default domain policy to get this imported.
  • You can then select all users at once - right click on users and restet password.
    • set the passwords to a genraic password that meets the criteria of your environment with prompt user to change at next logon.
      • Switch back your defualt domain password policy to your typical settings.
0
 

Author Comment

by:Danno2013
ID: 24070383
Thanks for the link. That appears to be for creating users. I want to update their fields. I don't want to reset their passwords

eg  User logon name is the defined profile identifier against which other fields will be populated.

0
 
LVL 9

Assisted Solution

by:tl121000
tl121000 earned 1500 total points
ID: 24071887
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

This article demonstrates probably the easiest way to configure domain-wide tier isolation within Active Directory. If you do not know tier isolation read https://technet.microsoft.com/en-us/windows-server-docs/security/securing-privileged-access/s…
Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
Suggested Courses

752 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