Skip to main content
_
_philip_francis_
Participant
July 19, 2007
Question

export metadata script ?

  • July 19, 2007
  • 22 replies
  • 10206 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

E
Edo75
Inspiring
August 11, 2009

Is this script works in Bridge CS4 ? The text file say that we must have WorkflowScriptLoader.jsx and WasScriptLibrary.jsx, I had these on CS3 but not in CS4.

D
Dubhead
Participant
December 2, 2010

I am wondering the same thing.  I am getting an error message that indicates "JavaScript error (Auto-Stack Panorama/HDR:1309): WasLoader is undefined"

I am running Bridge CS4 v. 3.0.0.464 in OSX 10.6.4.  The error message may be indicating that the .jsx scripts Edo75 is referring to are still needed? Or is it something else.  Checking at line 1309 in the .jsx file, it does appear that the script is checking to see if the WasLoader.scripts.library has loaded prior to this script.  Where would I get that?

Thanks,

~Dubhead

_
_Lori_Burr_
Participant
January 12, 2009
Hello. I am attempting to ultize the Export Metadata script for Bridge and it works really well, with one major exception. For the Date Modified field I am getting the Windows modification date rather than the date that is found in the File Info on my .ai file. This date is crucial for us at this point and I am wondering if anyone can assist?

Also, once I have the metadata showing, is there any way to export all files' metadata to a csv ?

Thanks in advance.

L Burr
_
_Konstantin_by_
Participating Frequently
November 30, 2008
No solution et?

Good Luck.
______
My Si tes
_
_Lia_Pileggi_
Participant
May 27, 2008
The main reason it gives is that 'it may not be compatible with this version of Bridge".
But the more detailed error says
Error...
Line 636:createMenu("menu",'Scripts","after Tools","scripts");
createMenu is not a function
_
_Jesse_James7_
Known Participant
May 27, 2008
What error message are you getting?
_
_Lia_Pileggi_
Participant
May 27, 2008
Has anyone gotten the Barred Rock ExportMetadata script to run on CS3? Is there something I am missing? I have all the AdobeLibrary files.

Thanks
A
Anonymous
May 7, 2008
Well, I wrote that one too.

It creates default a default paragraph style for labels called "Labels".

If you want something else, use InDesign to modify the Labels style. You can also create a template that contains a style named "Labels", the script will use it, if it's there.

Bob
_
_Jesse_James7_
Known Participant
May 7, 2008
Phewwww. OK. I've actually given up on the Export to CVS. Although it's really a great script, I opted to try to go into the "ContactSheet_ID.jsx" script and tweek that one. I've somehow managed to get it so that I can choose my custom templates from the "caption" portion.
Now I'm stuck on how this script created the Paragraph style "Labels" that is making my fields come in as Times TT

Thanks again all!
_
_Chanandler_Bong_
Participating Frequently
May 7, 2008
It does indeed put quotes around the each output field :)
A
Anonymous
May 7, 2008
My recollection of the code is that it does put quotes around every data item.

Bob
C
cfidler
Participant
December 8, 2009

Hi Bob,

The file correctly puts values containing commas in quotes but it appears that the quotes are not being recognized during the export.  Values are still being separated by commas regardless of the quotes.  I tried to change the file so that it would export to a .txt and .xls but it takes some modification to get it right.  It exports with all the commas.  I can't seem to find in the code where it is using the comma as the delimiter or how to make the script recognize the quotes.  Otherwise, all my fields from my custom panel are coming in.

Do you have any suggestions?

Thank you,

Chris

C
cfidler
Participant
December 10, 2009

For those who come across similar problems:

I modified the script so that it wouldn't add quotes to the either the column headers or the values.  I also changed the delimiter to a semi-colon (and you can choose any character you like, it doesn't have to be a semi-colon).  When I open the file in Excel, I simply to a text to column using the semi-colon as the delimiter.  Everything is then parsed correctly.

for ( var i = 0; i < mdItems.length; i++ ) {
                    if ( i == 0 ) {
                        theRecord += ';' + mdItems[ i ].element.property + '';
                    } else {
                        theRecord += '; ' + mdItems[ i ].element.property + '';

and...

        if ( a == 0 ) {
                            theRecord += ';' + val + '';
                        } else {
                            theRecord += '; ' + val + '';
                        }

It's a hack but it works.  You can leave the script as is and edit or view in a text editor but in order for it to behave correctly in Excel, some modification is required.

Christina

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