*Help! Query to list number of sources per record?

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
stumped
Newbie
Posts: 2
Joined: 22 Jan 2019 23:41
Family Historian: V6

Help! Query to list number of sources per record?

Postby stumped » 22 Jan 2019 23:51

Hello all!

I am having some issues identifying a functionality within Family Historian that allows me to see a list of all records within my family tree that includes the number of sources that are attached to each record.

Essentially I would like to be able to triangulate all of my data, and need to see which records do or do not have 3 or more sources. I have tried a couple of plugins that are available online as well as a search through several topics relating to sourcing, but have yet to find anything that solves this issue. I have also tried to export the data to excel to use its functionalities, but end up with a real mess of data.

The result I am looking for would look something like this or something similar:

Code: Select all

Individual Records   # of Sources    Source #1             Source #2      Source #3
Joe Blow             2               Aunt Jane interview   Census record     

Can anyone help me? I apologize if this has already been covered somewhere else! Please direct me to that thread if this is the case.

Thanks in advance!

User avatar
Jane
Site Admin
Posts: 7554
Joined: 01 Nov 2002 15:00
Family Historian: V6.2
Location: Somerset, England
Contact:

Re: Help! Query to list number of sources per record?

Postby Jane » 23 Jan 2019 07:57

I don't think I have seen a plugin for this, although one could be written, however I am not sure how knowing how many sources you have for an individual helps, most people have wanted to check that all core facts have a source. So if you look in the Knowledge Base > Downloads there are several queries which show the sources or missing sources for information in your database.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."

User avatar
tatewise
Megastar
Posts: 15641
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Help! Query to list number of sources per record?

Postby tatewise » 23 Jan 2019 09:32

Welcome to the FHUG.
I have moved this to the FH General Usage Forum as it is nothing to do with Research into your family history.

It is not entirely clear which Source Citations you are trying to list.
Usually, most facts recorded for an Individual record such as Name, Birth, Census, Marriage, Occupation, Death, etc, will each have one or more Source Citations.
So each Individual record will typically have far more than three Source Citations and mine often have more than a dozen.

What is the purpose of obtaining such a list?

To get a handle on such a list, trying selecting all your Source records in the Records Window and run the Where Used Record Links Plugin.
Then in the Result Set click on the Record Where Used column heading to bring similar records together.
The number of times the same record appears indicates how many Source Citations it has.
You could export that as a CSV and count those repetitions, then sort based on that count.
(BTW: It should be possible to modify the Plugin to perform that count and list Result Set in ascending count order.)

FYI: There are Queries and Plugins that focus on missing key facts and citations (such as Birth, Marriage, Death & Census) which is usually more significant than just a count of arbitrary citations.
See Knowledge Base > Downloads and Links and look through the Queries and under the Genealogy Research section.
For Plugins see Lookup Missing Census Facts and Lookup Missing BMD Records.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

stumped
Newbie
Posts: 2
Joined: 22 Jan 2019 23:41
Family Historian: V6

Re: Help! Query to list number of sources per record?

Postby stumped » 23 Jan 2019 15:58

Thank you Tatewise! I'll have to do a bit of playing with the data, but I think this shows me the capabilities I need.


Return to “General Usage”

Who is online

Users browsing this forum: No registered users and 14 guests