Batch rename from database
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.