Solved

Import fiields into AD from Excel

Posted on 2009-04-04
4
798 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
  • 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
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 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 …

708 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

11 Experts available now in Live!

Get 1:1 Help Now