How to Find and Fix Family Tree Inconsistencies

As I continue adding the missing source citations to my family tree, there's a nice side-effect. I get to review how I've recorded people's facts.

There's one type of fact I want to fix, but I need to be able to see the big picture first. Most of the 85,000+ people in my family tree lived in Italy. Between about 1815 and 1865, their birth record can include their baptism details.

I always record the baptism when it's available. But I didn't always put in the name and address of the church. I didn't think of it until I visited some of those Italian churches. I need a way to find all the baptism facts in my tree that are missing the church's name and address.

How can you find everyone in your family tree with inconsistent details? It's easy!

Family Tree Analyzer makes it very easy to get the big picture I need. I opened my latest GEDCOM file in FTA and clicked the Facts tab. I selected only the Baptism fact and all the relationship types. Then I clicked the button with wording that seems confusing*, but it's the right one. It says, "Show only the selected Facts for Individuals who don't have any of the excluded Fact Types".

*The button's wording confused me because I wasn't excluding any Fact Types.

This opened a new window with the results. I have 24,910 people with a baptism fact in my family tree. Since that's such a long list, I exported the results to a spreadsheet. Then I sorted the spreadsheet by the Location column. Now it's easy to see the locations that are town names, not church names.

Here's an example of what I see. Ten people have a baptism location of Apice (Apice, Benevento, Campania, Italy). A few other people have the full address of the church of San Nicola in Apice. A ton more use the church of Santa Maria Assunta in Apice. I need to:

• revisit the birth records of those 10 people
• see if their baptism happened in San Nicola or Santa Maria Assunta
• fix the address.

Why You'd Want to Do This

This exercise is all about consistency and thoroughness. I've been preaching consistency ever since I began this blog in 2017. That's because doing a task with consistency adds quality to the results. And if your family tree is important to you, you'll want its quality level to be high.

Never overlook consistency:

• Make Consistency King in Your Family Tree
• How to Batch Process Your Genealogy Documents
• Organize Your Genealogy Research By Choosing Your Style

To begin, I'm deleting the spreadsheet lines with duplicate church addresses. Instead of 100 lines showing me the location of the church in Pietrelcina, Italy, I'll keep only one line. This will be my reference for any Pietrelcina baptisms that don't name the church. I have 12 of those, so I'll go to each of them in my family tree and make the correction.

With the duplicate church names removed, my spreadsheet has 6,484 lines. Several are references to remind me of the church name in that town. I see that a TON of lines are from four towns whose source citations I haven't added yet. I'll be working on them soon.

Like every other big project I do, I'll chip away at the smaller groups of people first. I'll pick off the 10 from Apice, the five from Alberona, the 13 from Pago Veiano, and so on.

The first town I addressed is the one whose source citations I completed on Friday. It's called Sant'Angelo a Cupolo, and it's a bit sprawled out. While the population is small, the town has a bunch of hamlets, each with its own church. The spreadsheet showed me that I didn't have a street address for two of the churches I've been entering. I used Google Maps to see exactly where they are and made all my updates.

Next I need to find all the marriages that are missing the name and address of the church!

Need Another Option?

If you don't want to use Family Tree Analyzer, you have a few software options. These include:

• Family Historian (this is the best alternative option)
• Gramps (I didn't find an export-to-spreadsheet option)
• RootsMagic (not the free version, as far as I can tell)
• Legacy Family Tree
• Reunion

Think about your family tree. Is there a type of fact you're better at recording now than you were at first? Wouldn't you like to get it right? Export a spreadsheet and tease out the inconsistencies you'd like to fix.