Catch and Fix Your Missing Source Citations

Wouldn't it be great to have a safety net to catch all your forgotten source citations?

At times we all overlook adding sources to the family tree. When we start out, we don't know any better. Other times we forget or can't be bothered. These unsourced facts add up. And they make our online trees look less reliable.

There are a few reasons why facts in my family tree are missing a source citation:

1. I never add a source for a person's sex. It seems unnecessary.
2. I never add a source for an estimated birth year. If it's an estimate, there is no source. It's either 25 years before the birth of their eldest child or 25 years after the birth of their younger parent.
3. Something happens to distract me in that moment.
4. I experienced the fact (such as attending a wedding or funeral) but have no documentation.
5. I'm in an excited rush because I just found all this great information, and I can hardly believe my luck!

Most of the time it's #5.

So, how do we find these unsourced facts before things get even more out of control? In a word: software.

It's easy to create an Undocumented Facts report in Family Tree Maker. Go to Publish / Source Reports / Undocumented Facts. I chose to share it as a CSV file. You can open a Comma-Separated Values file as a spreadsheet in a program such as Excel.

But there is a far better way to do this. This method has more steps, but it will save you so much time in the end.

Follow the steps to create a report and see where sources are missing.

I've written many times about the free Family Tree Analyzer program. (Find all articles on the Genealogy Lessons page.) There are so many incredibly useful things to do with it. Now I find it's a great way to identify all your unsourced facts.

Here's how:

1. Open your latest GEDCOM file with Family Tree Analyzer. (You can export a GEDCOM file from your family tree software, or download it from your online tree.)
2. Click the Facts tab and check the boxes for all relationship types.
3. Click the button to Select all Fact Types.
4. Click the right arrow, which will duplicate the list of fact types.
5. In this duplicate list, check the box for any fact types you don't want to include in this report. You should exclude facts that you know don't need a source. For example:
   
   • Child Born. The baby gets a source for their birth date. The parent doesn't need a source for having had the kid.
   • Custom facts. I have a custom Ahnentafel Number fact that doesn't need a source. If you have custom facts, you'll find them in this list in all capital letters.
6. Click the big button that begins with "Show only the selected Facts for Individuals…."

Your report opens in a new window. At the top of that window, choose to export this report as an Excel file (actually a CSV file). Now open the file in your spreadsheet software.

First, sort the spreadsheet by the source column and delete the many, many rows of facts that DO have a source citation.

Next, delete the unnecessary columns to make things easier to see. I deleted all but Surname, Forenames, DateofBirth, TypeOfFact, FactDate, and Location.

Choose to export your report from Family Tree Analyzer to a spreadsheet.

I'm left with an awful lot of rows of unsourced facts. But remember, I said I don't source estimated birth years. I can sort or filter the spreadsheet by the DateofBirth column and delete all the rows with "Abt" (short for About). That brings me down to a very manageable 133 rows of unsourced facts.

Finally, I'll sort the data by Surname so I can make my way through this task list. I'll delete a row once I've added the missing source citation to my family tree.

I know the complete dates from the 1800s fit into the category of "I'm in an excited rush." I have the documents to back up these dates. Now I need to go back and finish my work. I suspect some of the years (not full dates) in the 1900s will be birth years I took from a census sheet. Again, I need to finish my work.

It's nice to have this report as a safety net for days when you aren't on your best behavior. It's as if Family Tree Analyzer is your coach or teacher, reminding you to think about what you're doing. And by all means, show your work!

How to Use the Power of Shared DNA Matches

There is a way to get a good handle on those tree-less DNA matches.

I bought my DNA test from Ancestry DNA 8 years ago. Lately I've explained a handful of ways to figure out your DNA matches. You'll find them in the DNA section of my Genealogy Lessons page.

Today let's look at one of my new favorite features of Ancestry DNA: shared matches.

I've uploaded my raw DNA file to other sites, including GEDmatch, Family Tree DNA, 23 and Me, and My Heritage. But Ancestry gives me the best tools to use.

I imagine I'd get more tools from the other websites if I had a paid membership! I did pay a one-time fee to Family Tree DNA, and I see they do have a "Matches in Common With" feature. Check your testing site for something like what I describe below.

I love the Shared Matches feature on Ancestry. Keep in mind that this is extra important for those DNA matches who haven't attached a usable family tree.

Ancestry lets you add each DNA match to groups you create. Once you do, that match gets one or more colorful dots attached to their listing. I use a green got to signify that I've figured this person out. So I'll scroll down to find a DNA match without a green dot. I want to focus on my mother's side of the family. My father's side has a gazillion matches, all coming from one ancestral town! My mother's side has far less matches.

When your DNA match offers little or no clues, don't forget to look at your shared matches.

My 1st match on my mother's side without a green dot has a last name I know. It starts with a V. This name is from a town tied to my maternal grandmother's family. It's called Pastene, and it's very small.

His tree is as useless as it gets. It has 1 private person. Him! When I click Shared Matches on Ancestry, I see that besides my mother, we share only 4 DNA matches. I recognize 2 of our shared matches as being descendants of that same last name. I know this because I've corresponded with them and explored one of their trees.

Another shared match has my grandmother's maiden name, so I know his roots are also in Pastene. I'll add a note to this match's profile that says he's a V from Pastene.

But I can keep going. I clicked the match with Grandma's maiden name. He also has no family tree, but I can look at his shared matches. This list includes everyone from the previous shared matches list, and several more.

I see one match who I know had a grandmother with my Grandma's maiden name. I see another match whose handle appears to be an abbreviation of that maiden name. Her shared matches support that idea.

One other match has a last name I know from a different, but connected town. You see, my 2nd great grandfather was from Pastene, but he married a girl from nearby Santa Paolina. This match has a name that's prevalent in Santa Paolina to this day.

Following this method, I can add notes to the profiles of unknown matches. The notes can include last names I know and towns. Over time, these notes will help me see how different matches may fit together.

I can continue to click interesting shared matches and view our shared matches. Here's a person with a decent tree of 243 people. On both the mother's and the father's side of this tree, I see last names from Santa Paolina. Lately I've been reviewing my downloaded vital records from Santa Paolina. I'm getting very familiar with the town's names as I change the file name of each document image. For each image, I'm adding the person named on the document and their father's first name.

I know I can find vital records for this DNA match's grandparents and generations before them. This is a match I can figure out!

Make notes and use groups to leave yourself research breadcrumbs.

When I figure them out, and work them into my family tree, I'll have strengthened my ties to our shared DNA matches. More "common names" will appear in our trees.

If your DNA website lets you add categories or notes to your matches, do it. (Do this offline in a spreadsheet, if you must.) Leave yourself these useful breadcrumbs. If you know the general branch a match should fit into, note that. If they have last names you know, notes them.

It's impossible to count our thousands upon thousands of DNA matches. But categorizing many of them, and figuring out those you can, can help you get to the result you want. And that is, fewer empty branches on your family tree.

It's Time to Review Old Genealogy Messages

I've been messaging people on Ancestry.com for many years now. My messages go back at least 3 years before I took a DNA test. Since then, my family tree has exploded with people pieced together from 1,000s of Italian documents.

This week I was paging through my old messages. Some of my answers surprised me! I found myself replying, "Sorry, I don't know that last name," or, "Those records are impossible to find." That's not true anymore.

It was as if my clone had answered these messages. The current me disagreed with the past me so many times.

I realized there are lots of hints in these old conversations. There are names and leads that can expand my family tree. They may break down some brick walls. They deserve a fresh look, don't you think?

Ancestry.com was about to push their new messaging system on me (yuck, but I'll give it time). I emptied and deleted my message folders on their website. (Folders are incompatible with their new system.) I pasted the contents of the old conversations into a Word document.

Using last names as section headings, I pasted conversations about a name into the matching section of the document. Now I can see, for example, a bunch of conversations I had with people about the last name Pilla. (That's my great grandmother's name.)

Take this conversation from 2015. A woman wrote to me about the last names Cecere, Musto, Frusciante, and Lombardo. I didn't know any of those names in 2015, but I know them all now.

She provided a long, detailed history of these names in her family tree. She said they came from Santa Paolina, Avellino, Italy. I knew in 2015 that my 2nd great grandmother was born in Santa Paolina. But not much more.

You're further along in your family tree today. It's time to revisit the hints in those old potential-cousin messages.

It was purely coincidental that she wrote to me. I didn't have Cecere (her mother's maiden name) in my tree, but I had Cece. There's no relationship between the names. Cece comes from another province. But because she mentioned Santa Paolina, I told her, "There may be something between us, but I can't tell what it is."

Today I have tons of vital records from Santa Paolina. They weren't available in 2015, but they're on my computer now. Lately, I've been sorting through the files and getting familiar with the town's last names. Names like Cecere, Musto, Frusciante, and Lombardo.

Now, after 5 years, I can provide this contact with more facts than she knew. I can send her the birth records of her ancestors. I can work out how they fit into my family tree.

Once they're in my family tree, I'll check my contact's details about what became of these people in America. I can use Ancestry to find documents for the family in the U.S.

And I wouldn't know any of this if I didn't revisit those old messages. One down, HUNDREDS to go. I'll start with the last names that are the closest to me.

Do you have old genealogy emails and messages you filed away and forgot about? Pick a few to re-read and see if they make sense to you now. This is why we do genealogy: to find new connections to our past.