Pulling data from an Excel sheet

Advanced Renamer forum
#1 : 06/06-16 16:57
Tom
Tom
Posts: 1
Hello -

I want to rename multiple images using the New Name method. There are four parts to each file name including:

Element #1: Series Number (stored in Excel sheet and the same for every image)
Element #2: ID Number (stored in Excel sheet and different for every image)
Element #3: Static text to read "PIC"
Element #4: Static text to read "1"

Here's the pattern I created in Advanced Renamer:

<ExifTool:Series><ExifTool:ID>_PIC_1


Here now is an example of how data is stored in the Excel sheet:

File Name Series ID
testA.jpg 234 98765
testB.jpg 234 5642
testC.jpg 234 33371


What I can't figure out is how to I link the first two data elements in the Excel file with the new image file names I want to create for TestA, B and C?

This is ultimately what I want:

TestA.jpg should be renamed as..... 234_98765_PIC_1.jpg
TestB.jpg should be renamed as..... 234_5642_PIC_1.jpg
TestC.jpg should be renamed as..... 234_33371_PIC_1.jpg

Thank you for any help.



06/06-16 16:57 - edited 06/06-16 17:23
#2 : 16/06-16 11:04
G. Lambany
G. Lambany
Posts: 187
Reply to #1:
try this python script, should do the job:

http://pastebin.com/LVjTT9m7

glambany@gmail.com if you have any questions
I had some instructions written, but lost it because of the timeout on the forum login .. : /

cheers!


16/06-16 11:04