You can extract all the required information using the BarredRock script near the end of this thread..
or you could use ExifTool http://www.sno.phy.queensu.ca/~phil/exiftool/
I haven't been able to proceed from either of these.
I downloaded the exiftool and clicked on it and it produced a file, exiftool(-k) application.
when I click on it a command prompt type window opens and says I can drag and drop files onto the exiftool executable, but when I try to do this with this in the explorer folder, it just puts the file next to it.
I don't find any program icons so I dragged it to the desktop and tried that and see nothing happen.
The black window says I can rename it to exiftool(-a -u -g1 -w txt).exe)
I can't in explorer for some reason, so I did so to the desktop icon I created, but I get the red slash that a file can't be dropped here, so I don't know how this is supposed to work or see any result.
then I tried reading the thread about the barred rock script, but I don't understand how this works either. Am I supposed to copy the script to a command prompt. Near the end it says that it worked on CS2 but not later versions.
Will either of these result in a table of names with the desired data (description, location, date, mainly)
I appreciate the info, but haven't been able to use it.
If it's only a few fields this script might do.
Install instructions are on the page and they would apply to the BarredRock script as well. This script will work with CS2 or better (including CS6)
I put that script in as instructed and at first it didn't work.
This was because I need to extract the metadate from the NEF files, because these are a complete set of all saved files.
I tested with jpegs and it worked, but this is just a subset of the needed files to add to my database, so isn't useful for my purpose.
I then downloaded, unzipped and put the Barred Rock script in the same way.
When I reopened Bridge and clicked metadata, there was only the extract script and so it didn't work.
I have modified the Extract Metadata script so that it will extract from raw files (NEF,CR2 etc) so please download the zip again for the new version.
This worked great. Thanks very much for your help. It will save me a lot of tedious double entry of the data to my Access database.
I see that it added the sublocation though the category says location, so that was beneficial.
I would like to learn more about these scripts. Is it possible to add more categories, such as State and country?
Again, thanks very much for the extra help.
I see that it does include country but for some reason that category doesn't show up in the result, nor does city.
I mean the title is in the top row, but there are no listed cities or country.
It works for me, maybe you are using different fields.
Could you tell me what version of Bridge you are using and what schema(s) and field names you want extracting.
(See Rawdata in File Info)
Bridge CS6 22.214.171.1249 x64
I looked as you suggested.
Could it be that your city and county are for the IPTC Contact, while mine are under IPTC Image.?
Here are date created, sublocation, city, State/Province, Country.
I have changed the IPTC City and Country to the Photoshop Schema.
Could you please try this now.
If you let me know what fields you would like added I will try and add them.
that worked very well now.
I am thinking that I probably won't use instructions, nor copyright info or author
But state/province would be usefull and job identifier.
If camera data can be used, I add model number to my database.
I am thinking I could use description writer as an added category for other info which Adobe doesn't have categories for.
this is a great help and I much appreciate it. So far I am just testing, as I am up to date on my images, but after the next camera downloads and edits I will put it to real use.
I have now added those fields, hope it will be of use to you.
I tried the script and it worked well for me, except the state/rrovince was blank. I think it must be from the category where the city and country wer before that didn't show.
Previously it was a very convoluted procedure for me to get the info to my Access database. I would first enter the info in MSWorks database, because of the time saver of the fill-down and fill series that MSAccess doesn't have. After entering all the info I would save it as a text file and import into Access after assigned the fields, some of which had to be modified slightly as one for example would such as slide # and the other slide_#, One I couldn't change and if I changed the other in ACCESS then all the queries and reports based on it would have to redone also.. I would get the fields to coincide and then do an append query to add to the main table.
I had only one location field when I set up the database, and not separate ones as in Bridge, so city, state and country would all be in the same field. I would only add country when it was not US which was seldom.
In anticipation of the ability to import the different location fields, I added city, state/province and country to the database, and then I spent about 8 hours creating hundreds of update queries, for each state, city and country to have the data of 166,000 records in the respective fields.
I did a sma run yesterday with a folder that only had a couple dozen images. I have to reorder the fields somewhat, but this is promising to be a huge time-saver and I look forward to using it when I have some much bigger downloads to convert.
Thanks very much for all your help with this.
I have now altered the state/province to the Photoshop one.
Glad it may be of use to you.
I have been busy catching up on my backlog of downloaded files, weeding and editing, and then batch renamed them according to my numbering system. I fianally got to the stage where I was to put the script to serious use.
I then downloaded the latest version of your extract files script and it worked fine on all the fields.
But I was doing a folder with 103 images selected, and the text document only had the first 35. Is there a limit on the number of records?
This was my smallest folder and the other 2 have about 200 and 1200 images each to do.
Thanks for all the help to this point.
Actually, I did one of the other folders and it did them all.
I have found that the problem is that it sometimes stops on some movie file and will go no further. I'm not sure why.
I have just used script to extract metadata. Once I found it extracted to the desktop, Great!
Thanks for that.
The reason it stopped I found was when there was no description. by adding descripition or removing those that couldn't have one added, from the folder selection, then it worked fine.
Thanks again for this great time-saver. I have used it several times now with hundreds of images.
I have found this so useful, and am about to go on a trip where I would be taking lots of shots and planned to add to my database as I went. but then I realized I don't have this script on my laptop. I was trying to return to the link on the thread and it said no longer available. I think I have the download somewhere on my PC but don't remember the instructions. Could you help again, please?
I didn't see the desired script there, but I should have it downloaded somewhere. But how do you get the script into Bridge?
I found it, dragged and dropped to the laptop, and double clicked and it seems to have installed itself in Bridge, appearing in a new metadata tab.
You will find the script in the "Bridge Scripts" section and instuctions are on that page.
Its near the bottom "Extract Metadata" use the down arrow until you see it.