Quote from kevync on 2025-01-29, 9:17 am

Good Morning

I also posted this on community board

https://community.rootsmagic.com/t/bug-rm-upload-to-ancestry-missing-people-on-ancestry/13094

I do not think this is expected – if it is – than need to know why. I did this because a friend reported he had an issue last night. Seem I have found the same thing he did.

Did a fresh upload from ‘new’ RM Database to a new Ancestry tree – counts do not match (1120 diff). Double checked in SQL

image601×294 59.4 KB

 

-- RM not in Ancestry QTY
SELECT Count(PersonID) as QTY
FROM PersonTable
LEFT JOIN AncestryTable ON PersonID = rmID
WHERE anID is null

count was 1023 diff.

Looked at who they were.

-- missing Ancestry people in RM by PID
SELECT PersonID as PID, ParentID, SpouseID, Relate1, Relate2, Flags, Living, anID
FROM PersonTable
LEFT JOIN AncestryTable ON PersonID = rmID
WHERE anID is null

results (nothing stood out ) --snippet below/attached

is puzzling as the missing people (at least first glance seem to be random) - RM id all over-- different relationships to set relationship person (or root for that matter)