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.