Solved

Import fiields into AD from Excel

Posted on 2009-04-04
4
803 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 500 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 500 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 500 total points
ID: 24071887
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

This article explains the steps required to use the default Photos screensaver to display branding/corporate images
Group policies can be applied selectively to specific devices with the help of groups. Utilising this, it is possible to phase-in group policies, over a period of time, by randomly adding non-members user or computers at a set interval, to a group f…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

691 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