Metadata: export, change, import

[Jeff Vogan]

I am looking for how to export the metadata from a series of photos, bring them into MS Excel, run a macro that would change the ITPC data, and then import the ITPC back to the series of images.

Use case:
I shoot an event and use a certain format for the caption, personality, persons shown, etc.  I then submit to Getty. I want to change the format of the caption and a few other fields to follow the AP format. I don't want to have to edit each image's metadata.  I want to export the ITPC data to an Excel spreadsheet and run a macro that would do a search and replace from, for example, QB John Smith ( to quarterback #8 John Smith. I then want to import the updated ITPC to the same set of images.

I have tried to research how to do this but have drawn blanks. How would I do that?

[ahoward]

Since you are a pretty advanced Code Replacement and variable user, I'm not sure which part you are having difficulty with? The importing, changing the data in the spreadsheet, or using the spreadsheet to update the metadata of the images?

[Mick O (Camera Bits)]

If the question is applying the Excel spreadsheet back to a set of images, the short answer is to convert the spreadsheet into a Code Replacement / Hot Codes sheet where the filename is the field that applies the Hot Codes.  I created a video that goes over that aspect of the process: https://www.youtube.com/watch?v=XHyl5inFvFs

In terms of creating your Excel macro, I am not tremendously skilled at that, but I do use the CONCATENATE function a lot to combine fields and text (e.g. name and number etc)

Briefly, if you have name in column A and jersey in column B, you can do things like the following

Code: [Select]

=CONCAT(A1, "(#", B1, ")")
-Mick

[Max Lemesh]

I would be very interested in hearing about your solution, Jeff.
Don’t need this functionality right now, but it might inspire some other workflow idea.