Automated AD Update Script

I maintain an on-premises Active Directory and receive a fresh HR export every day. I need a PowerShell script that will read that CSV, match each record to an existing user account, then update three attributes—Title, Department, and Manager—in bulk.

Once the script is in place I want it to run silently every night through Windows Task Scheduler (or an equivalent built-in option) and log successes or problems to a text file so I have an easy audit trail. Error handling is important; any rows that fail to process should be written to a separate file with a clear explanation so I can correct the source data.

If the delimiter in the file ever changes, I’d like a quick way to adjust the script rather than rewriting it. Feel free to add parameters or an autodetect routine if that keeps the code clean.

Deliverables
• A commented .ps1 script that reads the CSV, updates Title, Department, and Manager, and outputs two log files (success / error).
• A companion .xml or .cmd suitable for creating the daily scheduled task, including the account under which it runs and the working directory.
• A short README explaining any prerequisites or modules used and the exact command line I should drop into Task Scheduler.

I’m ready to test right away and will provide sample CSVs plus an isolated OU where you can verify the updates.