Fam Search Duplicates - Auto Match?

RootsMagic
1

A fellow RM user I sometimes help – has a puzzling issue. He states he never uses Fam Search Tree Share. Has used AUTO match. I am trying to figure out if Auto match can assign the same FS ID to multiple RM id’s. In the case it was 3 Mary’s

unnamed
unnamed1328×222 17.6 KB

is this possible result of AutoMatch or was it to user error?

2

It’s possible for multiple people in the database to be matched to the same FSID. I don’t believe AutoMatch takes into consideration someone else in the database using that same FSID. AutoMatch has to be a really good match to link them. In the screenshot results the names, birth dates and place locations don’t all match up so I would question this all being done by AutoMatch, unless she edited the people after it was AutoMatched.

1 Like
3

Hard to know what happen exactly after AUTOMATCH was done.
It was clear that info was changed (not sure when and by what order sequence by user)

As far as AUTOMATCH if database had 3 RM ID’s with identical info an it met the confidence level those 3 RM ID’s could potentially be linked to the same FS ID — correct?

Kevin

4

Having three different people in RM automatched to the same FSID actually makes sense to me. It suggests that the three people in RM possible need to be merged in RM.

Another possibility is that the three people in RM really are different and really shouldn’t be merged… In this case, two of the three people in RM need to be unmatched (unmatch is a manual rather than an automatic process), and then that the two unmatched people need to be added to FS.

2 Likes
5

I was mainly try to determine root cause of how they got linked in first place
(AutoMatch, user error, or something else) or combo thereof.
I understand of how to correct depending on which scenario.

I ran a query and found only total of about 6 FSID that had duplicate RM IDs – so that was good news
Kevin

6

Here us a script that will find and display when there are more than one RMID to same FSID.

-- Find FSID duplicates by RMID  in RM Database
With [DupFSIDs] AS
(
SELECT FSID, COUNT(RMID)
FROM FamilySearchTable
GROUP BY FSID
Having COUNT(RMID) > 1
),

[DupRMIDs] AS
(
SELECT [DupFSIDs].FSID as DupFSID, RMID
FROM [DupFSIDs]
LEFT JOIN FamilySearchTable  ON FamilySearchTable.FSID  = [DupFSIDs].FSID
)


Select RMID as PID, Surname, Given, [DupFSIDs].FSID  as FSID
FROM [DupFSIDs]
LEFT JOIN DupRMIDS ON [DupFSIDs].FSID = [DupRMIDs].DupFSID
LEFT JOIN NameTable ON PID = OwnerID
WHERE NameType = 0 and IsPrimary
ORDER BY  [DupFSIDs].FSID , Surname, Given