Page 1 of 1

Build database timestamps from EXIV2 data when available

Posted: Mon Dec 24, 2007 2:27 pm
by JoeMerchant
System Info: QNAP TS-109 running Twonky 4.4.2 - client is PS3 60GB v2.10 - wired 100Mbit ethernet connection via router.

I have a database of approximately 15,000 photos snapped over the last 10 years stored on my TS-109. They all have valid exiv2 data, including date and time they were taken. Looking at the files on a Linux box via NFS, they also all have date created timestamps that correspond to when they were initially copied off of the flash card.

When I browse these photos "by date" on the PS3-Twonky, many (most) of them seem to be sorted by some other timestamp, some are correct, most are more recent, and the time always comes out as 12:00am in the PS3 photo album.

If Twonky could build the photo time/date database using exiv2 data it would be much more accurate than whatever they are using now.

Posted: Mon Dec 24, 2007 4:25 pm
by dgelowe
Hi. See http://www.sentex.net/~mwandel/jhead/

I use jhead to read the exif timestamp & rename the photos with the full datestamp. You can even adjust the exif time eg if you have forgotten to set the correct time when on holiday. It's a win32 console app, so you run it from the command line. eg
jhead -n%y%m%d-%H%M%S -ft -ta-7:02:23 *.jpg
will
1. adjust & write new exif time fo a 7 hour 2 minute 23 sec timezone shift / correction
2. rename all photos like 070822-173201.jpg
3. "touch" the file so it's dos timestamp reads the same.

It's perfect for merging photos from two different cameras into correct time sequence.