Hi,
Thanks for all replies while I was away from keyboard for the weekend.
I have been playing with duplicate tools and digikam before but did not
really find a good workflow. As darktables database offers all
information I need to find (almost all) duplicate images in my setting I
did not want to run digikam or other tools for days an 100,000 images
while the query would to the same in just seconds.
Therefore the idea to query the database directly just struck me as its
so straight forward to find the duplicated and attach a tag to them.
About my setup and current workflow:
* darktable on windows
* pictures stored in different locations but shall all be moved to the NAS
* the source picture usually does not get renamed
* there is a folder contains all cleaned and sorted pictures in
different subfolders
o @[email protected]: I was thinking of your suggestion, but as
most pictures are already sorted I did not want to break down
the folder structure to a single folder again
* duplicates shall be tagged and then trashed using darktable -
keeping the database and the files in sync
* in the first step a duplicate in my case is defined as a picture
stored not in the clean folder which has a equivalent picture in the
clean folder - the query for tagging these pictures is easy and fast
o maybe I'll have to change to query for more details in the
second step but right now this does the job for me
In case somebody is interested please find the query below:
INSERT INTO tagged_images(imgid, tagid)
SELECT i.id, 343 AS tagid -- tagid of the tag
has_duplicate_in_clean_folder
FROM images i, film_rolls fr
WHERE i.film_id = fr.id
AND i.datetime_taken IS NOT NULL
AND i.datetime_taken <> ""
AND fr.folder <> "CLEANFOLDER%"
AND i.filename IN
(
SELECT i.filename
FROM images i, film_rolls fr
WHERE i.film_id = fr.id
AND fr.folder = "CLEANFOLDER%"
)
Regards
Tobias
On 15.02.2020 21:36, Tobias Krause wrote:
Hi,
I just started using darktbale - in the first step mainly as DAM tool
trying to clean the mess of photos that have been spread over different
devices, folder, ...
First things first: darktable is amazing and after just using it fore
some days I wonder how I could ever use something else. Thanks to all
developers!
Unfortunately quite some of the the photos are stored more than once and
there is no "main" folder containing all images.
Is there a way to find photos in the database which are the same by
filename and date? Knowing a photo has a twin would make live easier
when it comes to trashing duplicate files: trash all photos in a
specific folder which have a duplicate in some other folder.
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]
