I have thousands of images that I want to construct a database around (in excel), beginning with info about them available in their metadata (e.g. date, camera name) which is viewable in windows when browsing files and their properties. I don't want to enter these individually. My second goal is to automatically create hyperlinks to their file location on my machine where a link in the database could be clicked and the file launched with a default program. Is this easily possible without purchasing specialized software to do this? Perhaps some macros written in excel could do this?
Hi Eric,
Have you tried this:
http://www.br-software.com/extracter.html
?
From the description it looks like it could do what you are looking for.
Please let us know the outcome.
Thanks,
Peter
There are a large number of meta data editors/viewers. One or more might work for you.
https://en.wikipedia.org/wiki/Comparison_of_metadata_editors
Karen's Power Tools- free software. She has a very useful print directory utility at https://www.karenware.com/powertools/ptdirprn. It will make an Excel compatible list of the items and folders on a drive, and I think you can narrow it down to a specific directory, as you will probably want to do.
The above answers were very helpful and sufficient for me to find an appropriate metadata editor. I was able to automatically assemble the database with hyperlinks to the image files and will all the metadata fields as columns. I've been manually coding up camera trap photos a little bit at a time over the past months - still several thousand to go...
You might be able to build a formula in Excel for the hyperlinks, especially if the photos are all in one folder. Try this:
1. Start with a hyperlink you have already built to a photo. Look at the structure to determine what "wraps" around the file name. i.e. All of the hyperlinks should be exactly the same, except for the file name.
2. The name of the file should be in its own field in the database.
3. Use the "&" formula to build your hyperlinks. eg. =A1&B1. This formula will take text from A1 and join it to B1, so if you have, for example, the word "three" in A1 and the word "four" in B1, it will create "threefour".
- Badges
- Science topic
- Similar topics
- Computer Science and Engineering
- Software