Difference between revisions of "Expand Statistics"

From TNG_Wiki
Jump to: navigation, search
(Sites using this mod)
 
(23 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 
{{TNGmod
 
{{TNGmod
 
| mod_name        = Expand Statistics
 
| mod_name        = Expand Statistics
| mod_summary    = Stats pages for jobs, centuries and veterans
+
| mod_summary    = Stats pages to go into greater depth in analyzing and searching the tng database
 
| mod_validation  =  
 
| mod_validation  =  
| mod_last_update = 6 Apr 2019
+
| mod_last_update = 3 June 2020
| download_link  = for {{Tv120}}[[media:Expand_statistics_5.zip   | Expand Statistics Version 5]]
+
| download_link  = for {{Tv120}}[[media:Expand_statistics_v12.8a.zip   | Expand Statistics Version 8a]]
 
<hr />
 
<hr />
 
| download_stats  =
 
| download_stats  =
Line 11: Line 11:
 
| mod_support    = [http://tng.community/ TNG Community Forums]
 
| mod_support    = [http://tng.community/ TNG Community Forums]
 
| mod_contact    = [http://adupree.com/wp/1120-2]
 
| mod_contact    = [http://adupree.com/wp/1120-2]
| mod_version    =  
+
| mod_version    = 12.0.0.8a
 
| related_mods    = [[Expand_Search]] [[Display_Jobs_Facts]] [[Sosa]] [[Surname_Statistics]]
 
| related_mods    = [[Expand_Search]] [[Display_Jobs_Facts]] [[Sosa]] [[Surname_Statistics]]
 
| use_mod_manager = Yes
 
| use_mod_manager = Yes
 
| manual_install  = No
 
| manual_install  = No
| min_TNG_ver    =  
+
| min_TNG_ver    = 12
 
| max_TNG_ver    = 12
 
| max_TNG_ver    = 12
 
| TNG_file_list  = statistics.php
 
| TNG_file_list  = statistics.php
Line 26: Line 26:
 
==Introduction==
 
==Introduction==
 
Display statistics about your data.
 
Display statistics about your data.
# <b>Overview</b> - A variety of old and new statistics.
+
# <b>Overview</b> - A variety of old and new statistics broken into pages for individuals, families, media and other.
# <b>Surnames</b> - Statistics about surnames. (Thanks to Jeff Robinson for permission to use parts of his mod [[Surnames_Statistics)
+
# <b>Surnames</b> - Statistics about surnames.  
 
# <b>Occupations</b> - Statistics about occupations. (Only shows up if you have [[Display_Jobs_Facts]] installed)
 
# <b>Occupations</b> - Statistics about occupations. (Only shows up if you have [[Display_Jobs_Facts]] installed)
 
# <b>By Century</b> - Statistics about individuals by century. (Can be used with [[Sosa]] )
 
# <b>By Century</b> - Statistics about individuals by century. (Can be used with [[Sosa]] )
# <b>Veterans</b> - Statistics about veterans.  
+
# <b>Veterans</b> - Statistics about veterans (must be configured following one or two systems explained in options).  
 +
# <b>Data Issues</b> - A data validation page. (Must be a logged in user with admin edit priviledges)
  
Has a set of filters--place and surnames. Get statistics for everyone from a place or with a surname. Also adds magnifying glasses next to some statistics to show individuals in the tng search if [[Expand_Search]] is installed. The example shows folks by century in my database in Illinois.<br>
+
'''If you are using [[Expand Statistics]] version 7 or above along with [[Expand Search]], you need to update [[Expand Search]] to version 7 or above<br> '''
 +
 
 +
Expand statistics creates different views and incorporates new statistics for family data. It replaces the built in statistics page with a series of pages following the logic above. It provides the ability to filter this data by specified places and surnames. It adds a magnifying glass next to some statistics to see the specific individuals in the tng search pages if [[Expand_Search]] is installed. The example shows folks by century in my database in California.<br>
 
{|
 
{|
 
|-
 
|-
Line 38: Line 41:
 
|}
 
|}
  
Each of the pages has subpages. For instance, click on the job category and it shows statistics for the jobs within that category. Click on one of the jobs on that page and it takes you to a page to see everyone who has that job. Veterans works in a similar way.  The neat thing is that you can now see all the cooks or kings in your data very easily. <br><br>
+
The screenshots below give examples of pages from the statistics menu.<br> <br>
The screenshots below give examples of the initial pages from the statistics menu (once installed, you just go to the Statistics page as always and the new options will appear.<br> <br>
+
 
The main statistics page also now includes a few extra stats: Average number of children in families, largest family size and average number of identified parents in a family.
+
 
 +
<h2>Overview page</h2>
 +
The Overview page provides all the statistics that come with the tng statistics page and adds a few extra ones:
 +
* Most: occurring surnames, year of most births, places of most births, baptisms, deaths and burials
 +
* Total children who died before age 5
 +
* Average number of children in families, largest family size and average number of identified parents in a family.
 +
The page is reformatted to give four different views: individuals, families, media and other (sources, citations, places and events). In the individuals and families views a search displaying individuals and families in a filtered category is provided if Expand Search mod is installed. In the media and other view a search for media in the filtered category is provided as part of the mod. 
  
<h2>New Statistics page</h2>
+
<h2>Surnames page</h2>
New statistics are underlined in red.
+
Incorporates tables developed in mod [[Surname_Statistics]]. Thanks to Jeff Robinson for permission.
{|
 
|-
 
|[[Image:statsnew.png|550px|center]]
 
|}
 
  
 
<h2>Occupations page</h2>
 
<h2>Occupations page</h2>
Line 64: Line 69:
  
 
<h2>Veterans page</h2>
 
<h2>Veterans page</h2>
Page requires updating the fields you use for veterans in the mod options.
+
Page requires updating the fields you use for veterans in the mod options. The mod works either by identifying veterans with codes in your events or identifying them under one event where their particular service is entered at the front of the field and followed by a comma (or separator of your choice), such as, "World War I, served in Egypt and Montenegro.... "
 
{|
 
{|
 
|-
 
|-
 
|[[Image:StatsA3.png|550px|center]]
 
|[[Image:StatsA3.png|550px|center]]
 +
|}
 +
 +
<h2>Data Issues page</h2>
 +
Only shows up for logged in admins. The page offers data validation on the front end. It is largely built from the Data Validation page in admin. The difference is that it allows data to be filtered, adds search for individuals with no sources, adds an overview page to show what issues exist, slightly revises some of the queries and gives a differently organized table of results.
 +
{|
 +
|-
 +
|[[Image:data_issues.png|550px|center]]
 
|}
 
|}
  
Line 77: Line 89:
 
* A working TNG installation.   
 
* A working TNG installation.   
 
* An installed current version of the [[Mod Manager]].
 
* An installed current version of the [[Mod Manager]].
 +
* Installed mods: [[Expand_Search]] [[Display_Jobs_Facts]] [[Sosa]] [[Surname_Statistics]] enable various functions. The Mod, however, functions also as a standalone.
  
 
==[[Mod Manager - Installing Config Files | Automated Installation]] ==
 
==[[Mod Manager - Installing Config Files | Automated Installation]] ==
  
 
# Download the zip file in the status area in the upper right.
 
# Download the zip file in the status area in the upper right.
# Extract the Expand_statistics_v3.zip to your mod folder.   
+
# Extract the Expandstats_v7.zip to your mod folder.   
 
# Follow the normal automated installation for Mod Manager, as shown in the example [[Mod Manager - Installing Config Files]] .
 
# Follow the normal automated installation for Mod Manager, as shown in the example [[Mod Manager - Installing Config Files]] .
 +
 +
In the Mod Manager you can enable a number of options.  Please be aware of how the following dependencies work:
 +
* <b>Search links</b> - appear as a magnifying glass next to statistics only if you have [[Expand_Search]] installed.
 +
* <b>SOSA Filter</b> - if you have [[sosa]] installed a sosa filter will appear as a checkbox in the filter bar.
 +
* <b>Occupations Page</b> - if you have [[Display_Jobs_Facts]] installed the Occupations page will appear. Otherwise it cannot be enabled.
 +
* <b>Veterans Page</b> - The veterans page requires that you are entering military service as different events (i.e. "World War II"). If you are, you need to collect the event ids for all these events and add them in the mod options.
  
 
==In the event of a problem with your TNG site==
 
==In the event of a problem with your TNG site==
Line 91: Line 110:
  
 
== Changes/versions ==
 
== Changes/versions ==
 +
v8a - Expands filter to more pages, adds in media, source, citations, places searches to show records in these categories, adds option to only display filter to logged in users, speeds unfiltered queries in the overview pages.
 +
v8 - Adds alternative way to check veterans continued to fix coding issues.<br />
 +
v7 - Adds a data validation section - data issues, took out search page changes<br />
 +
v6 - All changes below and corrects for pooled places and improves searches (if Expand Search installed)<br />
 +
v5d - Adds exact surname search to title bar.<br />
 +
V5c - Fixes formatting issues with templates, adds in a few statistics and search links. Thanks particularly to Ron who not only did most of the troubleshooting but helped find the solutions.<br />
 +
V5a/V5b - Adds under 5 year old deaths, fixes All-USA issue, slight reformat to page, fixes to search page links<br />
 
V5 - Adds surnames with permission to incorporate parts of [[Surname_Statistics]]. Fixes All Trees issue. Adds All-USA choice as an option (needs to be chosen on setup).  
 
V5 - Adds surnames with permission to incorporate parts of [[Surname_Statistics]]. Fixes All Trees issue. Adds All-USA choice as an option (needs to be chosen on setup).  
 
V4b - Fixes wrong stats for media files for some people. <br>
 
V4b - Fixes wrong stats for media files for some people. <br>
Line 101: Line 127:
  
 
== Language Customization ==
 
== Language Customization ==
Mod currently works in English and French (Thanks Katryne).  To customize for your language you need to add the following to the cust_text.php file after you translate the parts after the equal signs.
+
Mod currently works in English and French (Thanks Katryne and Ken).  If you want to customize for another language a text file called "Language Strings" is included in the folder for this mod. To customize for your language, translate the words in quotes after the equal signs. Then include in the cust_text.php files for the appropriate languages.
 
 
<pre>
 
// Expand Stats
 
$text['IndOcc'] = "Occupations of Individuals";
 
$text['Jobs'] = "Jobs";
 
$text['totalrec'] = "Total Recorded";
 
$text['jobsmsg'] = "You apparently do not have the mod \"Display Job/Facts\" installed.  This page requires it.";
 
$text['overview'] = "Overview";
 
$text['occupations'] = "Occupations";
 
$text['bycentury'] = "By Century";
 
$text['veterans'] = "Veterans";
 
$text['war'] = "War";
 
$text['numind'] = "Number of Individuals";
 
$text['allindivs'] = "All Individuals";
 
$text['totals'] = "Totals";
 
$text['nobirthdate'] = "No Birth Date";
 
$text['info'] = "Info";
 
$text['avgc'] = "Average Number of Children";
 
$text['avgp'] = "Average Identified Parents";
 
$text['bigfamily'] = "Largest Family";
 
$text['Example'] = "Example";
 
$text['person'] = "Person";
 
$text['nocats'] = "No Category";
 
$text['nomom'] = 'No Mother';
 
$text['nodad'] = "No Father";
 
$text['citations'] = "Citations";
 
$text['mostbirths'] = "Most births in";
 
$text['other'] = "Other";
 
$text['toplocals'] = "Top 30 places:";
 
$text['marksosa'] = "Marked as Sosa";
 
$text['moretotals'] = "More Totals";
 
$text['allplaces'] = "All Places";
 
$text['bydecade'] = "By Decade";
 
$text['ESfilter'] = "filter";
 
$text['averagelifespans'] = "Average Lifespans";
 
$text['lifespan in Years'] = "Lifespan in Years";
 
$text['plusminus50'] = "Plus or minus 50 years";
 
$text['searchdisclaim'] = "Searches using the provided search button (magnifying glass) provide a <b> restricted set of records </b>using the search function.<br><br> The numbers here include births, baptisms, deaths and burials in the decade or century - hence they will be significantly higher than the search returns.";
 
$text['byperiod'] =  "By Period";
 
$text['births'] = "Of Birth";
 
$text['deaths'] = "Of Death";
 
$text['insufficient'] = "Insufficient Dates";
 
$text['filterby'] = "Filter By";
 
$text['surname'] = "Surname";
 
$text['allsurnames'] = "All Surnames";
 
$text['searchdisclaim'] = "Due to how places are recorded, this number can be slightly lower than the search page";
 
$text["averagemarage"] = "Avg. Age at 1st Marriage";
 
$text["averagemarage"] = "Avg. Age at 1st Marriage";
 
$text['Earliest_Birth'] = "Earliest Birth";
 
$text['Latest_Birth'] = "Latest Birth";
 
$text['notavailable'] = "N/A";
 
// End Expand Stats
 
</pre>
 
  
 
== Sites using this mod ==
 
== Sites using this mod ==
Line 172: Line 145:
 
| [[User:mkoche|A.S. DuPree]]
 
| [[User:mkoche|A.S. DuPree]]
 
| Mod Developer
 
| Mod Developer
| 12.0.0.5
+
| 12.0.0.8a
 
| 12.0.3
 
| 12.0.3
 
| English
 
| English
Line 197: Line 170:
 
| 12.1
 
| 12.1
 
| English
 
| English
 +
|-
 +
| [http://racine-ad.fr/TNG/index.php Racine d'Alsace]
 +
| [[User:Louis42|J-Louis Valory]]
 +
| Private - T17 customized
 +
| 12.0.0.8a
 +
| 12.3
 +
| FR
 +
|-
 +
| [https://www.royandboucher.com/tng/index.php Our Roy and Boucher Family]
 +
| [[User:KenRoy|Ken Roy]]
 +
| Currently on TNG 12.3 test site only.  Thanks for the alternate Veterans approach
 +
| 12.0.0.8
 +
| 12.3
 +
| EN, FR
 +
|-
 +
|}
 
[[Category:Mods for TNG v12]]
 
[[Category:Mods for TNG v12]]
 
[[Category:statistics.php mods]]
 
[[Category:statistics.php mods]]

Latest revision as of 09:39, 4 June 2020

Expand Statistics
Summary Stats pages to go into greater depth in analyzing and searching the tng database
Validation
Mod Updated 3 June 2020
Download link for
TNG 12.0

Expand Statistics Version 8a


Download stats
Author(s) A. S. DuPree
Homepage Expand_Statistics (this page)
Mod Support TNG Community Forums
Contact Developer [1]
Latest Mod 12.0.0.8a
Min TNG V 12
Max TNG V 12
Files modified
statistics.php
Related Mods
Notes
This expands the tng statistics page


Introduction

Display statistics about your data.

  1. Overview - A variety of old and new statistics broken into pages for individuals, families, media and other.
  2. Surnames - Statistics about surnames.
  3. Occupations - Statistics about occupations. (Only shows up if you have Display_Jobs_Facts installed)
  4. By Century - Statistics about individuals by century. (Can be used with Sosa )
  5. Veterans - Statistics about veterans (must be configured following one or two systems explained in options).
  6. Data Issues - A data validation page. (Must be a logged in user with admin edit priviledges)

If you are using Expand Statistics version 7 or above along with Expand Search, you need to update Expand Search to version 7 or above

Expand statistics creates different views and incorporates new statistics for family data. It replaces the built in statistics page with a series of pages following the logic above. It provides the ability to filter this data by specified places and surnames. It adds a magnifying glass next to some statistics to see the specific individuals in the tng search pages if Expand_Search is installed. The example shows folks by century in my database in California.

Screen Shot 2019-07-20 at 9.50.26 PM.png

The screenshots below give examples of pages from the statistics menu.


Overview page

The Overview page provides all the statistics that come with the tng statistics page and adds a few extra ones:

  • Most: occurring surnames, year of most births, places of most births, baptisms, deaths and burials
  • Total children who died before age 5
  • Average number of children in families, largest family size and average number of identified parents in a family.

The page is reformatted to give four different views: individuals, families, media and other (sources, citations, places and events). In the individuals and families views a search displaying individuals and families in a filtered category is provided if Expand Search mod is installed. In the media and other view a search for media in the filtered category is provided as part of the mod.

Surnames page

Incorporates tables developed in mod Surname_Statistics. Thanks to Jeff Robinson for permission.

Occupations page

Page shows up if you have Display_Jobs_Facts mod installed.

Stats1.png

By Century page

Page gives data by century or decades. Includes stats on age at first marriage and lifespans.

Stats2.png

Veterans page

Page requires updating the fields you use for veterans in the mod options. The mod works either by identifying veterans with codes in your events or identifying them under one event where their particular service is entered at the front of the field and followed by a comma (or separator of your choice), such as, "World War I, served in Egypt and Montenegro.... "

StatsA3.png

Data Issues page

Only shows up for logged in admins. The page offers data validation on the front end. It is largely built from the Data Validation page in admin. The difference is that it allows data to be filtered, adds search for individuals with no sources, adds an overview page to show what issues exist, slightly revises some of the queries and gives a differently organized table of results.

Data issues.png

Developer

This mod was developed by A.S. DuPree (a novice, happy for any help on improving it)

Requirements

Automated Installation

  1. Download the zip file in the status area in the upper right.
  2. Extract the Expandstats_v7.zip to your mod folder.
  3. Follow the normal automated installation for Mod Manager, as shown in the example Mod Manager - Installing Config Files .

In the Mod Manager you can enable a number of options. Please be aware of how the following dependencies work:

  • Search links - appear as a magnifying glass next to statistics only if you have Expand_Search installed.
  • SOSA Filter - if you have sosa installed a sosa filter will appear as a checkbox in the filter bar.
  • Occupations Page - if you have Display_Jobs_Facts installed the Occupations page will appear. Otherwise it cannot be enabled.
  • Veterans Page - The veterans page requires that you are entering military service as different events (i.e. "World War II"). If you are, you need to collect the event ids for all these events and add them in the mod options.

In the event of a problem with your TNG site

  1. Try using the Mod Manager to Remove the mod

Customizations in Mod Manager

  1. Choose pages to show

Changes/versions

v8a - Expands filter to more pages, adds in media, source, citations, places searches to show records in these categories, adds option to only display filter to logged in users, speeds unfiltered queries in the overview pages. v8 - Adds alternative way to check veterans continued to fix coding issues.
v7 - Adds a data validation section - data issues, took out search page changes
v6 - All changes below and corrects for pooled places and improves searches (if Expand Search installed)
v5d - Adds exact surname search to title bar.
V5c - Fixes formatting issues with templates, adds in a few statistics and search links. Thanks particularly to Ron who not only did most of the troubleshooting but helped find the solutions.
V5a/V5b - Adds under 5 year old deaths, fixes All-USA issue, slight reformat to page, fixes to search page links
V5 - Adds surnames with permission to incorporate parts of Surname_Statistics. Fixes All Trees issue. Adds All-USA choice as an option (needs to be chosen on setup). V4b - Fixes wrong stats for media files for some people.
V4a - Adds surnames into the filters, search magnifying glasses next to some of the states and fixes some incorrect stats V4 - Added lifespan by century or decade, fixed some query issues.
V3 - Added filters for places and Sosa (if installed)
V2 - Added tree switching
V1b - Fixed a missing $ in cust_text file.
V1a - Adds new stats to the main stats page, some refinements on the other pages.

Language Customization

Mod currently works in English and French (Thanks Katryne and Ken). If you want to customize for another language a text file called "Language Strings" is included in the folder for this mod. To customize for your language, translate the words in quotes after the equal signs. Then include in the cust_text.php files for the appropriate languages.

Sites using this mod

If you download and install this mod, please add your TNG site to the table below:

URL User Note Mod-Version TNG-Version User-language
Adupree.com A.S. DuPree Mod Developer 12.0.0.8a 12.0.3 English
vanheerden.net Emile Administrator 12.0.0.4a 12.1 English
Roots & Relatives Remembered Ron Krzmarzick Public & Private See Here See Here EN,DE,CS,ES
Journeys in Genealogy Patrick Thrush Public WordPress/TNG bundle 12.0.0.4 12.1 English
Racine d'Alsace J-Louis Valory Private - T17 customized 12.0.0.8a 12.3 FR
Our Roy and Boucher Family Ken Roy Currently on TNG 12.3 test site only. Thanks for the alternate Veterans approach 12.0.0.8 12.3 EN, FR