Bulk renaming utility?

[pinsanity]

Hoping someone with some background in this area can help on this.

I have an xml list with proper naming conventions and linked to crc numbers like so:

<game name="2010 FIFA World Cup South Africa (USA) (EN,ES)" index="" image="">

<description>2010 FIFA World Cup South Africa</description>

<cloneof/>

<crc>SFWE69</crc>

<manufacturer>Electronic Arts</manufacturer>

<year>2010</year>

<genre>Sports/Soccer</genre>

<rating>(A)</rating>

<enabled>yes</enabled>

</game>

and I have a large number of box art png files that have been named via the crc code. EG: The box art png for 2002 FIFA World Cup South Africa is called SFWE69.

Is there a program out there that can scan my xml, match via the crc code and convert the box art file names to the proper names?

Or perhaps a script?

EDIT: I have tried Dons Renaming Tools and it won't match.

Thanks for any help.

[reehmicks]

I don't know of any specific tools for working with xml like that, but I tend to use Excel a lot to do these weird types of things..

Open the XML up in Excel and it should import the fields into columns.

Create a formula to basically run a rename on the file..

Example:

I copied your example into a text file, renamed it to test.xml and opened it in Excel.. It put the game name in A1 and the crc in F1 (the rest were also imported, just not important for this example.).

I then created this formula in cell L1 (the next available column):

=CONCATENATE("if exist """, F1, """ rename """,F1,""" """,A1,".png""")

Which calculates to:

if exist "SFWE69" rename "SFWE69" "2010 FIFA World Cup South Africa (USA) (EN,ES).png"

Basically copy paste the formula down through all the items of your xml.

When done with that, copy that entire column and paste it into a batch file. Run it in your folder. Hope for the best. =)

I tested the script on some test files and it worked, but I would still recommend making a backup of yours before running.

Also, I'm assuming you wanted a .png extension in the above example.

[Agrajag]

There's a program called Bulk Rename Utility (funnily enough!) that I use a lot. I'm not sure it can do exactly what you want, but it might be worth a try as it's free.

http://www.bulkrenameutility.co.uk/Main_Intro.php