* Jean-Luc CECCOLI <[email protected]> [03-10-19 13:12]: > > Message du 09/03/19 00:23 > > De : "Patrick Shanahan" > > > A : "Darktable Users List" > > Copie à : > > Objet : Re: [darktable-user] Modify paths inside the DB > > > > * Jean-Luc CECCOLI [03-08-19 18:09]: > > > Hello, > >> .../... > > > > > But, then, I would have to manually process the photos year by year, > > > since I apply a preset that writes the year the photo was taken at > > > import. I manually update it each year. > > > > I guess I fail to understand this, "writes the year ..." if you refer to > > writing the year as a tag, dt get the tag from the xmp file. > > I have to set "2019, Jean-Luc C." in the "Author" field of the import menu, > so every photo I import gets tagged accordingly. > And I have to modify this field each year. It would be easier if, for > instance, I could replace the year value with $(Exif_Year), or some other > exif value.
I have mine set in my cameras metadata. dt imports it and it shows in the accompanying xmp file. > > > Of course, if it was possible to use variables within the metadata > > > fields, so one could write, for instance "Copyright $Year_Taken", and the > > > field would be filled with the appropriate value, things would be far > > > easier. Unfortunately, my request still remains at the same point. > > > > all my files contain copyright $year and the moved files maintained that. > > Er... you mean, that you typed "$Year" into the field, in the import menu > options, and it automatically retrieves the correct value from the exifs at > import each time a photo gets imported ? > So, if you import a photo you took in 2015, it will automatically write > "2015" into the correct metadata field ? > If so, the request I filed 2 years ago ought have been closed : > https://www.darktable.org/redmine/issues/11445#change-35440 no. dt reads it from the camera metadata > > > So, the second way would be to replace the paths directly within the DB > > > which - I confess - I can't do. > > > >From sqlitebrowser, I could open the DB and find where the paths appear, > > > >but I couldn't find anything looking like a find & replace tool. > > > Maybe someone there could give me some hint ? I can use sqlitebrowser on library.db and sort browse data film_rolls field, select all using <path-to-change>, paste <new-path> in "edit database cell" and they are all changed. that is the closest to a "find & replace" as I see. -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri Registered Linux User #207535 @ http://linuxcounter.net Photos: http://wahoo.no-ip.org/piwigo paka @ IRCnet freenode ____________________________________________________________________________ darktable user mailing list to unsubscribe send a mail to [email protected]
