Skip to main content
S
Stew_Brinegar
Participant
July 8, 2010
Question

assign keywords from excel

  • July 8, 2010
  • 1 reply
  • 2604 views

Hi there, I was wondering if anyone might have a suggestion for me: All our product images are named with a 9-digit ID number. All the item numbers and product information (name, color, gender, category, view, etc.) are stored in an Excel workbook for each photoshoot. Typically, we generate a list of keywords from the excel doc (using applescript), then import that list into Bridge before manually assigning keywords to each image. This seems like a perfect opportunity for automation. Is it possible for Bridge to open the Excel doc, find the cell with the name of the image, and assign the associated keywords from the same row? seems easy enough, but I'm not sure where to start.

-S

This topic has been closed for replies.

1 reply

Paul Riggott
Paul Riggott
Inspiring
July 8, 2010

I don't think it will be possible, Bridge scripting is JavaScript only and cannot access Excel, what most do is export the details to a csv file and use that as an input file. As a general purpose import from a csv or tab delimited I have created a script here that might be of use.

http://www.ps-scripts.com/bb/viewtopic.php?f=19&t=3463&sid=068418ad7cac24ea2e16dcb02a122e20

Edit: It may be posible to run a JavaScript function from within Applescript? I can't help with AppleScript though.

Muppet_Mark-QAl63s
Muppet_Mark-QAl63s
Inspiring
July 8, 2010

The only thing that you can do with Bridge from an AppleScript point of view is the command 'do javascript' and pass it the code my Trial of CS5 is over so I can't even test. I think that the suggested CSV or TDT route would be best and simplest. Otherwise you will need to be constructing your Javascript syntax on the fly.

S
Stew_BrinegarAuthor
Participant
July 9, 2010

Could you pass variables in and out of a call to applescript? i.e. bridge sends the filename(s) to an applescript that looks up the keywords in a specified workbook, returns those keywords to bridge, which assigns them to the image.

Or I could set up a hot folder on the desktop that runs .as scripts in Excel and .jsx scripts in Bridge?

All this would be much easier if Bridge were able to run applescripts like Photoshop, Illustrator, InDesign, etc...

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices