> Message du 12/03/19 00:27 > De : "Patrick Shanahan" > A : "Darktable Users List" > Copie à : > Objet : Re: [darktable-user] Modify paths inside the DB > > * Jean-Luc CECCOLI [03-11-19 14:45]: > > > Message du 11/03/19 04:20 > > > De : "HaJo Schatz" > > > A : "Jean-Luc CECCOLI" > > > Copie à : > > > Objet : Re: [darktable-user] Modify paths inside the DB > > > > > > On Mon, Mar 11, 2019 at 1:10 AM Jean-Luc CECCOLI wrote: > > > > > > 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 > > > > >> Not in front of my box right now, so there's certainly some small errors > > >> in it, but -- have you ever considered something like > > >> $ exiftool -d %Y -copyright="(c) $dateTimeOriginal Jean-Luc" > > >> /path/to/your/photos > > >> which should set the correct year in all your photos. Darktable should > > >> be able to pick this up, I assume. > > > > Well, my client decided to eat my previous reply... so let's starting over > > again. :-( > > > > I think you misunderstood : I don't want to write anything into my raw > > files, which might end up in further probllems. > > I'd like DT to read the date the raws were taken at, and write it into the > > metadata field. Which DT is not able ATM. > > However, reading Patrick's reply, I realized that the value being already > > into the sidecars, removing the pictures from the DB and reimorting them > > ought to do the job. > > Or, maybe, just movinf the db elsewhere to keep it safe, then reimport the > > pictures. > > Test on a few old pictures first, and see what happens. > > or: > copy/backup you library.db > move the photos > open library.db in sqlitebrowser > select browse data > sort on folder > select the lines for the moved photos > in the edit database cell area on the right, insert new location > save library.db > > test for validity > > if it didn't work, replace library.db with backup, reimport moved photos > > > using sqlitebrowser will be much quicker, if it works. > Yes ! I finally found how to do ! In the window named "Execute SQL" I typed
UPDATE film_rolls SET folder = REPLACE( folder, 'the_old_string', 'the_new_string'); It took less than 5 ms to do the job ! Just one or two more things to test before I go on. Regards, J.-Luc ____________________________________________________________________________ darktable user mailing list to unsubscribe send a mail to [email protected]
