* Count of derived records

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.
Post Reply
avatar
David Potter
Megastar
Posts: 957
Joined: 22 Jun 2016 15:54
Family Historian: V7
Location: United Kingdom

Count of derived records

Post by David Potter » 07 Jul 2016 21:18

Would it be possible to add a count function on various listings, eg, if you opened a Named List the record count is displayed somewhere. This would be a very much welcome general record count field in most if not all generated listings.

Thank you

BR

David Potter

User avatar
tatewise
Megastar
Posts: 27087
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Count of derived records

Post by tatewise » 07 Jul 2016 22:48

Not sure what you mean by 'listings'. Do you mean on screen displays, or reports, or what?

Please be more specific, as most list sizes are available.
e.g.
The Named Lists pane shows number of records in each list in the Items column.
File > File Statistics shows number of records of each type.
The Query Window shows how many Record Rows are listed.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
David Potter
Megastar
Posts: 957
Joined: 22 Jun 2016 15:54
Family Historian: V7
Location: United Kingdom

Re: Count of derived records

Post by David Potter » 14 Jul 2016 08:43

Hi Mike

Struggling to remember myself where I saw the issue. Let me try to find it again.

David

avatar
David Potter
Megastar
Posts: 957
Joined: 22 Jun 2016 15:54
Family Historian: V7
Location: United Kingdom

Re: Count of derived records

Post by David Potter » 18 Jul 2016 20:13

Hi Mike

I finally remembered where this would be useful. It is in the reports from the Tools > Work with Data function. It would be handy if these reports displayed a count of records contained in each 'listing' such as Places, Addresses. ETC. This would be useful when comparing migrated records from another Genealogy program as I did coming from TMG 9.05

BR

David

User avatar
tatewise
Megastar
Posts: 27087
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Count of derived records

Post by tatewise » 18 Jul 2016 22:12

I see what you mean, but on a technical point, those are NOT strictly records, but compiled lists a bit like an index.
They are compilations from the Place field, Address field, Source record Type field, and the values on Attributes: Occupation, Religion, Groups/Castes, and National or Tribal Origin.
It would be a simple task to create a Plugin that gave those item counts, so the functionality is available indirectly, and could be supplied via the FHUG or added to my Show Project Statistics Plugin.

(An exception is Places in FH V6 and the count for those Records is in File Statistics.)
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
David Potter
Megastar
Posts: 957
Joined: 22 Jun 2016 15:54
Family Historian: V7
Location: United Kingdom

Re: Count of derived records

Post by David Potter » 19 Jul 2016 11:07

Hi Mike

Okay - Point taken. many thanks for the reply.

BR

David

User avatar
PeterR
Megastar
Posts: 1129
Joined: 10 Jul 2006 16:55
Family Historian: V7
Location: Northumberland, UK

Re: Count of derived records

Post by PeterR » 19 Jul 2016 13:07

There is an old (March 2012) Plugin Address Summary Report which provides counts of Address field values, with or without the associated Place field value.
Peter Richmond (researching Richmond, Bulman, Martin, Driscoll, Baxter, Hall, Dales, Tyrer)

User avatar
tatewise
Megastar
Posts: 27087
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Count of derived records

Post by tatewise » 19 Jul 2016 13:11

Peter: It is not the count of identical Address field values that is requested, as that is already in the Tools > Work with Data lists.

It is the number of distinct Address values, which your Plugin does supply in the Records in Result Set count bottom right.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
David Potter
Megastar
Posts: 957
Joined: 22 Jun 2016 15:54
Family Historian: V7
Location: United Kingdom

Re: Count of derived records

Post by David Potter » 25 Aug 2016 20:34

Hi Mike

Just picking up on this original request. Here's a good example of where the current design falls down. I go to the records window and select the media tab. It tells me there are X individuals and Y families in the result set. It does not tell me how many Media records are found in the same result set. Now you could argue you just find the last record and that record ID value confirms how many records exist. This I found to be un-reliable as FH drops and does not reuse an ID if for some reason it was deleted. If I want to check this up against the 'physical' folder where the media is actually stored. I have no reliable count!

I think it would be useful to have in addition to the Individuals and Families counts (although I don't see this being useful in this context). I would say a count on the media records could be useful. And a similar argument goes for Sources, Places, etc.

Kind regards

David

User avatar
tatewise
Megastar
Posts: 27087
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Count of derived records

Post by tatewise » 25 Aug 2016 20:54

David, just picking up on my original reply, I said:
"File > File Statistics shows number of records of each type."

BTW: My Show Project Statistics Plugin also gives those counts, plus a lot more.

FYI: "result set" is incorrect terminology in this context.
Here we are talking about Project Records Window lists, that show all records and never a subset.
A Result Set is the result derived from a Query and is often a subset of records.

Student Exercise:-
On any Records Window tab, right-click and choose Columns.
In the Configure Columns window use Save to Query.
Now in the Query Window run that Query and Records in Result Set is given bottom right (all records in this case).
This is a useful way of preserving Records Window customised Columns.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
David Potter
Megastar
Posts: 957
Joined: 22 Jun 2016 15:54
Family Historian: V7
Location: United Kingdom

Re: Count of derived records

Post by David Potter » 26 Aug 2016 07:00

Thanks - Mike

Some useful solutions there. I like the plug-in approach and as you say why mod the core parts of FH when workarounds are available.

Thank you

David

Post Reply