Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsWindows Server 2003Windows 2000Windows NTSmall Business ServerVirtual ServerExchange ServerIISHost Integration ServerISA ServerSMSWSUSMOMWindows Media ServerSecurityCertification
Related Topics
SQL ServerMS WindowsMS OfficePC HardwareMore Topics ...

Windows Server Forum / Windows Server 2003 / Scripting / September 2007

Tip: Looking for answers? Try searching our database.

Update Lots Of Users Phone number from Spreadsheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JoeBhoy - 28 Sep 2007 22:13 GMT
Hi,
We recently had an office move and as  such telephone numbers changed. Is
there any way to update this info from an excel spreadsheet that has the new
numbers ?

Signature

Cheers

J.

Richard Mueller [MVP] - 28 Sep 2007 22:33 GMT
> Hi,
> We recently had an office move and as  such telephone numbers changed. Is
> there any way to update this info from an excel spreadsheet that has the
> new
> numbers ?

I have two sample VBScript programs for updating the profile path for users
in bulk. These examples can be easily modified to update any single-valued
attribute of user objects. The programs are "Update User Profile" and
"Update User Profile 2" in this link:

http://www.rlmueller.net/freecode4.htm

In the first program the Excel spreadsheet has the Distinguished Names of
the users. The second example uses the NT Names (pre-Windows 2000 logon
name) instead.

To modify the "Telephone number" field on the "General" tab of ADUC, replace
profilePath with telephoneNumber throughout either example program. Other
techniques are required to update multi-valued attributes, but you can also
modify the numbers on the "Telephone" tab. For the attribute names, refer to
the first spreadsheet in this link:

http://www.rlmueller.net/UserAttributes.htm

Signature

Richard Mueller
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
--

McKirahan - 28 Sep 2007 22:53 GMT
> Hi,
> We recently had an office move and as  such telephone numbers changed. Is
> there any way to update this info from an excel spreadsheet that has the new
> numbers ?

Insufficient requirements.

Update what?

Do you want to read an MS-Excel worksheet with
Names and Phone Numbers and update the phone
numbers in a database table?  If so, what database?
Also, will each name correspond with a valid entry?
JoeBhoy - 28 Sep 2007 23:49 GMT
sorry - I want to update the telephone number attribute in Active directory
with new phone numbers that i have in a spreadsheet. Along with the numbers
in the spreadsheet is the name of the users.

Joe.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.