Batch rename from database

[rdk]

Hello,

I have 900 photos from the photographer that have all been named with the students name and then organised into homeroom folders - all very nice.

However, to import photos into our timetable software the photos need to be named with the student codes. Does anyone know how to do a batch rename with something like a "vlookup" to an excel file that would have the names, homerooms and student numbers? I need the utility to look at the current name of the file, find that name in the excel file and rename with the corresponding code.

A bit more than the usual batch renaming!

I really want to avoid doing this manually.

Thanks.

[fawkers]

Heres a qucik powershell script which should do the job, just change the path to were your files are and run a CSV file from your MIS with the kids names and admissions numbers (student codes), change the path on line 8 to where this csv is.

#Get a list of all files in the structure
$List = Get-ChildItem -Recurse -Path c:\Windows\system32

#fore each file 
foreach($item in $list)
{
  #import report containg students names and adminision numbers (collum heading name and adno)  
  import-csv "s:\students.csv" | foreach-object {
      #check each line in CSV file if it contains the current file name
      if($item.Name.contains($_.name))
      {
          echo found
          #rename file to admission number
          Rename-Item $item $_.adno
      }
  }
}

Hope this helps,

[rdk]

Thanks - I'll try that next week.