After adding info to the metadata, such as city, sublocation, state, description, I have to enter all the same data to an MSwroks database that i then import into MSAccess.
I thought maybe there was some way to just transfer data with the same field names and thought of adding more of Windows Explorer tags. The date created already is there so I searched the list and added city, and state, camera model, etc. But then those fields and others were still blank, though filled in Bridge.
. So I am wondering how such information would get into Explorer to be displayed, if Bridge's categories aren't the same.
IS there any way to export such desired information from all the images in a folder. I just finished supplying the data to another 800+ images recently shot and don't relish entering it all again into the MSWorks database.
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.
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.
Bridge CS6 18.104.22.1689 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.
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 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 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.
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.
Europe, Middle East and Africa