How do we batch export of EXIF metadata in Photoshop?

[lynmk01]

Hi all

We are hoping to export the photos on our Flickr site to a local drive, and then do a batch upload of the photos and their metadata to our library's new database.

To do this, we have downloaded the JPGs from our Flickr site using Bulkr Pro which writes the metadata from the Flickr record (title, description, tags) into the EXIF data in the JPG.

We know that it is possible to export the EXIF etc data from an individual photo to an XMP file using Photoshop (File > File Info > Export). However, we have over 30000 photos on Flickr so it would obviously be very tedious to export singly.

If you know how to create a batch process to export this data to the XMP files, we would be most grateful!

Cheers

Lyn Keily

The University of Newcastle, Australia

[Paul Riggott]

Why do you need xmp files? The norm is to extract to a CSV file, this can then be loaded into a DAM or a database.

To extract the data you could use ExifTool http://www.sno.phy.queensu.ca/~phil/exiftool/

Or you could use a script for Bridge I.E: http://www.scriptsrus.talktalk.net/Extract%20Metadata.htm

If you wanted more fields then there is another script that will allow this.

[lynmk01]

Many thanks for this, Paul. This is a possibility. We would need to convert the XMP file to fit the RDF specifications for Dublin Core, so that would be an additional step outside Photoshop. If we could get a CSV file, it would be very useful. I'll try your suggestions and see what happens. It will take a week or so because we are liaising with the vendor of the library catalogue software.

Cheers

Lyn Keily

Special Collections Librarian

The University of Newcastle, Australia

[Chuck Uebele]

For our database, we create an XML file from the photos raw data, then the database can use the xml to extract whatever field it needs.

activeDocument.xmpMetadata.rawData