Skip to main content
Participant
July 19, 2007
Question

export metadata script ?

  • July 19, 2007
  • 22 replies
  • 10221 views
Hello, I need to export all the metadata from a library of images to a comma delimited txt file which will then be loaded into mysql.

Does anyone know of a bridge script that will do this ?

thanks kindly for any help.
This topic has been closed for replies.

22 replies

Participating Frequently
May 7, 2008
To accomplish this easily then you will either have to remove the commas from the source data or remove them as you are doing the export.

To remove them as you are doing the export is simple enough but that may give you undesirable effects (now and/or in the future).

I'm not sure how much of a pain it will be but I would change the source data, especially if it is an easy task.

:)
Known Participant
May 7, 2008
Chanandler_Bong@adobeforums.com wrote:
> To accomplish this easily then you will either have to remove the commas from the source data or remove them as you are doing the export.

Another alternative is to have the script output semicolon separated values.
Yet another is to put "" around all string values going into a csv file.

-X
Known Participant
May 7, 2008
UGHHH. the content I need to export (ad copy - EX. Nestlé Miniatures, 10 oz. Mars Minis, 10.5 or 11.5 oz.) Has COMAs. Since I'm exporting it to a CSV file. It's dividing all my text into different fields!

Can I export this to a normal Excel file?

Thanks again!
Known Participant
May 7, 2008
I figured it out. Thanks for all your help!

new MdNs.MetadataNamespace( "store", "http://ns.adobe.com/store/", "store" );
Known Participant
May 7, 2008
Thanks Chandandler. I'll get there, hopefully sooner than later!
I added the above lines to "Metadata_BR.jsx" and my script is getting an error.

My custom panel I'm trying to add is located in

I'm a little confused as to what to put in the "mycustomnamespace", my prefix" spot on line 980

for example,
line 891
new MdNs.MetadataNamespace( "IPTC Core", "http://iptc.org/std/Iptc4xmpCore/1.0/xmlns/", "Iptc4xmpCore" );

My custom panel is called "store" and it's located in Library > Application support > Adobe > XMP > Custom File Info Panels > store.txt
I duplicated another panel and just did a find/replace to create my custom one. Do I need specific information from this file to plug into the "Metadata_BR.jsx" script?

new MdNs.MetadataNamespace( "store", "http://store", "myprefix" ); // What is the myprefit pertain to?
Again, thanks very much for any help. I greatly appreciate it!
Participating Frequently
May 7, 2008
You can modify the script to export your custom metadata but you will need to add a couple of lines, for example:

new MdNs.MetadataNamespace( "MyCommonName", "http://mycustomnamespace", "myprefix" ); // add around line 980

And then add the fields that you want to be able to export:

new MdNs.MdElement( "MyCommonName", "MyField", true );
new MdNs.MdElement( "MyCommonName", "MySecondField", true ); // add around line 1033

Hope this helps.
Known Participant
May 6, 2008
I am having the same issues. I have a custom metadata panel with about 8 fields I wish to export. Can someone please shed some light on where and how to add this to the script?
Thanks!
Participant
April 21, 2008
Is there anyway to get this Export Metadata script to work if I only have PS CS3 and not the entire CS3 suite? I am in desperate need of a script that will export technical metadata from images in Bridge.
Participant
March 6, 2008
I added a Custom Info Panel with about 8 fields, and I will probably be adding a couple more. Can I add the entire panel to the data to be exported?

thanks,
Paul
Participant
September 10, 2007
Thanks Chanandler for your help.
Participating Frequently
September 7, 2007
The XMP Media Management schema has a PreservedFileName property. You could add this to the ExportMetadata script.

If you want to try this then add the following to the script:

new MdNs.MdElement("XMP Media Management", "PreservedFileName", true);

If you add that code around line 1135 in the Metadata_BR.jsx. This will enable you to select and export that property when you run the script.

Cheers.