File compare and rename

[tbarlet]

Anyone aware of a script, cgi or php or software program that will compare a file and rename the file. I need something that will check a file name to a database and use an alternate name to rename the file.

 

Basicly like this:

 

image1.jpg

image2.jpg

image3.jpg

 

renamed to:

 

1.jpg

2.jpg

3.jpg

 

based on this info in the database:

 

field1 field2

image1.jpg 1

image2.jpg 2

image3.jpg 3

 

I have tens of thousands of product images from various vendors all of which I would like to rename to match my internal produt id. Since I use excel to prepare my data for upload I use a counting sequence to add the unique product id. Most of my product data is supplied by my vendors so it takes minutes to do it this way versous months or years to do it by hand.