Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Import fiields into AD from Excel

Posted on 2009-04-04
4
Medium Priority
?
811 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
A bad practice commonly found during an account life cycle is to set its password to an initial, insecure password. The Password Reset Tool was developed to make the password reset process easier and more secure.
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 …
Suggested Courses

604 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