Hello
Can all Exif data from each image be saved in the database when uploaded?
Thanks
Olaf
Piwigo URL: https://schneider-fotografie.com
Offline
I don't think it can. Table `piwigo_images` contains a very limited set of fields (date+time, title, caption, geolocation) and IMHO there is no extension that allows a free form full set. Also, there are over 100 standardized Exif fields plus arbitrary manufacturer proprietary MakerNote fields, so storing "all Exif data" in a web view gallery's database might be a bit far fetched.. You'd probably also want not only Exif but also IPTC and possibly XMP data.
Offline
If you want display more EXIF, XMP, IPTC info next to your image you can use EXIFTOOL and some theme template modifications. I use it to fetch additional info on the spot when an image is displayed and it goes remarkably fast. So info not stored in the database. I use Lightroom to add the metadata and then publish it to Piwigo.
I am still working on it by modifying an existing template and are sofar happy with it. Site is being worked upon to get it working for different (Nikon) camera's and scanned negatives. It shows at least what is possible via EXIFTOOL. I am not an experienced developer in php, but can develop in other languages so that helps to find my way in piwigo templates/themes and some PHP modifications.
If complete I will likely post an article on my website how I did it.
https://gallery.fotokruse.eu/
Offline
Hello
Thank you for your answers. The standard Exif data is:
- Thumbnail
- Date and Time
- Camera type
- Focal length / lens
- Exposure time
- F-number
- exposure program
- Exposure index (ISO value)
- Geographic coordinates
If the data were read out immediately when the image was uploaded and stored in the database, then you could integrate this Exif data into the search and explicitly search for a camera or lens. I have now saved the camera types and lenses in the tags in my gallery and everyone can search for them and make comparisons. Just like on my search page.
my search page
Many greetings from Berlin
Olaf
Offline