Deleting double photo-links

that is a a great suggestion!!!

thburkhart

One other thing to try if needed work be to to use Sqlite and keep the media file / Media with the most (max) links and remove the the rest – the script itself would not complicate but I have never tried (or needed to)

1 Like

weiß noch jemand, wie ich die doppelten Einträge in COUNT Trees beheben kann?

From your Count Trees screenshot, your database currently has double sets of each individual. Each of the doubles have different Record ID numbers (RIN). Those all need to be merged:

using Sqlite

Select fsID, Count(rmID) as Qty, GROUP_CONCAT(rmID)
From FamilySearchTable
group by FSID
Having Count(rmID)>1
1 Like