How to duplicate a standard folder with files in it and rename them using a .csv list
I work at a school and we are trying to make e-files for all our students (a few thousand). Here is my situation:
I have a standard folder named "Last, First" with the standard .PDF files inside labeled "Last, First APT" and "Last, First DRS". These need to be duplicated and renamed using the students' names that I can put into a .CSV spreadsheet.
I also have another folder that contains .PDF files that are already named according to each student as "Last, First RPR", and I would like to have these files moved into the new student e-file.
Is there a way to do all of this using Automater or AppleScripts? I'm pretty new to both of these applications and I'm having a hard time creating a script or workflow that would do all of this.
Any help would be greatly appreciated.