Script to Export and Import Keywords and Metadata

Thanks Bob. Barredrock seems like just the ticket for my needs. That Scripting Guide is a little intimitating. ( I avoided having to learn dos by going Mac; avoided having to learn html with Dreamweaver; now will I have to confront scripting...?)

Chris,

Barredrock software (www.barredrocksoftware.com) has a script for sale that is a generalized metadata exporter. It will do what you need in a more general case.

I don't know what they charge for it, but I don't think anything on their site is more that $15.

The only definitive guide is the bridge scripting guide that is on your CD, and download-able from Adobe Exchange. You can also purchase a hardcopy from Adobe Press.

At the bottom of the forum message display you'll see "Show All Messages" on the right side of the same bar that contains the "First, Previous, Next, Last" options.

Bob
Adobe Workflow Scripting

If I may kindly piggyback on all the work Bob & Arnold have done: I too have been looking for a way to be able to provide clients with the medadata for images from their shoot, and the script that you have just made looks like IT. I have never worked with scripts, and it would help me if you could post three things for me (or is there an easier way to get it to me?)
1: the final, corrected script you have worked out, and
2: where to go for an informative guide about scripts that will tell me, from the begining, how to make one, install this one, and troubleshoot them.
3. How I can download all 14 of your postings in one file, so I can try to trace your prosess? (Seems like this is a good tool for the next Bridge revision.)

Super stuff Bob :)
heathrowe

Robert,

Thanks for your quick response. The script you modified works fine.

Can I impose on you to add to this script for the picture file size and flash elements (i.e. did strobe light fire, mode - auto, etc.)?

Thanks again,

Arnold

There were a couple of errors in the script.

Bob
Adobe WAS Scripting

Try this, save it to your startup scripts folder:

#target bridge

if (BridgeTalk.appName == "bridge" ) {

// Let's create our menu
var menu = MenuElement.create( "command", "Export CSV File", "at the end of Tools");
menu.onSelect = function(m) {
try {
// Let's ask what the name of the output file
var f = File.saveDialog("Export file list to:", "Comma delimited file:*.CSV");

if ( !f ) { return; }

// Write the column headings
f.open("w");
f.writeln("Seq Number,New File Name,New File Name Path,Original File Name,Org Dt & Tm,ISO,Exposure Time,F Stop,EV,Exposure Program,Meter Mode,Focal Length,Flash,Lens,Author, Author's Position,City,Country,Description,Title,Orientation,Width,Height,Rating,Label,KeyWords");


// Let's get a list of all the visible thumbnails
var items = app.document.visibleThumbnails;

for (var i = 0; i < items.length; ++i) {
var item = items;
f.writeln(i + 1, ",\"", item.name, "\",\"", item.path.replace(/\"/g, "\"\""), "\",\"", ListMetadata(item), "\",\"", "\"" );
}

f.close();
} catch(e) {
}
}
}

function ListMetadata(tn) {

md = tn.metadata;
md.namespace = "http://ns.adobe.com/photoshop/1.0/";
var varAuthor = md.Author + "\",\"" + md.AuthorsPosition + "\",\"" + md.City + "\",\"" + md.Country + "\",\"";

var varKeywords = ListKeywords(md);

md.namespace = "http://ns.adobe.com/exif/1.0/aux/";
var varLens = md.Lens + "\",\"" ;

md.namespace = "http://purl.org/dc/elements/1.1/";
var vartitle = md.title + "\",\"" + md.description + "\",\"" ;

md.namespace = "http://ns.adobe.com/xap/1.0/mm/"
var VarPreservedFileName = md.PreservedFileName + "\",\"" ;

md.namespace = "http://ns.adobe.com/exif/1.0/"
var VarDateTimeOriginal = md.DateTimeOriginal + "\",\"" + md.ISOSpeedRatings + "\",\"" + md.ExposureTime + "\",\"" + md.FNumber + "\",\"" +
md.ExposureBiasValue + "\",\"" + md.ExposureProgram + "\",\"" + md.MeteringMode
+ "\",\"" + md.FocalLengthIn35mmFilm + "\",\"" + md.Flash + "\",\"" ;

md.namespace = "http://ns.adobe.com/tiff/1.0/"
var varOrientation = md.Orientation + "\",\"" + md.ImageWidth + "\",\"" +
md.ImageLength + "\",\"" ;

md.namespace = "http://ns.adobe.com/xap/1.0/"
var varRating = md.Rating + "\",\"" + md.Label + "\",\"";

return VarPreservedFileName + VarDateTimeOriginal + varLens + varAuthor + vartitle + varOrientation + varRating + varKeywords;

}

function ListKeywords(md) {
md.namespace = "http://ns.adobe.com/photoshop/1.0/";
var Keywords = md.Keywords;

var varKeywords = "" ;
for ( var i = 0; i < Keywords.length; ++i ) {
varKeywords = varKeywords + Keywords + ", ";
}
//strip off final comma and space varKeywords =
varKeywords.substring( 0, varKeywords.length-2);

return varKeywords ;
}