Renaming user profiles using a script and .csv
I have inherited a system that has two naming conventions for our pupils home directories. The newer one sensibly uses their SIMS admission number (which is also their AD UPN), however the older accounts have a different naming system - that students need to remember, so that their teachers can navigate to it using an NTFS share. Suffice to say this leads to some disgruntled teachers...
What I want to do, is rename these older folders to the students admission number, and then update the path to their home directory within their AD account. I have some ideas for the later part, but I don't know how/if I can get a script to use a .CSV to rename these folders en mass - as we have over 1000 accounts to update!
Many thanks in anticipation,