* Search and delete duplicate Family

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile. If your question fits in one of these subject-specific sub-forums, please ask it there.
avatar
Viper1812
Gold
Posts: 17
Joined: 04 Dec 2023 19:59
Family Historian: V7
Location: Lancashire

Search and delete duplicate Family

Post by Viper1812 »

Hi all 8-)
I`ve read all the above and downloaded the suggested query. However, it does not appear to help my issue. When i look at my Focus window for one of my ancestors are showing 2 marriages exactly the same details down to the same I.D number. How do i delete one without loosing them both? :?:
Roger
User avatar
tatewise
Megastar
Posts: 28436
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Search and delete duplicate Events?

Post by tatewise »

Roger, I suspect you may have duplicated the spouse family relationship and not duplicated marriages.
The easiest way for us to confirm that is if you post a screenshot of the entire Focus Window.

See FHUG KB Forum Usage Tips under Attachments and Taking Screenshots for how to post the screenshot.
i.e. Take the screenshot with Windows Snip & Sketch and then Copy (Ctrl+C) and Paste (Ctrl+V) into your reply.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
LornaCraig
Megastar
Posts: 3203
Joined: 11 Jan 2005 17:36
Family Historian: V7
Location: Oxfordshire, UK

Re: Search and delete duplicate Events?

Post by LornaCraig »

(EDIT: Mike's reply arrived while I was writing this. I'll post mine anyway, but as Mike said a screenshot will help to confirm the problem.)

You have two Family Records for the couple. Deleting one of the Family records won’t delete the individuals, so it’s safe.

In the Records window look at the Families tab. (If it’s not displayed, use Tools > Preferences > Records Window and under Record Type Display Options set Families to Always show). Click the first column heading to make sure the records are sorted by surname of husband. Now scroll down until you find the two identical Family records. Select one of them and hit the delete key.

Alternatively, if you need to check that there are no differences at all between the two records, you can select them both and then use Edit > Merge/Compare Records.

By the way, if this was the result of a full file merge it may mean that you didn't merge any Family records at all. So there will be a lot of duplicate Family records.
Lorna
User avatar
tatewise
Megastar
Posts: 28436
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Search and delete duplicate Events?

Post by tatewise »

Further to Lorna's reply, we need to check whether there are any actual Marriage Events for the couple.
That is why a screenshot of the Focus Window is so important as it shows Marriage details too.
If you delete a Family record it won't delete Individual records, but may delete a Marriage or other Family event, so may not be entirely safe.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
avatar
Viper1812
Gold
Posts: 17
Joined: 04 Dec 2023 19:59
Family Historian: V7
Location: Lancashire

Re: Search and delete duplicate Events?

Post by Viper1812 »

Tatewise is this what you require.
image.png
image.png (339.18 KiB) Viewed 635 times
Last edited by tatewise on 14 Mar 2024 16:18, edited 1 time in total.
Reason: Removed duplicate image
Roger
User avatar
tatewise
Megastar
Posts: 28436
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Search and delete duplicate Events?

Post by tatewise »

Yes, thank you.
That confirms what Lorna and I suspected and you have accidentally created a duplicate Family record.

What is not clear is whether the lower duplicate couple has a Marriage event and the same Child, Robert as the upper couple or some different data.

Until we know for sure what is recorded against the lower couple it would be risky to advise any action yet.

So please scroll the Focus Window down to reveal those details and post a screenshot.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
LornaCraig
Megastar
Posts: 3203
Joined: 11 Jan 2005 17:36
Family Historian: V7
Location: Oxfordshire, UK

Re: Search and delete duplicate Events?

Post by LornaCraig »

The safest option is to merge them rather than delete one. As I said in my previous reply,
"... if you need to check that there are no differences at all between the two records, you can select them both and then use Edit > Merge/Compare Records."

I suspect that no family records were merged at all when the original file merge was done.
Lorna
User avatar
tatewise
Megastar
Posts: 28436
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Search and delete duplicate Events?

Post by tatewise »

I agree with that but your very first suggestion was: "Deleting one of the Family records won’t delete the individuals, so it’s safe." whereas it may not be safe as we both agree. It needs further investigation to determine the simplest solution.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
LornaCraig
Megastar
Posts: 3203
Joined: 11 Jan 2005 17:36
Family Historian: V7
Location: Oxfordshire, UK

Re: Search and delete duplicate Events?

Post by LornaCraig »

Yes, my original suggestion was based on what Roger said:
"....showing 2 marriages exactly the same details down to the same I.D number. How do i delete one without loosing them both? "
I assumed that "all the details" meant he had already checked everything and there were no differences. But it's better to be safe than sorry.
Lorna
avatar
Viper1812
Gold
Posts: 17
Joined: 04 Dec 2023 19:59
Family Historian: V7
Location: Lancashire

Re: Search and delete duplicate Events?

Post by Viper1812 »

Hi Lorna & Tate

Is this what you need :?:
Attachments
Screenshot 2024-03-14 171029.png
Screenshot 2024-03-14 171029.png (283.49 KiB) Viewed 596 times
Roger
User avatar
tatewise
Megastar
Posts: 28436
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Search and delete duplicate Events?

Post by tatewise »

No, sorry, that just confirms what we can see in your Focus Window screenshot.
The duplicated Spouse: tab confirms the duplicated Family problem.

As I requested, we need to see the Focus Window details for Marriage and Children that are just off the bottom of the screen in your original screenshot.

Alternatively, the other Spouse: Alice tab for Thomas would provide the same details.

Alternatively, use the Families tab in the Records Window and find the duplicated entries for Thomas and Alice.
Then fully expand the details to show any facts and children.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
avatar
Viper1812
Gold
Posts: 17
Joined: 04 Dec 2023 19:59
Family Historian: V7
Location: Lancashire

Re: Search and delete duplicate Events?

Post by Viper1812 »

Mick is this what you mean?
Attachments
Screenshot 2024-03-15 182239.png
Screenshot 2024-03-15 182239.png (296.29 KiB) Viewed 540 times
Screenshot 2024-03-15 182051.png
Screenshot 2024-03-15 182051.png (288.72 KiB) Viewed 540 times
Roger
User avatar
tatewise
Megastar
Posts: 28436
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Search and delete duplicate Events?

Post by tatewise »

No, I said nothing about the Property Box Facts tab.
However, it is clear that you have entered two Marriage events with slightly different dates. Which is correct?

In your earliest screenshot, you showed information similar to the red-outlined data below.
What we need to see is information similar to that highlighted in yellow below.
You just need to scroll the display up to reveal those lower details.

image.png
image.png (128.42 KiB) Viewed 463 times
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
avatar
Viper1812
Gold
Posts: 17
Joined: 04 Dec 2023 19:59
Family Historian: V7
Location: Lancashire

Re: Search and delete duplicate Events?

Post by Viper1812 »

Mick :oops: im new to this so sorry not sending what you need. Hope this is right. The date is 6 Jan 1630 and came from Ancestry marriage Register.
Attachments
Screenshot 2024-03-16 125620.png
Screenshot 2024-03-16 125620.png (402.78 KiB) Viewed 451 times
Screenshot 2024-03-16 1thomas.png
Screenshot 2024-03-16 1thomas.png (389.65 KiB) Viewed 451 times
Roger
User avatar
tatewise
Megastar
Posts: 28436
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Search and delete duplicate Events?

Post by tatewise »

Yes, that is right. It is sometimes difficult to judge the experience of users who post questions.

These latest screenshots reveal interesting differences that need careful handling. So I'm glad we persevered.

The upper family have a Marriage date but no place and one child Robert MASON Rec Id [1411].

The lower family have a Marriage date & place and 6 children including Robert MASON Rec Id [306].

Are those two children Robert MASON with two Rec Id meant to be one and the same person?
i.e. Do those two Individuals need to be merged?

It might help us understand the extent of your 'duplications' and how much correction may be needed if you could explain how this situation has arisen.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
johnmorrisoniom
Megastar
Posts: 904
Joined: 18 Dec 2008 07:40
Family Historian: V7
Location: Isle of Man

Re: Search and delete duplicate Events?

Post by johnmorrisoniom »

Thomas Mason also has 2 birth events with slightly different info.
avatar
Jacque
Newbie
Posts: 4
Joined: 01 Apr 2024 17:36
Family Historian: V7

Re: Search and delete duplicate Family

Post by Jacque »

Hello. I am brand new to this forum and pretty new to FH in general. I hope I'm not being rude by jumping into someone else's topic but I am having the same issue, so I thought it might simplify things - please let me know if I should do something else. I believe that my duplicates have the same information in each, with the exception being one has 2 children and one only has one child. I am currently adding individuals to the family and when I do, it continues to duplicate them all. When I try to use the "merge/compare records" under "Edit" I am able to see a side-by-side comparison but when I highlight and click on the right arrow and click "OK" I get an error message that says "you must select 2 and only 2 records for merging". I have been working on this for hours, have read the FH merge directions and KB and obviously am doing something wrong. I would appreciate any help!
Attachments
FH merge error.PNG
FH merge error.PNG (91.63 KiB) Viewed 278 times
FH merge tellev family.PNG
FH merge tellev family.PNG (176.82 KiB) Viewed 278 times
User avatar
LornaCraig
Megastar
Posts: 3203
Joined: 11 Jan 2005 17:36
Family Historian: V7
Location: Oxfordshire, UK

Re: Search and delete duplicate Family

Post by LornaCraig »

Hello, welcome to FHUG.

I think you probably have only one record for Tellev and only one for his wife Tone, but you have created two Family records for them.

First, click on each of the two boxes for Tellev in the Focus window to open his Property Box. Is the Record ID (shown at the top next to his name) the same in each case? Now do the same for Tone. Is her Record Id the same in each case?

If either of them has more than one Record ID you need to start by selecting the pair of Individual records for merging. After that you will need to merge the Family records.

If the Individual records are not duplicated you can go straight to the Records Window, Families tab. (If the Families tab is not showing, use Tools>Preferences>Records Window and under Record Type Display Options set Families to Always show.)

By default the Family records will be sorted alphabetically by the husband’s surname. You should find there are two Family records for this couple. It is those Family records which need to be merged. Select them both and then use Edit > Merge/Compare records.
Lorna
avatar
Jacque
Newbie
Posts: 4
Joined: 01 Apr 2024 17:36
Family Historian: V7

Re: Search and delete duplicate Family

Post by Jacque »

Hi Lorna,
Thank you. My next question is, in one family Tellev and Tone have two daughters and one family only one. If I merge them, will it merge to both daughters, or how do I switch that. Right now, it looks like I am merging from the family with two daughters to the family with 1 daughter.
User avatar
johnmorrisoniom
Megastar
Posts: 904
Joined: 18 Dec 2008 07:40
Family Historian: V7
Location: Isle of Man

Re: Search and delete duplicate Family

Post by johnmorrisoniom »

The family merge process will not merge the daughters unless you select and merge them during the merge process
User avatar
tatewise
Megastar
Posts: 28436
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Search and delete duplicate Family

Post by tatewise »

John, I think you are wrong.
When merging two Family records any children will automatically sync or be added by default.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
LornaCraig
Megastar
Posts: 3203
Joined: 11 Jan 2005 17:36
Family Historian: V7
Location: Oxfordshire, UK

Re: Search and delete duplicate Family

Post by LornaCraig »

I agree with Mike, any extra children will be preserved by default. You would have to deliberatley remove them if you didn't want them to be kept.

However, to answer jacque's question about how to switch the order of the records being merged, this is from the Help file:
A Selector Dialog will appear which will let you confirm the records you want, and their order. The second record will be merged into the first. It doesn’t make much difference which you merge into which, but if one record is older or larger than the other it probably makes sense to put that one first. You can re-order the records in the Selector Dialog (use the up and down arrow buttons in the top-right corner).
Lorna
avatar
Jacque
Newbie
Posts: 4
Joined: 01 Apr 2024 17:36
Family Historian: V7

Re: Search and delete duplicate Family

Post by Jacque »

Thank you all. You've been a huge help!
User avatar
johnmorrisoniom
Megastar
Posts: 904
Joined: 18 Dec 2008 07:40
Family Historian: V7
Location: Isle of Man

Re: Search and delete duplicate Family

Post by johnmorrisoniom »

Mike,
What I meant was that the family would be merged but the children from both would be present. If any were in fact the same child they would also need to be merged. This is what I think the OP was worried about
User avatar
LornaCraig
Megastar
Posts: 3203
Joined: 11 Jan 2005 17:36
Family Historian: V7
Location: Oxfordshire, UK

Re: Search and delete duplicate Family

Post by LornaCraig »

I thought the OP was worried that if the family with two children was merged into the family with one child the extra child would be lost. (It wouldn’t be)

It’s true that if any of the children in the two families have different ID numbers but are in fact the same person they would need to be merged, or one could be selected to be discarded during the merge.
Lorna
Post Reply