Skip to main content
E
Edo75
Inspiring
August 11, 2009
Question

How can I export metadata to a csv file in CS4?

  • August 11, 2009
  • 5 replies
  • 8424 views

Help please, I used Workflow Automation Scripts on CS3 but it doesn't seem to work on CS4.

This topic has been closed for replies.

5 replies

J
Joe Photo
New Participant
October 7, 2011

Here's how I did it for CS4......to convert metadata to .csv

Go to http://www.scriptsrus.talktalk.net/Extract%20Metadata.htm and download script (.jsx file)

Place the (.jsx) file into the Startup Script folder for Bridge CS4

(On Mac HD:  Users>Library>Application Support>Adobe>Bridge CS4>Startup Scripts)

Close and restart Bridge CS4....accept new Extract Metada script.

A metadata button will appear on the Bridge menu at the top of your window....select your file (files) to convert and then click button and click "extract metada".....select what you want to extract and the .csv file will appear on your desktop.

R
recordedsoul
New Participant
March 21, 2013

Joe Photo wrote:

Here's how I did it for CS4......to convert metadata to .csv

Go to http://www.scriptsrus.talktalk.net/Extract%20Metadata.htm and download script (.jsx file)

Place the (.jsx) file into the Startup Script folder for Bridge CS4

(On Mac HD:  Users>Library>Application Support>Adobe>Bridge CS4>Startup Scripts)

Close and restart Bridge CS4....accept new Extract Metada script.

A metadata button will appear on the Bridge menu at the top of your window....select your file (files) to convert and then click button and click "extract metada".....select what you want to extract and the .csv file will appear on your desktop.

THATS GREAT! its just what im looking for, however can you point me in the direction of a script like this that will work on an intel mac running CS5?

would be a great help thanks.

J
Joe Photo
New Participant
March 21, 2013

Hi,

The only info I had was for CS4 (which we still use for certain functions) even though we mainly use CS6.

E
eudaimon
New Participant
September 12, 2009

OK,

after combing through these posts and trying various 'solutions' I have found that the Barred Rock export metadata script is the only one I have been able to get to work in CS4, kinda. It is a superior script to the original workflow automation script that edo75 refers to, as it does not seem to have the comma issue encountered by jesse and others, where if there are any commas in your metadata it creates a new column and your excel file becomes nonsensical and disorganized. There is a way to avoid this by the way, simply by opening a new file in excel and importing the csv file as text, you then tell excel to read the data the right way by selecting various delimiter combinations. It is not a perfect solution but I have found that by doing this it places most of my metadata in the proper columns, and I end up doing a minimal amount of editing. The barred rock version, which I assume is a modified version of the original script available from adobe as the interface is exactly the same, does not seem to have this issue with commas at all, I am unsure why. If B. Stucky is still reading these posts he may be able to answer, as I think he wrote this script?

Anyhow I was able to get the script to load in CS4 and then I had to tweek the script to recognize my custom metadata schema, which I was able to do. Now however there is an issue with it recognizing the actual metadata in the image files. I suspect it is a mynamespace issue, that is, I do not have the right path for it to locate the actual metadata for export.

here is where I suspect the problem lay, where this "http://NPSAlaskaImageStandard" is incorrect.

new MdNs.MetadataNamespace( "NPS Alaska Image Standard", "http://NPSAlaskaImageStandard", "NPSAlaskaImageStandard" );

I am a total novice with this stuff so this may not be it at all, however this is my best guess, anyone know the answer?

Paul Riggott
Paul Riggott
Inspiring
September 12, 2009

Removing comma's is very easy, all it needs is a regex to replace them.

It might help if you open the "File Info" of the document and look at the "Raw Data", that will give you a clue as to what you need.

E
eudaimon
New Participant
September 12, 2009

Thanks for the speedy reply paul. I have solved the comma issue to my satisfaction. I have larger issues with getting the 'barred rock' export metadata script to recognize and export the actual data I have put into the files. If I enter file data, using bridge, into the other schema such as IPTC etc., and export it will export the data, however when I select my custom schema, it exports the fields only, description, photographer, etc. but no data. Hmmm. Thanks again.

E
eudaimon
New Participant
September 12, 2009

I dropped the javascript file into  C:\Documents and Settings\username\Application Data\Adobe\Bridge CS4\Startup Scripts, where username is your name on your computer, and it added a 'script' choice in the menu bar at the top of the screen, under this was the export to metadata function, it seems to work, most of the time but is quirky. I also cannot get it to recognize my customized metadata schema. Any help here?

Paul Riggott
Paul Riggott
Inspiring
September 12, 2009

Here is a bit of code that you can amend to try to extract your schema field.

You can run the script from ExtendScript Toolkit with selected documents in Bridge

#target bridge
app.bringToFront();
var sels = app.document.selections;

for (var i = 0; i < sels.length; i++){
   var t = new Thumbnail(sels);
   var md = t.synchronousMetadata
   //schema - field to extract
alert(md.read("http://ns.adobe.com/photoshop/1.0/","photoshop:Headline"));
}

E
Edo75Author
Inspiring
August 11, 2009

I have finanlly made some tweaks on the CSV Data Collector script, eg. for the City I replaced "("http://iptc.org/std/Iptc4xmpCore/1.0/xmlns/",  "Iptc4xmpCore:CreatorContactInfo/Iptc4xmpCore:CiAdrCity")" by "("http://ns.adobe.com/photoshop/1.0/",  "photoshop:City")" and it did the job but I miss the Metadata_BR script (Workflow Automation Script), it was more powerfull.

Thanks anyway

Paul Riggott
Paul Riggott
Inspiring
August 11, 2009

This maybe of use?

http://ps-scripts.com/bb/viewtopic.php?t=2365

E
Edo75Author
Inspiring
August 11, 2009

I have already tried but it didn't include all metadata I want, for the IPTC Core it extract only a few, those begin with "Creator:", not fields like Description, Keywords, Country and many others.

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