There is another way to manipulate image date and time in the database using the lua script contrib/image_time.lua. It allows the image time to be adjusted (+/-), set, or reset.
On Mon, Aug 17, 2020 at 2:13 PM Tobias Krause <[email protected]> wrote: > Hi, > > updating the database did the job: > > UPDATE images > SET datetime_taken = '2014:04:05 11:11:11' > WHERE film_id = 199 > > Alternatives on Windows: > 1. XnView is able to alter the datetime of the picture prio to import (I > decided not to take the risk of manipulating the image) > 2. Updating the xmp-file and let darktable check for updated xmp files on > startup should work, but this take quite long if the database contains many > pictures... > > Regards > Tobias > > -- 2014:04:04 11:11:11 > > On 17.08.2020 07:11, Tobias Krause wrote: > > Hi, > > Thanks for all the answers. > > For me chancing the date directly in the darktable database seems the > easiest. I'll have a look into that soon and let you know how I did it. > > The reason for the missing metadata is that I do not have the RAWs but > only exports from Lightroom done without metadata... > > Regards > Tobias > > > > On 16.08.2020 17:08, Jean-Luc CECCOLI wrote: > > Hello, > > It may happen that the date is not available, for instance because the > camera was reset and the date / time not adjusted. > Or because they were taken long ago, with a camera that did not embed the > information. > Or... ther may be so many reasons. :-( > It is possible to do almost everything from within the database - I once > succeeded in modifying the path to a series of photos. > You could also use exiv2 (or even xnvew, if I am not wrong) to embed the > information into the files (make a backup of them before, because this may > alter your files in a way that further versions of dt are not able to read > thepm anymore). > > Hope it will help, > > J.-Luc > > > > > > > > > > > Message du 16/08/20 09:04 > > De : "David Vincent-Jones" <[email protected]> <[email protected]> > > A : [email protected] > > Copie à : > > Objet : Re: [darktable-user] Adding/changing datetime > > > > > > > All of my folders carry the date ... and I generally download daily > .... that makes it easy. > > > On 16.08.20 08:52, Tobias Krause wrote: > > > > Hi, > > > > in my database there are a bunch of pictures missing the "datetime" > > information. Unfortunately there is now way I could get the original > files. > > > > Is there a way add/change datetime within darktable - have at least the > > correct day would be key to filtering by date... > > > > Regards, > > Tobias > > > ____________________________________________________________________________ > > > darktable user mailing list > > to unsubscribe send a mail to > [email protected] > > > > > > > > > ____________________________________________________________________________ > darktable user mailing list to unsubscribe send a mail to > [email protected] > > > > > ____________________________________________________________________________ > darktable user mailing list to unsubscribe send a mail to > [email protected] > > > > ____________________________________________________________________________ > darktable user mailing list to unsubscribe send a mail to > [email protected] > > > > ____________________________________________________________________________ > darktable user mailing list to unsubscribe send a mail to > [email protected] > ____________________________________________________________________________ darktable user mailing list to unsubscribe send a mail to [email protected]
