I do all the product photography for a company. We work with a company that uses a different file naming convention. They have PFID's which look like this: 33-39477.tif while I use SKU's that look like this frt-FTBLWOO300.tif
The images we put online to our website have to have the SKU name so it links correctly. I receive hundreds of images at a time from this other company and need to quickly re-name the files from the PFID to the SKU name. I have a list of our complete inventory (roughly 23,000+) in an excel spreadsheet with column A having the PFID and column B having the sku in it. Can I use this spreadsheet to batch re-name files?
I downloaded "A Better Finder RENAME" from this website - http://www.publicspace.net/ABetterFinderRename/Manual_Rename_File_List7.html
but I am having trouble following the directions on how to use a list to re-name. Is there a better program or solution?
I want to be able to dump edited PFID files into a folder on my desktop, push a button, and have the new renamed file in another folder on the desktop.
The images we put online to our website have to have the SKU name so it links correctly. I receive hundreds of images at a time from this other company and need to quickly re-name the files from the PFID to the SKU name. I have a list of our complete inventory (roughly 23,000+) in an excel spreadsheet with column A having the PFID and column B having the sku in it. Can I use this spreadsheet to batch re-name files?
I downloaded "A Better Finder RENAME" from this website - http://www.publicspace.net/ABetterFinderRename/Manual_Rename_File_List7.html
but I am having trouble following the directions on how to use a list to re-name. Is there a better program or solution?
I want to be able to dump edited PFID files into a folder on my desktop, push a button, and have the new renamed file in another folder on the desktop.