Fixing (removing/merging) duplicate families

I have a tiny little problem with duplicated families in a large database:

Is there any way to automatically fix that, by merging/removing the exact duplicates?
I see tools for duplicate people, media entries etc., but not for families.

Families merge automatically when the respective anchoring spouses are merged. Likewise, when ALL the anchoring people are removed from a family, the family container goes away.

I’m not sure how your Tree managed to have 5 marriages between the same 2 parents of your Cecylia Konkel. There must be differentiating anchors that are keeping them from being merged.

Here are thew first two families. They only differ in ID.

The families are identical, and are still separate families.

2nd photo, as for some reason I can’t put two in a single post:

EDIT:
Oh wait… Plichta, Jozef is not the same person in these families. Will try to merge.

EDIT2:
Merged both Jozefs into one, now families are truly identical. Still no decrease in amount of families.

1 Like

Once you merge Jozef, to get rid of the unneeded Family record, just remove any person (or event, etc) from the record. The family record will then automatically delete itself as unused.

I tried to remove any of the parents or any of the children, and it had no effect. Did you meant remove all persons?

Also, the answer seem to suggest there is currently no automated way to fix this?

Should this be treated as database error (and therefore fixed by currently missing feature of ‘database repair’ option)?

Your account on the forum is only 4 days old. It has limits to keep robots from doing DoS attacks. The limits will ease in about a month.

1 Like

Yes. So long as any other object (person, event, citation, etc) is attached to the family record, it will not delete. As you already know that the same people are populating both families, it will be safe to delete one of the families.

As to how it occurred… who knows. Gramps will not allow you to create a second family where both parents are the same. But it will accept it from an import. The Check and Repair tool I believe checks for these occurrences but unsure how it corrects them.

If you merge both sets of parents in duplicate families, the families will merge together. If however unique people are set as the parents to two families and no merging of people occurs, the families do not merge. Again, how that occurred… unknown.

Both of the ways you’ve speculated about were the reason:

  • some duplicates are due to GEDCOM import of a database which was previously exported with filters - these filters removed some people, making some families identical.
  • other duplicates are due to merging parents/children - when Gramps sees any differences in families of people being merged, then all the families are added to resulting person. I suspect even different order of families on the list will cause the families merge to fail.

Currently, the Repair Tool cannot fix these.

I prefer merging duplicate Family objects over clearing them. It is both faster & safer. (And things like Note links and secondary objects won’t be overlooked.)

Use the Families View to select duplicates & use the Merge toolbar button in that view.

The painful part is navigating the Families View to records to be merged. There isn’t a Families version Merge Media add-on or Merge Citations built-in Tools under Family Tree Processing. Worse, getting the Families view focus to follow the Active Person is arcane.

But the clipboard helps here.

  • From the Relationships view, you can drag any of the Family or Parents rows (by the label or ID) to the clipboard.
  • From the Edit Family dialog, you can drag the Family to the clipboard from the Relationship Information section of the header.
  • From the Edit Person dialog, you cannot directly drag the family from the Events tab. But you can double-click them there to open the Edit Family dialog and use the steps above.

Once you’ve clipboarded the offending families, you can navigate the Families view using the “Make the Family active” contextual menu selection from the clipboard right-clicking the selected clipboarded object’s pop-up menu.

(Note that the Clipboard’s context menu is always based on the SELECTED row… it doesn’t matter if you right-click a different unselected row.)

Remember to change the sorting of the Families view from the ID column to the Father or Mother columns by clicking that column’s header. That way, the 2 record row will be listed adjacently.

Actually it WILL permit this. It just complains before doing so.

I waffle on whether to add a second family for re-marriages. Although it seems the better choice when there was a spouse in-between marriages.

(This reminds of a comedian joke wondering about divorced couples who re-marry. He compared to going the frig, spewing out a mouthful of sour milk you swigged from the carton… then putting the carton back in the frig while saying “maybe it will be better tomorrow”.)

That warning was good enough to stop me from continuing. I stand corrected.

I too have couples that divorced and remarried. One couple doing it 4 times! And yes, I found the divorce records to match.

I’ll need to rethink how I have entered these families.

1 Like