* Count of derived records
-
David Potter
- Megastar
- Posts: 957
- Joined: 22 Jun 2016 15:54
- Family Historian: V7
- Location: United Kingdom
Count of derived records
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
Thank you
BR
David Potter
- tatewise
- Megastar
- Posts: 27087
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Count of derived records
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.
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
-
David Potter
- Megastar
- Posts: 957
- Joined: 22 Jun 2016 15:54
- Family Historian: V7
- Location: United Kingdom
Re: Count of derived records
Hi Mike
Struggling to remember myself where I saw the issue. Let me try to find it again.
David
Struggling to remember myself where I saw the issue. Let me try to find it again.
David
-
David Potter
- Megastar
- Posts: 957
- Joined: 22 Jun 2016 15:54
- Family Historian: V7
- Location: United Kingdom
Re: Count of derived records
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
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
- tatewise
- Megastar
- Posts: 27087
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Count of derived records
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.)
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
-
David Potter
- Megastar
- Posts: 957
- Joined: 22 Jun 2016 15:54
- Family Historian: V7
- Location: United Kingdom
Re: Count of derived records
Hi Mike
Okay - Point taken. many thanks for the reply.
BR
David
Okay - Point taken. many thanks for the reply.
BR
David
- PeterR
- Megastar
- Posts: 1129
- Joined: 10 Jul 2006 16:55
- Family Historian: V7
- Location: Northumberland, UK
Re: Count of derived records
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)
- tatewise
- Megastar
- Posts: 27087
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Count of derived records
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.
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
-
David Potter
- Megastar
- Posts: 957
- Joined: 22 Jun 2016 15:54
- Family Historian: V7
- Location: United Kingdom
Re: Count of derived records
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
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
- tatewise
- Megastar
- Posts: 27087
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Count of derived records
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.
"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
-
David Potter
- Megastar
- Posts: 957
- Joined: 22 Jun 2016 15:54
- Family Historian: V7
- Location: United Kingdom
Re: Count of derived records
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
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