Skip to main content
shashi88
Participant
Apr 9, 2016 6:56 AM UTC
Question

Need a script to update keywords for 20000 images in Bridge

I have an excel with filename in column A and keywords in column B. I wish to update the keywords tab in bridge using a script. Please let me know if there is any pre written script available which I can use.

This topic is closed to new replies. Start a new post to keep the conversation going.

16 replies

Stephen Marsh
Community Expert
Community Expert
Apr 14, 2016 12:27 AM UTC
Stephen Marsh
Community Expert
Community Expert
Apr 9, 2016 8:33 AM UTC

If you don’t use the Bridge script, then I can help with ExifTool (both methods have their pros/cons).

Translate
shashi88
shashi88Author
Participant
Apr 9, 2016 1:27 PM UTC

Hi Stephen. Thanks for the quick reply. I would be more than happy if you could guide me with Exiftool.

I have downloaded the tool. All I need is to now how to use it.

Link to the excel file:

Dropbox - Workbook1.xlsx

Tanks in advance.

Translate
Stephen Marsh
Community Expert
Community Expert
Apr 10, 2016 4:26 AM UTC

shashi88, are you on Mac or Windows OS?

The basic ExifTool commands are the same, however there are some minor formatting differences required in some cases, such as the Mac uses 'single quotes' to wrap around a file path and file name that contains word spaces, while on Windows, "double quotes" are used (they are not really quotes, they are inch and foot marks, straight not curly).

P.S. Are the images all in a single directory, or are they contained in a main parent/top-level folder and then within subsequent second-level, third-level etc nested folders?

Do you need to apply the keywords to a single specific file type, multiple file types or do you need to exclude specific file types?

Finally, are there existing keywords to be overwritten or do you wish to append?

Translate
SuperMerlin
Inspiring
Apr 9, 2016 8:14 AM UTC

If you save the Excel to CSV you could use. DIY Metadata

Another solution  would be to use Exiftool ExifTool by Phil Harvey

Translate
shashi88
shashi88Author
Participant
Apr 9, 2016 1:36 PM UTC

Tried to use DIY Metadata but when it execute it I get an error message saying the file doesnt exist. Is it because of the format in which the data is stored in CSV file?

Translate
SuperMerlin
Inspiring
Apr 9, 2016 1:57 PM UTC

The filename should be in the first column I.E. filename.jpg and the file should exist in the selected folder or a sub folder if the relevant checkbox is ticked.

Translate