we are in process of updating all AD user information based on the
information exported from the HR DB. user info in HR DB will be exported to
excel sheet and my task is to write these info to the AD existed accounts.
the link field between excel sheet & AD account is the email address.
i have to read this email from excel sheet, then search AD for this email.
if it's found it then I have to update his info based on the excel sheet.
all common attributes in AD will be updated including (1st name, initials,
last name, display name, office, telephone, street, ...etc).
almost the data in AD is accurate but we need to rely on HR DB as main
reference for the user info.
now since the HR don't include all these information (i.e may be some fields
in the excel will be blank), then i need to reflect that in matched AD
attribute. example if the excel sheet don't have the phone number for certain
user while it's present for this user in AD, then I need to remove the phone
number in AD.
the script should check if the data in excel is same as in AD, then no need
write it to AD again. also if the both values in excel & in AD are empty,
then no need to do any thing.
i know this is a big task but i appreciate any help or idea.