Q
Problem solve Get help with specific problems with your technologies, process and projects.

Simultaneously add telephone numbers to Active Directory

You don't have to add a large group of numbers to Active Directory one by one. SearchEchange.com expert David Sengupta shows you the tool you need to get the job done in one sweep.

When our Active Directory was created, they didn't put in the telephone numbers. Is there any way to add the telephone numbers for 500 people without having to go into Active Directory and put in the numbers one by one? Human Resources sends out a telephone directory in Excel; can I use that to my benefit?
You should have a look at LDIFDE. See Microsoft Knowledge Base Article 237677: Using LDIFDE to import and export directory objects to Active Directory for instructions on how to make these changes. You'll need to be creative in Excel (or Access) in order to match up the source data from Human Resources with Active Directory data using some unique primary key.

Do you have comments on this Ask the Expert Q&A? Let us know.

Related information from SearchExchange.com:

  • Glossary: Lightweight Directory Access Protocol (LDAP)
  • Expert Advice: How to update multiple mailbox properties
  • 15 tips in 15 minutes: Managing recipients and distribution lists
  • Reference Center: Active Directory tips and resources
  • This was last published in March 2006

    Dig Deeper on Exchange Server setup and troubleshooting

    Have a question for an expert?

    Please add a title for your question

    Get answers from a TechTarget expert on whatever's puzzling you.

    You will be able to add details on the next page.

    Start the conversation

    Send me notifications when other members comment.

    Please create a username to comment.

    -ADS BY GOOGLE

    SearchServerVirtualization

    SearchCloudComputing

    SearchExchange

    SearchSQLServer

    SearchEnterpriseDesktop

    SearchVirtualDesktop

    Close