Difference between revisions of "Census Plus International"

From TNG_Wiki
Jump to navigation Jump to search
(new DOM source version in UK census)
 
(186 intermediate revisions by 26 users not shown)
Line 1: Line 1:
{{TNGver
+
{{restricted}}{{TNGver
| ver = 10.1.0  
+
| ver = 14
|notes= The new versions of the mod are only supported on TNG 10.1 and above.  '''Important''': When reporting problems on the TNG Community Forum, please attach the DOM Source file that you are importing which is causing errors and provide the URL to Ancestry for the specific census entry.<br />
+
|notes= V14.0.0.13a and v13.0.0.13 include changes to support the 1950 US Census and the 1921 UK Census by [[User:Bhemph|Brent Hemphill]] and [[User:KenRoy|Ken Roy]]. 
The v10.1.0.4 and v11.0.0.4 versions of the mod use a new Census Plus Label Dictionary.  You must '''Create CPI Label table''' after installing the mod before you can use the Import from Ancestry.  If you import a census and it wants to update the CP Label table, you can do so and then import the census, but please report this as a problem on the TNG Community Forum and attach the DOM source that contains a new column label.
+
'''<span style="color:red">The import from Ancestry is once again no longer working, you will need to use the '''Add''' tab to manually add the census transcript</span>'''<br>
}}            
+
'''Important''':If you download, install, and use this mod, '''please update''' the [[Census_Plus_International#Sites_using_this_mod|Sites using this mod]] table
{{TNGmod
+
<!-- The new versions of the mod are only supported on TNG 12 and above.  '''Important''': When reporting problems on the TNG Community Forum, please attach the DOM Source file that you are importing which is causing errors and provide the URL to Ancestry for the specific census entry.<br />
 +
<span style="color:red">'''Note that recently Ancestry is generating a new URL format that does not generate the DOM source needed for import. Ancestry also shows some index with no column headings, so if the Index does not have column headings when you are generating the DOM source or the DOM source URL is in the format ''/interactive/8058/4409456_00869'', you may have no option other than using the '''Add''' tab to manually add the census transcript'''</span>. -->
 +
}}{{V12_cust_text}}{{TNGmod
 
| mod_name        = Census Plus International
 
| mod_name        = Census Plus International
 
| mod_summary    = Adds international census record data for Households on individual Info page
 
| mod_summary    = Adds international census record data for Households on individual Info page
 
| mod_validation  =
 
| mod_validation  =
| download_link  = Import from Ancestry supported<br />for {{Tv1102}} [https://www.royandboucher.com/ccount/click.php?id=403 censusplus_v11.0.2.5b.zip]<hr />for {{Tv110}} [https://www.royandboucher.com/ccount/click.php?id=404 censusplus_v11.0.0.5b.zip]<hr />for {{Tv1010}} [https://www.royandboucher.com/ccount/click.php?id=405 censusplus_v10.1.0.5b.zip]<hr />Import from Ancestry NOT supported<br />for {{Tv100}}[https://www.royandboucher.com/ccount/click.php?id=340 censusplus_v10.0.0.2l.zip]<br/>[https://www.royandboucher.com/ccount/click.php?id=153 French Language Files]<hr />for {{Tv91}}[https://www.royandboucher.com/ccount/click.php?id=183 censusplus_v9.1.0.4e.zip]<hr />[https://www.royandboucher.com/ccount/click.php?id=141 censusplus_v9.1.0.4b_French.zip]
+
| mod_last_update = 7 Sep 2023
 +
| download_link  = For {{Tv1401}}[https://www.royandboucher.com/ccount/click.php?id=724&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v14.0.1.13c.zip]<br />[https://www.royandboucher.com/ccount/click.php?id=725&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v14.0.1.13c_lang.zip]<hr />For {{Tv140}}[https://www.royandboucher.com/ccount/click.php?id=693&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v14.0.0.13a.zip]<br />[https://www.royandboucher.com/ccount/click.php?id=721&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v14.0.0.13b_lang.zip]<hr />For {{Tv130}}[https://www.royandboucher.com/ccount/click.php?id=660&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v13.0.0.13.zip]<br />[https://www.royandboucher.com/ccount/click.php?id=662&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v13.0.0.13_lang.zip]<hr />
 +
for PHP 8{{Tv130}}[https://www.royandboucher.com/ccount/click.php?id=644&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v13.0.0.12a.zip]<br />[https://www.royandboucher.com/ccount/click.php?id=639&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v13.0.0.12_lang.zip]<hr />Import from Ancestry No longer works<br />for {{Tv120}} [https://www.royandboucher.com/ccount/click.php?id=501&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v12.0.0.10a.zip]<br />[https://www.royandboucher.com/ccount/click.php?id=502&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v12.0.0.10a_lang.zip]<hr />
 +
<div class="mw-collapsible mw-collapsible-content" id="mw-customcollapsible-sb1"><span class="mw-customtoggle-sb1 mw-customtoggle-sbdiv" style='text-decoration:underline;float:right;'>&#91;Show older versions&#93;</span></div><br />
 +
<div class='mw-collapsible mw-collapsible-content mw-collapsed' id="mw-customcollapsible-sbdiv">
 +
<div style='overflow:none'>for {{Tv1102}} [https://www.royandboucher.com/ccount/click.php?id=429&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v11.0.2.6c.zip]<hr /></div>
 +
<div style='overflow:none'>for {{Tv110}} [https://www.royandboucher.com/ccount/click.php?id=430&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v11.0.0.6c.zip]<hr /></div>
 +
<div style='overflow:none'>for {{Tv1010}} [https://www.royandboucher.com/ccount/click.php?id=431&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v10.1.0.6c.zip]<hr /></div>
 +
Import from Ancestry NOT supported<br />
 +
<div style='overflow:none'>for {{Tv100}}[https://www.royandboucher.com/ccount/click.php?id=340&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v10.0.0.2l.zip]<br/></div>
 +
<div style='overflow:none'>for {{Tv1102}}{{Tv110}}{{Tv1010}}[https://www.royandboucher.com/ccount/click.php?id=420&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} v10.1.0.6 Languages]<br /></div>
 +
<div style='overflow:none'>[https://www.royandboucher.com/ccount/click.php?id=153&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} French Language Files]<hr /></div>
 +
<div style='overflow:none'>for {{Tv91}}[https://www.royandboucher.com/ccount/click.php?id=183&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v9.1.0.4e.zip]<hr /></div>
 +
<div style='overflow:none'>[https://www.royandboucher.com/ccount/click.php?id=141&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v9.1.0.4b_French.zip]
 +
<span class="mw-customtoggle-sb1 mw-customtoggle-sbdiv" style='text-decoration:underline;float:right;'>&#91;Hide old versions&#93;</span><br />
 +
</div></div>
 
| download_stats  = [https://www.royandboucher.com/ccount/index.php?action=stats&groupid=8  View download statistics]
 
| download_stats  = [https://www.royandboucher.com/ccount/index.php?action=stats&groupid=8  View download statistics]
 
| mod_author      = Janice Nation, Jeff Robison, and Ken Roy
 
| mod_author      = Janice Nation, Jeff Robison, and Ken Roy
Line 14: Line 31:
 
| mod_support    = [https://tng.community/index.php?/forums/ TNG Forums]
 
| mod_support    = [https://tng.community/index.php?/forums/ TNG Forums]
 
| mod_contact    =  
 
| mod_contact    =  
| mod_version    = 11.0.2.5b for TNG 11.0.2<br />11.0.0.5b for TNG 11<br />10.1.0.5b for TNG 10.1 and later<br />10.0.0.2l for TNG V10<br />9.1.0.4e for TNG v9.1 and above
+
| mod_version    = 14.0.1.13c for TNG 14.0.1+<br />14.0.0.13a for TNG 14+<br />13.0.0.13 for 1950 US / 1921 UK census<br />13.0.0.12a for PHP 8<br />13.0.4.11 for TNG 13.0.4+<br />13.0.0.11 for TNG 13+<br />12.0.0.10a for TNG 12+<br />11.0.2.6c for TNG 11.0.2+<br />11.0.0.6c for TNG 11<br />10.1.0.6c for TNG 10.1+
| min_TNG_ver    = 9.1.0
+
| min_TNG_ver    = 10.1.0
| max_TNG_ver    = 11+
+
| max_TNG_ver    = 14+
 
| TNG_file_list  = See [[Census_Plus_International#TNG_Modules_Impacted|TNG Modules Impacted]]
 
| TNG_file_list  = See [[Census_Plus_International#TNG_Modules_Impacted|TNG Modules Impacted]]
 
|  related_mods    = [[Show/Hide Events]] can hide the events<br />[[Media - Census Plus International]] displays the Census Plus Transcript for user census Media collections<br />[[Family Edit Links Mod]] to quickly find the personID of family members<br />[[Person Custom Events]] relocates custom events  below the Event Map.
 
|  related_mods    = [[Show/Hide Events]] can hide the events<br />[[Media - Census Plus International]] displays the Census Plus Transcript for user census Media collections<br />[[Family Edit Links Mod]] to quickly find the personID of family members<br />[[Person Custom Events]] relocates custom events  below the Event Map.
 
 
| notes          = This mod is an alternative to the [[Census Feature]] mod so you need to choose which one you install.  They cannot both be on the system at the same time, since they both modify the tngtabs1.css files
 
| notes          = This mod is an alternative to the [[Census Feature]] mod so you need to choose which one you install.  They cannot both be on the system at the same time, since they both modify the tngtabs1.css files
}}
+
}}{| style="margin-right:0.5 em;" align="right"
 +
| __TOC__
 +
|}
 +
<!-- v12.0.0.10 Languages file = censusplus_v12.0.0.10_lang.zip -->
 +
<!-- v10.1.0.6 Languages file = Censusplus v10.1.0.6 languages.zip -->
 
<!-- French language file = censusplus_v10.1.0.3_french.zip -->
 
<!-- French language file = censusplus_v10.1.0.3_french.zip -->
 
<!-- French language file = censusplus_v10.0.0.0_french.zip -->
 
<!-- French language file = censusplus_v10.0.0.0_french.zip -->
 
<!-- French language file = censusplus_v9.1.0.0_french.zip -->
 
<!-- French language file = censusplus_v9.1.0.0_french.zip -->
{|align=right
 
|__TOC__
 
|}
 
 
 
== Purpose of the mod ==
 
== Purpose of the mod ==
  
Line 53: Line 69:
 
== Developer ==
 
== Developer ==
  
This mod was developed by [[User:Ozigirl|Janice Nation]], [[User:Jefr58|Jeff Robison]], and [[User:Ken Roy|Ken Roy]]  
+
This mod was developed by [[User:Ozigirl|Janice Nation]], [[User:Jefr58|Jeff Robison]], [[User:Ken Roy|Ken Roy]], and [[User:Bhemph|Brent Hemphill]]
 +
 
 +
V9.0.0.2 enhancements made by Janice and Ken to the original [[Census Feature]] mod by [[User:Gleehan|Gerald 'Jerry' Leehan]] were used along with parts of Jerry's original mod.  Add capability provided by [[User:Jefr58|Jeff Robison]]
 +
 
 +
V12.0.0.10 Attempted fix to Import, Secondary Check Census Link provided by [[User:Bhemph|Brent Hemphill]]
  
V9.0.0.2 enhancements made by Janice and Ken to the original [[Census Feature]] mod by [[User:Gleehan|Gerald 'Jerry' Leehan]] were used along with parts of Jerry's original mod.
+
V10.1.0.6c/V11.0.0.6c/V11.0.2.6c Fix to Import, Secondary Check Census Link created with the help of Mark Wonson
  
 
V10.1.0.4/V11.0.0.4 enhancements made by Janice Nation to use a dictionary approach to process the Ancestry DOM source.
 
V10.1.0.4/V11.0.0.4 enhancements made by Janice Nation to use a dictionary approach to process the Ancestry DOM source.
Line 64: Line 84:
 
! V9103-V9104
 
! V9103-V9104
 
! V10104-V11004
 
! V10104-V11004
|-
+
! V130013 beta
 +
|- valign="top"
 
|
 
|
 
* Bryan Larson
 
* Bryan Larson
Line 73: Line 94:
 
* Roger Mitchell
 
* Roger Mitchell
 
|
 
|
 
 
* Bryan Larson  
 
* Bryan Larson  
 
* Dave Foster  
 
* Dave Foster  
Line 85: Line 105:
 
* Mark Kosinski  
 
* Mark Kosinski  
 
* Bryan Larson
 
* Bryan Larson
 +
|
 +
* Brent Hemphill
 +
* Mark Kosinski
 +
* Regis Carr
 +
* Marc Irish
 +
* Svein Erik Bjartheim
 
|}
 
|}
  
 
== Requirements ==
 
== Requirements ==
 +
{{Caution
 +
|notes=If you also use the '''[[Alternate spellings]]''' mod with v13.0.1.13a of the Census Plus International mod, you must update to 13.0.1.2a version of the '''[[Alternate spellings]]''' mod to eliminate the Not Unique error in personlib.php that prevents the [[Census Plus International]] mod from installing<br />If you also use the '''[[Create Site Map Mod]]''' in TNG v14, you must update to 14.0.0.13a version of the [[Census Plus International]] mod to resolve the conflict in the Post-Import Utilities
 +
}}
 +
{{Doc-important | The Census Plus tables must be created in your TNG database and not your WP database
 +
}}
 +
{{TNG 12.0|and after}}
 +
* the v13.0.0.11 and v12.0.0.10 and later versions of the mod are the only versions that might support MySQL 8
 +
: previous versions of the mod do not support MySQL 8
 
{{TNG 10.1.0|and after}}
 
{{TNG 10.1.0|and after}}
 
* the latest version of the mod uses MySQLi, therefore it is only available for TNG 10.1 and above
 
* the latest version of the mod uses MySQLi, therefore it is only available for TNG 10.1 and above
Line 93: Line 127:
 
{{TNG 9.1.0|and after}}
 
{{TNG 9.1.0|and after}}
 
* this mod requires jQuery, therefore it is only available for TNG 9.1 and above
 
* this mod requires jQuery, therefore it is only available for TNG 9.1 and above
 +
* this mod requires that the DOM extension to PHP be installed
 
* A working TNG installation.
 
* A working TNG installation.
 
* A backup of all affected files (see the list in the summary in the upper right corner of the page)
 
* A backup of all affected files (see the list in the summary in the upper right corner of the page)
* An installed current version of the [[Mod Manager]] (is already included in TNG v9)
+
* Updated versions of your cust_text.php file (see infobox at beginning of this article on how to update your cust_text.php files to the new [[Mod Guidelines]] using the Mod Manager
 
* All '''templates/templateN''' folders be on your site
 
* All '''templates/templateN''' folders be on your site
 
* Both '''English''' and '''English-UTF8''' folders be on your site
 
* Both '''English''' and '''English-UTF8''' folders be on your site
Line 118: Line 153:
 
# Note - if you're using the tng.php  WordPress-TNG Plugin, you might need to '''"Update the TNG  Variables"''' in the WordPress Admin pane for the TNG Plugin to get this  to work correctly.
 
# Note - if you're using the tng.php  WordPress-TNG Plugin, you might need to '''"Update the TNG  Variables"''' in the WordPress Admin pane for the TNG Plugin to get this  to work correctly.
 
# Note - if you're using a different language than English for TNG Admin, you will need to copy the '''cp_text.php''' file from the languages/English or English-UTF8 folder to your language folder after installing the mod, before the buttons in the Mod Manager for the Census Plus International mod will work.
 
# Note - if you're using a different language than English for TNG Admin, you will need to copy the '''cp_text.php''' file from the languages/English or English-UTF8 folder to your language folder after installing the mod, before the buttons in the Mod Manager for the Census Plus International mod will work.
 
+
#: The censusplus_v12.0.0.10 and later provides a _lang.zip for the Danish-UTF8, French, French-UTF8, German-UTF8, and Norwegian-UTF8 cp_text.php files
  
 
=== First Time Post Install Actions ===
 
=== First Time Post Install Actions ===
 
# Click the '''Create CPI Tables''' button shown  on  the Mod Manager screen to '''add''' the census plus tables if they do not exist.  
 
# Click the '''Create CPI Tables''' button shown  on  the Mod Manager screen to '''add''' the census plus tables if they do not exist.  
# Click the '''Create CPI Indices''' button shown on the Mod Manager screen to create the census plus table indices.
+
# Click the '''Create CPI INDEXes''' button shown on the Mod Manager screen to create the census plus table indices.
 
# Click the '''Create Folders''' button on the Mod Manager screen to '''create''' the '''census'''  and '''transcriptsource''' folders if they do not already exist.
 
# Click the '''Create Folders''' button on the Mod Manager screen to '''create''' the '''census'''  and '''transcriptsource''' folders if they do not already exist.
  
=== Upgrading ===
+
=== Upgrading to v14.0.1.13a ===
 +
 
 +
If upgrading from v13.0.0.13, v14.0.0.13, or v14.0.1.13, no post install action.
 +
 
 +
=== upgrading from v13.0.0.12a or earlier ===
  
==== To 10.0.0.4/11.0.0.4 versions ====
+
If you were previously using the Census Plus International mod
  
If upgrading to 10.0.0.4/11.0.0.4, 10.0.0.4a/11.0.0.4a, or to 10.0.0.4b/11.0.0.4b
+
* Install the Census Plus International mod
 +
* in the Mod Manager description section
 +
** click the '''Fix CP Table Indexes''' button
 +
** click the '''Check CP Base Table''' button
 +
** If Check CP Base Table indicates that the censusurl must be updated, then click the button to '''Update CensusURL'''
 +
** If Check CP Base Table indicates that the US Veteran Series must be updated, then click the button to '''Update US Veterans Series'''
 +
** If Check CP Base Table indicates that the cp_base datebase must be updated, then click the button to '''Update CP Base Table'''
 +
** click the '''Verify the CP Base Table Updates''' button
 +
 
 +
<div class="mw-collapsible mw-collapsible-content" id="mw-customcollapsible-sb2"><span class="mw-customtoggle-sb1 mw-customtoggle-sbdiv" style='text-decoration:underline;float:right;'>&#91;Show older upgrade instructions&#93;</span></div><br />
 +
<div class='mw-collapsible mw-collapsible-content mw-collapsed' id="mw-customcollapsible-sbdiv">
 +
 
 +
=== Upgrading to v12.0.0.11 ===
 +
==== from any .4/.5/.6/.7/.8/.9  ====
 +
 
 +
If upgrading to 12.0.0.10 versions from
 +
* any 12.0.0.9 versions
 +
* any 12.0.0.8 versions
 +
* any 12.0.0.7 versions
 +
* any 10.1.0.6, 11.0.0.6, or 11.0.2.6 versions
 +
* any 10.1.0.4, 11.0.0.4, or 11.0.2.4 or
 +
* any 10.1.0.5, 11.0.0.5, or 11.0.2.5 versions,  
 +
you need to
 +
# Backup your Census Plus Tables
 +
# Uninstall the current Census Plus International mod but do NOT drop the tables
 +
# Delete the previous version of the Census Plus International mod. You can delete previous versions of the censusplus folder
 +
# FTP the extracted .cfg file and the censusplus_v120010 folder and all its contents to your TNG mods folder (or extract on site)
 +
# Install the new Census Plus International version of the mod
 +
# Update the CPI Label table
 +
# Update the CPI Veteran table
 +
 
 +
==== from other versions ====
 +
 
 +
If upgrading from versions prior to any of the 10.1.0.4 or .5, 11.0.0.4 or 5, or to 11.0.2.5 versions
  
 
# Backup your Census Plus Tables
 
# Backup your Census Plus Tables
Line 142: Line 214:
 
:: If already created, clicking this button will return a Cannot execute query
 
:: If already created, clicking this button will return a Cannot execute query
 
::(#1061 - Duplicate key name 'BaseID' if you run it in phpMyAdmin)
 
::(#1061 - Duplicate key name 'BaseID' if you run it in phpMyAdmin)
 +
# Update the CPI Veteran table
  
 
==== To previous versions ====
 
==== To previous versions ====
Line 181: Line 254:
 
* TNG  release upgrades: It is not necessary to remove (uninstall) the mod  prior to installing the TNG upgrade.  You will likely need to do a  Clean  up after the upgrade and then re-install the mod.
 
* TNG  release upgrades: It is not necessary to remove (uninstall) the mod  prior to installing the TNG upgrade.  You will likely need to do a  Clean  up after the upgrade and then re-install the mod.
 
</div>
 
</div>
 +
 +
<span class="mw-customtoggle-sb2 mw-customtoggle-sbdiv" style='text-decoration:underline;float:right;'>&#91;Hide old upgrades&#93;</span><br />
 +
</div></div>
  
 
=== Previous Census Feature users ===
 
=== Previous Census Feature users ===
Line 228: Line 304:
 
The following custom text entries need to be created in your language, if you do not use English for TNG Admin
 
The following custom text entries need to be created in your language, if you do not use English for TNG Admin
  
<syntaxhighlight lang="php" enclose="div">
+
<syntaxhighlight lang="php" >
 
// Added for TNG Admin by the Census Plus International mod
 
// Added for TNG Admin by the Census Plus International mod
 
$admtext['cenplus'] = 'Census Plus International';
 
$admtext['cenplus'] = 'Census Plus International';
Line 251: Line 327:
  
 
Likewise if you do not use English for TNG Admin, you need to copy the English/cp_text.php file to your language folder and translate as appropriate.
 
Likewise if you do not use English for TNG Admin, you need to copy the English/cp_text.php file to your language folder and translate as appropriate.
 +
 +
The [https://www.royandboucher.com/ccount/click.php?id=496&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} censusplus_v12.0.0.10_lang.zip] mod can be used to add the Danish-UTF8, French, French-UTF8, German-UTF8, and Norwegian-UTF8 cp_text.php language files
  
 
Only the section of cp_text.php marked as '''Text that should be translated for public side of Census Plus International''' needs to be translated if you use English for your TNG Admin
 
Only the section of cp_text.php marked as '''Text that should be translated for public side of Census Plus International''' needs to be translated if you use English for your TNG Admin
Line 283: Line 361:
  
 
== Known Issues ==
 
== Known Issues ==
 +
* Ancestry Import no longer works in v14.0.0.13 and v14.0.1.313a versions of the mod
 +
* Ancestry DOM source of the index might not contain any column labels
 +
*: use the Add tab and manually add the census transcript for this census
 
* Ancestry Import no longer works in v11.0.0.0 and v10.0.0.3 versions of the mod
 
* Ancestry Import no longer works in v11.0.0.0 and v10.0.0.3 versions of the mod
 
*: upgrade to v11.0.2.5, v11.0.0.5, or v10.1.0.5 of the mod
 
*: upgrade to v11.0.2.5, v11.0.0.5, or v10.1.0.5 of the mod
Line 288: Line 369:
 
* Template 5 width in some cases, like the 1830 and 1840  transcripts  with household summary counts will generated table entries  that exceed  the page content width
 
* Template 5 width in some cases, like the 1830 and 1840  transcripts  with household summary counts will generated table entries  that exceed  the page content width
 
:  <span style="color: red">You will need to increase the width for maintable class to something like 1100 px</span>
 
:  <span style="color: red">You will need to increase the width for maintable class to something like 1100 px</span>
 +
 +
* Template 16 width needs to be increased to eliminate overflow
 +
:  <span style="color: red">You will need to increase the width for #tpage class to something like width: 85%;</span> to resolve the overflow on the getperson.php page
 +
:  <span style="color: red">You may need to increase the width for #tpage class to something like width: 95%;</span> to resolve the overflow on the cpdisplay.php page
  
 
* Display on iPad or tablets where the screen width is 1024 will cause the Census Plus transcript display on the Individual (getperson.php) page to exceed the page boundary
 
* Display on iPad or tablets where the screen width is 1024 will cause the Census Plus transcript display on the Individual (getperson.php) page to exceed the page boundary
Line 293: Line 378:
 
* Census Transcript only displays heading line and no data lines.
 
* Census Transcript only displays heading line and no data lines.
 
: Select the Transcript link, and then click on Go to Update All button and update the location.  If the location looks OK the just Save the Update to update the location in both the CP Base and Data records.
 
: Select the Transcript link, and then click on Go to Update All button and update the location.  If the location looks OK the just Save the Update to update the location in both the CP Base and Data records.
 +
 +
* CP Veteran table uses '''rank''' as a column name which is a reserved word in MySQL 8
 +
: Versions prior to v12.0.0.10 will not install or work with MySQL 8
  
 
== Revision History ==
 
== Revision History ==
Line 301: Line 389:
 
! Date
 
! Date
 
! Contents
 
! Contents
 +
|- valign="top"
 +
| 14.0.1.13c
 +
| 18 Sep 2023
 +
| Updated to eliminate PHP Notice and keep mod numbers in sync with change required to Media-Census Plus International to eliminate conflict with Hide private and living mod
 +
|- valign="top"
 +
| 14.0.1.13b
 +
| 6 Jul 2023
 +
| Updated for TNG v14.0.1 thanks to Michael T Jones to
 +
* fix import from Ancestry
 +
* fix issue with link to Ancestry image
 +
|- valign="top"
 +
| 14.0.1.13a
 +
| 19 April 2023
 +
| Updated for TNG v14.0.1 to
 +
* fix issue where multiple cp_base records were created but not used when using Add tab
 +
* fix issue with Delete having an empty transcriptID
 +
* fix transcript display to show fields that contain no data
 +
|- valign="top"
 +
| 14.0.1.13
 +
| 20 February 2023
 +
| Updated for TNG v14.0.1 to
 +
* removed $flags['tabs'] = $tngconfig['tabs'] which is obsolete in TNG 14.0.1
 +
* fix Add Image dialog
 +
* fix micro_cpinclude to display No Image if
 +
** transcript image file does not exist
 +
** if censusurl is empty (thanks to Paul Rolfe for reporting the issue)
 +
* remove code that attempted to convert censusurl
 +
:if Ancestry censusurl is not correct, you will need to run the update buttons in the Mod Description section
 +
* fix US Summary and Other Summary count displays on the Individual transcript display (getperson.php micro_cpinclude) (thanks to Allen Prunty for reporting the issue)
 +
* added <div class="overflowcensus"> to several scripts to allow all fields to be displayed / entered / edited
 +
* fix Add tab cpcreate.php to add missing SubDist input field in 1921 UK Census (thanks to Paul Rolfe for reporting the issue)
 +
* fix Census Link check in Post Import Utilities to use language strings
 +
* fix several PHP 8.2 warnings
 +
|- valign="top"
 +
| 14.0.0.13a
 +
| 7 January 2023
 +
| Updated to resolve the conflict with [[Create Site Map Mod]] in TNG v14. No other code changes made
 +
|- valign="top"
 +
| 14.0.0.13
 +
| 28 Sep 2022
 +
| Updated for TNG v14
 +
|- valign="top"
 +
| 13.0.0.13
 +
| 26 Sep 2022
 +
| Published the beta code.  Thanks for everyone's patience during beta testing
 +
|- valign="top"
 +
| 13.0.0.13_r1
 +
| 2 Sep 2022
 +
| with collaberation between [[User:Bhemph|Brent Hemphill]] and [[User:KenRoy|Ken Roy]]<br />
 +
Our thanks to Brent, Mark Kosinski, Regis Carr, Marc Irish and Svein Erik for testing the changes
 +
* updated Ancestry and TNG urls to use https
 +
* updated Ancestry search URL to new format
 +
* converted censusurl from http:interactive to imageviewer/collections/dbid/images/iid
 +
*: skip this update if manually added transcript
 +
* updated US Veteran Schedule to US Veterans Schedule
 +
* updated format field in cp_base record to correct format
 +
* changed format for US Veterans Schedule to US Veteran
 +
* changed US Summary to US Veteran for 1890 US Veterans Schedule
 +
* updated series field in cp_base table
 +
* removed unnecessary comment lines in all modules
 +
* updated some scripts to use variables instead of hard-code cp table names* only retrieve cp_summary table data when needed
 +
* only retrieve cp_veteran table data when needed
 +
** to eliminate high CPU usage
 +
** to eliminate large data retrieval
 +
* fixed import for 1910 census using grid-row format
 +
* updated cp_label table
 +
* removed comments added when converting queries to PDO
 +
* updated TNG Wiki article to indicate
 +
** cp_tables must be created in TNG database and not WP db
 +
* updated cpcreate.php to check if first transcript being added
 +
*: to fix cpbaseID = 0 being generated for autoincrement ID
 +
* updated cpdisplay.php, cphouseholdupdate.php, and cpupdate.php to not generate censusurl for manually added transcripts
 +
|- valign="top"
 +
| 13.0.0.13_b1
 +
| 31 May 2022
 +
| with collaberation between [[User:Bhemph|Brent Hemphill]] and [[User:KenRoy|Ken Roy]]<br />
 +
Our thanks to Brent and Mark Kosinski for alpha testing the changes
 +
* added 1950 US Census
 +
* added 1921 UK Census
 +
* added link to Dr Stephen Morse ED finder in the Add tab for US census
 +
* Brent fixed the Import when adding the 1950 US Census import
 +
* fixed the import to import the high lighted family (green-bg)
 +
* fixed the import to import the high lighter person (yellow-bg)
 +
* fixed the cpupdate.php script to eliminate PHP warnings if CP Base ID does not exist such as after a census is deleted
 +
* fixed the cpfind2linkID.php script to eliminate PHP warnings if the CP Base ID does not exist such as after a census is deleted
 +
* fixed several other PHP 8.1 errors
 +
|- valign="top"
 +
| 13.0.0.12a
 +
| 8 Jan 2022
 +
| Resolved conflict with [[Age at event]] by switching to triminsert instructions and fixed PHP 8 warning in Add Image tab in conjunction with [[User:MichelKirsch‎|Michel Kirsch]], [[User:Bhemph|Brent Hemphill]] and [[User:KenRoy|Ken Roy]]
 +
|- valign="top"
 +
| 13.0.0.12
 +
| 1 Dec 2021
 +
| Published the 13.0.0.12-rc1 version with major code changes made to eliminate PHP 8 warnings by [[User:Bhemph|Brent Hemphill]] and [[User:KenRoy|Ken Roy]]
 +
|- valign="top"
 +
| 13.0.0.12-rc1
 +
| 18 Oct 2021
 +
| Major code changes were made to eliminate PHP 8 warnings by [[User:Bhemph|Brent Hemphill]] and [[User:KenRoy|Ken Roy]]
 +
|- valign="top"
 +
| 13.0.4.11
 +
| 9 Jun 2021
 +
| Updated for TNG 13.0.4.  If you are using the [[Alternate Spellings]] mod, it must be installed after the [[Census Plus International]] mod
 +
|- valign="top"
 +
| v13.0.0.11
 +
| 17 Sep 2020
 +
| Updated to
 +
* work with TNG 13 new Admin Layout (Note with v12.0.0.10a shows as OK to Install it will not work in the TNG 13 Admin screens)
 +
* fix Image URL to Ancestry to use their new URL format (../imageviewer/collections/nnnn/images/image_ID
 +
* re-instate code from v12.0.0.9 on how Return All and Return all linked for Media options are processed
 +
* fix several PHP warnings about undefined variables and indexes
 +
* NOTE that the Import no longer works since Ancestry has changed their DOM Source generation
 +
|- valign="top"
 +
| 12.0.0.10a
 +
| 20 Jul 2019
 +
| Updated to
 +
* fix PHP 7.1 warnings Cannot assign an empty string to a string offset in cpdisplay.php and cpupdate.php
 +
*: caused by the Sosa mod v12.0.2.2-rev3 now putting its code snippet in customconfig.php
 +
* fix censusYear ambiguous error if Return All is set to default(n)
 +
* re-instate code from v12.0.0.9 on how Return All and Return all linked for Media options are processed
 +
* fix 1890 US Veteran display works with Return All in getperson.php and Return all linked in showmedia.php transcript display
 +
Our thanks to Brent Hemphill for some of the fixes and to Rick Hooley and John Jamieson for beta testing
 +
|- valign="top"
 +
| 12.0.0.10
 +
| 11 Jul 2019
 +
| Updated to
 +
* fix additional PHP 7.2.14 and 7.3.1 warnings
 +
* change Import Secondary process Check Census Links in an attempt to fix MySQL execution time outs
 +
* change rank to milrank in cp_veterans table for MySQL 8
 +
* fix processing to ignore new index columns in Ancestry DOM source import
 +
* change hard-coded text to use variables in CP Link to create / edit US Veteran table
 +
* change copy / paste of common code in cpinclude.php to media_cpinclude.php to use include micro_cpinclude.php
 +
* fix 1890 US Veteran display on getperson.php and showmedia.php
 +
* fix 1840 US Census summary display on getperson.php and showmedia.php
 +
Our thanks to Brent Hemphill for the code change to the Import Secondary process Check Census Links and for testing the use of additional CP Link indexes that did not help and so were not implemented
 +
|- valign="top"
 +
| 12.0.0.9
 +
| 1 May 2019
 +
| Updated to
 +
* fix several PHP 7.2.14 and 7.3.1 warnings
 +
* change the include(begin.php) with other includes to use include(tng_begin.php) to fix the fatal error in tng_header in several scripts
 +
* change the CP Update to save the format as US Summary for the 1890 US Veteran Schedule so it displays correctly on Individual page
 +
* fix the CP Import to recognize another Ancestry DOM source change
 +
* fix the CP Import to also imported the high-lighted household
 +
* add a mysqli_close to the CP Display to hopefully prevent the query from being put to sleep<br />
 +
Our thanks to Les Campbell and Carlton Brooks for beta testing this version of the mod
 +
|-
 +
| 12.0.0.8a
 +
| 23 Oct 2018
 +
| Updated to fix the import of rows that match search match
 +
|-
 +
| 12.0.0.8
 +
| 21 Oct 2018
 +
| Terminate the import with new messages if the Ancestry DOM source does not contain any column header labels
 +
|-
 +
| 12.0.0.7d
 +
| 16 Sep 2018
 +
| Added new fields to the CP Label table for UK 1841 and 1891 census imports
 +
|-
 +
| 12.0.0.7c
 +
| 24 Jul 2018
 +
| Fixed Import Secondary Process, Check Census Links to detect missing Census Events after an import
 +
|-
 +
| 12.0.0.7b
 +
| 20 Jul 2018
 +
| Fixed upgrade instructions in mod cfg file<br />
 +
Fixed warnings on unquoted variables in PHP 7.2.6
 +
|-
 +
| 12.0.0.7a
 +
| 23 May 2018
 +
| Fixed syntax error in cpcreate.php (Add tab)
 +
|-
 +
| 12.0.0.7
 +
| 1 May 2018
 +
| Updated for TNG v12
 +
* This version will now preserve the cp_settings.inc for the next upgrade
 +
|-
 +
| 11.0.2.6c<br />11.0.0.6c<br />10.1.0.6c
 +
| 5 Apr 2018
 +
| Fixed the following:
 +
* Fixed the Import, Secondary Check Census Link update query to reduce execution time on large tables, thanks to Mark Wonson
 +
|-
 +
| 11.0.2.6b<br />11.0.0.6b<br />10.1.0.6b
 +
| 13 Sep 2017
 +
| Fixed the following:
 +
* Added new cp_label columns for US 1880 Census (<span style="color: red">'''requires table update after install'''</span>)
 +
|-
 +
| 10.1.0.6 Languages
 +
| 2 June 2017
 +
| Added the following languages to the original French language files to provide translations for getperson page display of Census Transcripts
 +
* Danish-UTF8 provided by Claus Martinussen
 +
* German-UTF8 provided by Vinzenz Lübben
 +
* Norwegian-UTF8 provided by Jan Holmbert
 
|-
 
|-
| v11.0.2.5b<br />v11.0.0.5b<br />v10.1.0.5b
+
| 11.0.2.6a<br />11.0.0.6a<br />10.1.0.6a
 +
| 24 May 2017
 +
| Fixed the following:
 +
* Added new cp_label columns for US 1900 Census (<span style="color: red">'''requires table update after install'''</span>)
 +
* Fixed the Check Census code in admin_secondary.php so it works correctly if census are linked to more than one tree
 +
|-
 +
| 11.0.2.6<br />11.0.0.6<br />10.1.0.6
 +
| 25 March 2017
 +
| Fixed the following:
 +
* Removed the check for interactive viewer in DOM source that was erroneously indicating the DOM source is from the old viewer
 +
* Removed the household check when displaying the census transcript for the image or media display where more than one household is in the same census image
 +
* Added new cp_label column for Suffix (<span style="color: red">'''requires table update after install'''</span>)
 +
|-
 +
| 11.0.2.5c<br />11.0.0.5c<br />10.1.0.5c
 +
| 25 November 2016
 +
| Added support for new URL structure that impacted the DOM source generation
 +
|-
 +
| 11.0.2.5b<br />11.0.0.5b<br />10.1.0.5b
 
| 23 November 2016
 
| 23 November 2016
 
| Added support for yet a new DOM source generation
 
| Added support for yet a new DOM source generation
 
|-
 
|-
| v11.0.2.5a<br />v11.0.0.5a<br />v10.1.0.5a
+
| 11.0.2.5a<br />11.0.0.5a<br />10.1.0.5a
 
| 17 November 2016
 
| 17 November 2016
 
| Fixed the following:
 
| Fixed the following:
Line 313: Line 610:
 
* Added support for new DOM source generation
 
* Added support for new DOM source generation
 
|-
 
|-
| v11.0.2.5<br />v11.0.0.5<br />v10.1.0.5
+
| 11.0.2.5<br />11.0.0.5<br />10.1.0.5
 
| 26 September 2016
 
| 26 September 2016
 
| Fixed the following:
 
| Fixed the following:
Line 319: Line 616:
 
* For TNG 11.0.2+ added support for $extspath variable that allows user to rename the extensions folder
 
* For TNG 11.0.2+ added support for $extspath variable that allows user to rename the extensions folder
 
|-
 
|-
| v11.0.0.4b<br />
+
| 11.0.0.4b<br />10.1.0.4b
v10.1.0.4b
 
 
| 20 July 2016
 
| 20 July 2016
 
| Fixed the following:
 
| Fixed the following:
Line 329: Line 625:
 
* Fixed Event Type queries so they work with foreign languages by checking both display and tag
 
* Fixed Event Type queries so they work with foreign languages by checking both display and tag
 
|-
 
|-
| v11.0.0.4a<br />
+
| 11.0.0.4a<br />10.1.0.4a
v10.1.0.4a
 
 
| 24 May 2016
 
| 24 May 2016
 
| Fixed the following:
 
| Fixed the following:
Line 337: Line 632:
 
* Fixed missing text in Find screen
 
* Fixed missing text in Find screen
 
|-
 
|-
| v11.0.0.4<br />
+
| 11.0.0.4<br />10.1.0.4
v10.1.0.4
 
 
| 11 May 2016
 
| 11 May 2016
 
| Updated to use a dictionary approach for the Import from Ancestry, created by Janice Nation.
 
| Updated to use a dictionary approach for the Import from Ancestry, created by Janice Nation.
 
It is no longer necessary to select the series for the import.  
 
It is no longer necessary to select the series for the import.  
 
 
|-
 
|-
| v11.0.0.0
+
| 11.0.0.0
 
| 18 March 2016
 
| 18 March 2016
 
| Updated for TNG V11, but Ancestry Import problem was NOT fixed  
 
| Updated for TNG V11, but Ancestry Import problem was NOT fixed  
 
|-
 
|-
| v10.1.0.3g<br />v10.0.0.2l
+
| 10.1.0.3g<br />10.0.0.2l
 
| 25 October 2015
 
| 25 October 2015
 
| Updates were made  
 
| Updates were made  
Line 357: Line 650:
 
* for importing the location in new DOM source.  It still allows you to specify the location before doing the import
 
* for importing the location in new DOM source.  It still allows you to specify the location before doing the import
 
|-
 
|-
| v10.1.0.3f
+
| 10.1.0.3f
 
| 5 September 2015
 
| 5 September 2015
 
| Updates were made  
 
| Updates were made  
Line 365: Line 658:
 
: Note that updates were not retrofitted to the previous version of the mod for TNG 10 to 10.0.3
 
: Note that updates were not retrofitted to the previous version of the mod for TNG 10 to 10.0.3
 
|-
 
|-
| v10.1.0.3e
+
| 10.1.0.3e
 
| 12 August 2015
 
| 12 August 2015
 
| Updates were made for the US Census Import for 1880, 1900, 1910, 1920, and 1940 variations
 
| Updates were made for the US Census Import for 1880, 1900, 1910, 1920, and 1940 variations
 
: Note that updates were not retrofitted to the previous version of the mod for TNG 10 to 10.0.3
 
: Note that updates were not retrofitted to the previous version of the mod for TNG 10 to 10.0.3
 
|-
 
|-
| v10.1.0.3d<br />v10.0.0.2k
+
| 10.1.0.3d<br />10.0.0.2k
 
| 9 May 2015
 
| 9 May 2015
 
| The following updates were made:
 
| The following updates were made:
Line 379: Line 672:
 
: so existing links are not overlaid with the same PersonID in a different tree
 
: so existing links are not overlaid with the same PersonID in a different tree
 
|-
 
|-
| v10.1.0.3c<br />v10.0.0.2j
+
| 10.1.0.3c<br />10.0.0.2j
 
| 17 February 2015
 
| 17 February 2015
 
| The following updates were made:
 
| The following updates were made:
Line 385: Line 678:
 
* updated Census display on Individual page to not display the Years Married and Children Born/Living for mobile devices
 
* updated Census display on Individual page to not display the Years Married and Children Born/Living for mobile devices
 
|-
 
|-
| v10.1.0.3b<br />v10.0.0.2i
+
| 10.1.0.3b<br />10.0.0.2i
 
| 11 February 2015
 
| 11 February 2015
 
| The following updates were made:
 
| The following updates were made:
Line 391: Line 684:
 
* updated Census display on Individual page to correct the display when using the Display All Members of a Household option
 
* updated Census display on Individual page to correct the display when using the Display All Members of a Household option
 
|-
 
|-
| v10.1.0.3a
+
| 10.1.0.3a
 
| 28 January 2015
 
| 28 January 2015
 
|  
 
|  
 
* Updated cfg file to indicate that if you have already created the CP Indices you should bypass that step.  If you are already running v10.1.0.3 there is no reason to upgrade to this version.  No code was changed.
 
* Updated cfg file to indicate that if you have already created the CP Indices you should bypass that step.  If you are already running v10.1.0.3 there is no reason to upgrade to this version.  No code was changed.
 
|-
 
|-
| v10.1.0.3
+
| 10.1.0.3
 
| 25 January 2015
 
| 25 January 2015
 
|  
 
|  
Line 402: Line 695:
 
* Added a debug message to the media_cpinclude.php  
 
* Added a debug message to the media_cpinclude.php  
 
|-
 
|-
| v10.1.0.3beta
+
| 10.1.0.3beta
 
| 8 January 2015
 
| 8 January 2015
 
|  
 
|  
Line 409: Line 702:
 
* Updated to use English/cp_text.php file if language translations for cp_text.php file do not exist
 
* Updated to use English/cp_text.php file if language translations for cp_text.php file do not exist
 
|}
 
|}
 
  
 
See [[Census Plus International Revisions]] for previous revisions.
 
See [[Census Plus International Revisions]] for previous revisions.
Line 416: Line 708:
  
 
See [[Census Plus International - Visualization]]
 
See [[Census Plus International - Visualization]]
 
  
 
== An Approach to Import ==
 
== An Approach to Import ==
Line 448: Line 739:
 
! TNG-Version
 
! TNG-Version
 
! User-language
 
! User-language
 
+
|-
 +
| [https://marcirish.us/getperson.php?personID=I2&tree=Irish My Family History]
 +
| [[User:Marc Irish|Marc Irish]]
 +
| Beta tester - Fantastic Mod
 +
| 13.0.0.13_b1
 +
| 13.1.2
 +
| EN
 
|-
 
|-
 
| [http://www.nationstudy.com/getperson.php?personID=I6493&tree=NationStudy Nation Study]
 
| [http://www.nationstudy.com/getperson.php?personID=I6493&tree=NationStudy Nation Study]
Line 454: Line 751:
 
| Developed dictionary and logic to use the DOM Source parser
 
| Developed dictionary and logic to use the DOM Source parser
 
| 11.0.0.4
 
| 11.0.0.4
| 11.0.1
+
| 12.1
| English
+
| EN
 
|-
 
|-
 
| [https://www.royandboucher.com/tng/getperson.php?personID=I39&tree=T0001 Our Roy and Boucher Family]
 
| [https://www.royandboucher.com/tng/getperson.php?personID=I39&tree=T0001 Our Roy and Boucher Family]
 
| [[User:Ken Roy|Ken Roy]]
 
| [[User:Ken Roy|Ken Roy]]
 
| Repackaged and enhanced Census Feature  mod
 
| Repackaged and enhanced Census Feature  mod
| 11.0.2.5b
+
| 14.0.1.13c
| 11.0.2
+
| {{Tv1404}}
| English,French
+
| EN,FR
 
|-
 
|-
 
| [http://www.robisonandblythe.org/getperson.php?personID=I10335&tree=RobisonandBlythe Robison and Blythe Genealogy]
 
| [http://www.robisonandblythe.org/getperson.php?personID=I10335&tree=RobisonandBlythe Robison and Blythe Genealogy]
 
| [[User:Jefr58|Jeff Robison]]
 
| [[User:Jefr58|Jeff Robison]]
 
| code contributor.  Created and uses the Add dialog to add census entries.
 
| code contributor.  Created and uses the Add dialog to add census entries.
| 10.0.0.2d
+
| 11.0.2.6
| 10.0.3
+
| 11.1.0
| English
+
| EN
 
|-
 
|-
| [http://mcdfamily.org McDonald Family (aka PFOP)]<br />
+
| [http://mcdfamily.org McDonald Family (aka PFOP)]<br />[http://pagesfromourpast.com Pages From Our Past]
[http://pagesfromourpast.com Pages From Our Past]
 
 
| [[User:alprunty|Allen Prunty]]
 
| [[User:alprunty|Allen Prunty]]
|  alpha/beta tester. - I think this mod rocks!
+
|  alpha/beta tester. - I think this mod rocks! (not a public site)
| 10.1.0.2d
+
| 11.0.2.6
| 10.1.0
+
| 11.1.0
| English
+
| EN
 
|-
 
|-
 
| [http://myfootdeeancestors.co.uk/ MyFOOTDEEAncestors]
 
| [http://myfootdeeancestors.co.uk/ MyFOOTDEEAncestors]
Line 489: Line 785:
 
| [[User:Hiraeth|Graham Chamberlain]]
 
| [[User:Hiraeth|Graham Chamberlain]]
 
|  Census linked to Family Census events. Data managed in desktop application. Beta tested v11.0.0.4
 
|  Census linked to Family Census events. Data managed in desktop application. Beta tested v11.0.0.4
| 11.0.0.4
+
| 12.0.0.7
| 11.0.1
+
| 12.0.0
| English,Dutch,French,German,Spanish
+
| EN,DU,FR,DE,ES
 
|-
 
|-
| [http://www.cookgarza.com/genealogy/getperson.php?personID=I41&tree=tree1 Genealogy Cook]
+
| [http://www.cookgarza.com/getperson.php?personID=I00189&tree=tree1 Genealogy Cook]
 
| [[User:CaseyC|Klaus Dieter Cook]]
 
| [[User:CaseyC|Klaus Dieter Cook]]
| alpha tester. Uses Add, Other Census to enter Mexico census. Guest access login: guest pwd: guest
+
| alpha tester. Uses Add, Other Census to enter Mexico census.
 
| 10.0.0.0
 
| 10.0.0.0
| 10.0.0
+
| 10.1.0
| English,German,Spanish
+
| EN, GE, SP
 
|-
 
|-
 
| [http://www.ourfamilyhistories.org/getperson.php?personID=I152479&tree=00 Our Family Histories]
 
| [http://www.ourfamilyhistories.org/getperson.php?personID=I152479&tree=00 Our Family Histories]
 
| [[User:Bsl20b50|Bryan S. Larson]]
 
| [[User:Bsl20b50|Bryan S. Larson]]
 
| alpha/beta tester
 
| alpha/beta tester
| 10.0.0.2e
+
| 11.0.2.6b
| 10.0.3
+
| 11.1.2
| English
+
| EN
 
|-
 
|-
 
| [http://www.feldmanfamily.ws/genroot/getperson.php?personID=I0015&tree=FDF001 Feldman Family History]
 
| [http://www.feldmanfamily.ws/genroot/getperson.php?personID=I0015&tree=FDF001 Feldman Family History]
Line 512: Line 808:
 
| 9.1.0.0
 
| 9.1.0.0
 
| 9.2.2
 
| 9.2.2
| English
+
| EN
 
|-
 
|-
 
| [http://genealogy.stewart-clan.com/getperson.php?personID=I000157&tree=tree1 Ancestral Stewart Family Tree]
 
| [http://genealogy.stewart-clan.com/getperson.php?personID=I000157&tree=tree1 Ancestral Stewart Family Tree]
Line 526: Line 822:
 
| 9.1.0.0
 
| 9.1.0.0
 
| 9.1.0
 
| 9.1.0
| English
+
| EN
 
|-
 
|-
 
| [http://wilderconnections.org/getperson.php?personID=I104&tree=Wilder Wilder Connections]
 
| [http://wilderconnections.org/getperson.php?personID=I104&tree=Wilder Wilder Connections]
Line 533: Line 829:
 
| 9.1.0.0
 
| 9.1.0.0
 
| 9.2.2
 
| 9.2.2
| English
+
| EN
 
|-
 
|-
 
| [http://iowa.shnw.net/~fosterfa/genealogy/getperson.php?personID=I10584&tree=fh Foster / Hartwell ]
 
| [http://iowa.shnw.net/~fosterfa/genealogy/getperson.php?personID=I10584&tree=fh Foster / Hartwell ]
Line 540: Line 836:
 
| 10.0.0.1a
 
| 10.0.0.1a
 
| 10.0.2
 
| 10.0.2
| English
+
| EN
 
|-
 
|-
 
| [http://schnetzka.net/genealogy/schnetzka/getperson.php?personID=I56&tree=schnetzka The Schnetzka Family]
 
| [http://schnetzka.net/genealogy/schnetzka/getperson.php?personID=I56&tree=schnetzka The Schnetzka Family]
| Steve Pritt
+
| [[User:Schnetzka|Stephen M Pritt]]
 
|  
 
|  
| 9.1.0.2
+
| 11.0.2.6
| 9.2.2
+
| 11.0.2
| English
+
| EN
 
|-
 
|-
 
| [http://paradiseohana.com/getperson.php?personID=I159&tree=ohana Farnham & Paradise Ohana]
 
| [http://paradiseohana.com/getperson.php?personID=I159&tree=ohana Farnham & Paradise Ohana]
Line 554: Line 850:
 
| 10.0.0.0a
 
| 10.0.0.0a
 
| 10.0.2
 
| 10.0.2
| English
+
| EN
 
|-
 
|-
| [http://www.duttongenealogy.com/getperson.php?personID=I6&tree=tree1 The Dutton's of Vermont]
+
| [http://www.duttongenealogy.com/getperson.php?personID=I6&tree=tree1 The Duttons of New England]
| [[User:darrin65|Darrin Dutton]]
+
| [[User:Darrin65|Darrin Dutton]]
| Public Site
+
| Public / Private
| 11.0.0.4b
+
| 13.0.0.11
| 11.0.1
+
| 13.0.2
| English
+
| EN
 
|-
 
|-
 
| [http://genealogy.oceanwharf.com/getperson.php?personID=I1839&tree=Hooley02 Hooley Family Links]
 
| [http://genealogy.oceanwharf.com/getperson.php?personID=I1839&tree=Hooley02 Hooley Family Links]
 
| [[User:lastejas|Rick Hooley]]
 
| [[User:lastejas|Rick Hooley]]
| Public Site
+
| Public/Private
| 10.0.0.3c
+
| [[User: lastejas|See Here]]
| 10.1.1
+
| [[User: lastejas|See Here]]
| English
+
| EN
 
|-
 
|-
 
| [http://allen-to-weaver.info/getperson.php?personID=4F00004&tree=tree1 Allen Family]
 
| [http://allen-to-weaver.info/getperson.php?personID=4F00004&tree=tree1 Allen Family]
Line 575: Line 871:
 
| 9.1.0.2
 
| 9.1.0.2
 
| 9.2.2
 
| 9.2.2
| English
+
| EN
 
|-
 
|-
 
| [http://www.farrars-island.net/genealogy/getperson.php?personID=I72&tree=Farrar Farrar Family]
 
| [http://www.farrars-island.net/genealogy/getperson.php?personID=I72&tree=Farrar Farrar Family]
Line 582: Line 878:
 
| 9.1.0.3
 
| 9.1.0.3
 
| 9.2.2
 
| 9.2.2
| English
+
| EN
 
|-
 
|-
 
| [http://www.carrfamilytree.com/genealogy/getperson.php?personID=I12&tree= Carr Family Tree]
 
| [http://www.carrfamilytree.com/genealogy/getperson.php?personID=I12&tree= Carr Family Tree]
| Regis Carr
+
| [[User:Regis Carr|Regis Carr]]
| beta tested v10.1.0.4
+
| beta tested v10.1.0.4; XAMPP v12 w/ MOD v12.0.0.8a
| 10.1.0.4
+
| 14​.0​.1​.13c 
| 10.1.2
+
| 14.0.3
| English
+
| EN
 
|-
 
|-
 
| [http://www.oldhamfamilies.net/getperson.php?personID=I501&tree=oldham Oldham One Name Study]
 
| [http://www.oldhamfamilies.net/getperson.php?personID=I501&tree=oldham Oldham One Name Study]
Line 596: Line 892:
 
| 10.0.0.1a
 
| 10.0.0.1a
 
| 10.0.2
 
| 10.0.2
| English
+
| EN
 
|-
 
|-
 
| [http://www.polysfamily.org/getperson.php?personID=I562&tree=polys Polys Family Genealogy]
 
| [http://www.polysfamily.org/getperson.php?personID=I562&tree=polys Polys Family Genealogy]
Line 603: Line 899:
 
| 10.0.0.0
 
| 10.0.0.0
 
| 10.0.1
 
| 10.0.1
| English
+
| EN
 
|-
 
|-
 
| [http://genealogy.wagners.homeip.net/tng/ Wagner Walton Genealogy]
 
| [http://genealogy.wagners.homeip.net/tng/ Wagner Walton Genealogy]
Line 610: Line 906:
 
| 10.0.0.2c
 
| 10.0.0.2c
 
| 10.0.0
 
| 10.0.0
| English
+
| EN
 
|-
 
|-
 
| [http://djcm.dk DJCM.DK]
 
| [http://djcm.dk DJCM.DK]
 
| Claus Martinussen
 
| Claus Martinussen
| Public Site.
+
| Not a Public Site.
| 11.0.0.0          
+
| 13.0.4.11          
| 11.0.0
+
| 13.0.4
| Danish, English
+
| DA, EN
 
|-
 
|-
 
| [http://mackayproject.cundiffgenealogy.org Mackay / McCoy / McKee YDNA Surname Project]
 
| [http://mackayproject.cundiffgenealogy.org Mackay / McCoy / McKee YDNA Surname Project]
Line 624: Line 920:
 
| 10.1.0.3c
 
| 10.1.0.3c
 
| 10.1.0
 
| 10.1.0
| English
+
| EN
 
|-
 
|-
 
| [http://x.liebowitzes.com/genealogy Roni & Jerry's Genealogy and Family History]
 
| [http://x.liebowitzes.com/genealogy Roni & Jerry's Genealogy and Family History]
Line 631: Line 927:
 
| 10.1.0.3c
 
| 10.1.0.3c
 
| 10.1.0
 
| 10.1.0
| English
+
| EN
 
|-
 
|-
 
| [https://www.bradyfamilytree.org/ Brady Family Tree in Western Australia]
 
| [https://www.bradyfamilytree.org/ Brady Family Tree in Western Australia]
Line 647: Line 943:
 
| EN
 
| EN
 
|-
 
|-
| [http://gen.markkosinski.com/ Four Branches Genealogy]
+
| [https://gen.fourbranches.org/ Four Branches Genealogy]
 
| Mark Kosinski
 
| Mark Kosinski
| beta tested v11.0.0.4
+
| beta tested
| 11.0.0.4
+
| 12.0.0.10a
| 11.0.1
+
| 12.1.0
| English
+
| EN
 
|-
 
|-
 
| [http://www.stellacilento.org/tng/getperson.php?personID=I00011&tree=14March2012 Conjunctions: Genealogy at the Crossroads]
 
| [http://www.stellacilento.org/tng/getperson.php?personID=I00011&tree=14March2012 Conjunctions: Genealogy at the Crossroads]
Line 659: Line 955:
 
| 11.0.0.4
 
| 11.0.0.4
 
| 11.0.1
 
| 11.0.1
| English
+
| EN
 
|-
 
|-
 
| [http://www.tea2weeds.com/ From Tea to Tumbleweeds]
 
| [http://www.tea2weeds.com/ From Tea to Tumbleweeds]
Line 666: Line 962:
 
| 11.0.0.4b
 
| 11.0.0.4b
 
| 11.0.1
 
| 11.0.1
| English
+
| EN
 
|-
 
|-
 
| [http://hammittroots.com/genealogy/login.php Hammitt Roots]
 
| [http://hammittroots.com/genealogy/login.php Hammitt Roots]
Line 673: Line 969:
 
| 11.0.2.5
 
| 11.0.2.5
 
| 11.0.2
 
| 11.0.2
| English
+
| EN
 
|-
 
|-
 
| [http://www.roebuckfamily.com/Donald/genealogy/index.php Roebuck and Families Ancestry Website]
 
| [http://www.roebuckfamily.com/Donald/genealogy/index.php Roebuck and Families Ancestry Website]
 
| [[User:don1two|Donald Roebuck]]
 
| [[User:don1two|Donald Roebuck]]
 
| Public site except for Living
 
| Public site except for Living
| 11.0.2.5a
+
| 11.0.2.5c
 +
| 11.0.2
 +
| EN
 +
|-
 +
| [http://www.bussiererobinsonfamily.ca Bussiere, Robinson, Gingras Website]
 +
| [[User:Brian Bussiere|Brian Bussiere]]
 +
| Public site
 +
| 10.1.3
 +
| 10.1.0.5
 +
| EN, FR
 +
|-
 +
| [http://www.ccggpa.org/cemeteries/index.php Crawford County Genealogy Gateway]
 +
| [[User:Fraber|Frank Bernosky]]
 +
| Public site
 +
| 11.0.2.6a
 +
| 11.1.1
 +
| EN
 +
|-
 +
| [http://porterfieldjunction.net/ Porterfield Junction]
 +
| [[User:Glporterfield|George Porterfield ]]
 +
| Not a public site
 +
| 10.1.0.6
 +
| 10.1.2
 +
| EN
 +
|-
 +
| [http://www.rodriguezuribe.co Rodriguez Lopez y Uribe Senior pagina de Genealogia]
 +
| [[User:Camiloro|Camilo Rodriguez Uribe]]
 +
|
 +
| 11.0.2.6
 +
| 11.0.2
 +
| SP, EN
 +
|-
 +
| [http://whipplephoto.com/genealogy Whipple, White, Nelson &amp; Duncan Families]
 +
| [[User:Snwhip|Steven Whipple]]
 +
|
 +
| 11.0.2.6
 +
| 11.1.0
 +
| EN, DA, GE, SP, NE, FR, IT, and others
 +
|-
 +
| [http://kystslekt.no Hans and Hennes Families]
 +
| [[User:Roakdah|Roar Dahle]]
 +
|
 +
| 11.0.2.6
 +
| 11.1.0
 +
| NO
 +
|-
 +
| [http://www.mymispoche.com/getperson.php?personID=I3220&tree=MM MyMispoche]
 +
| [[User:Carltonb|Carlton Brooks]]
 +
|
 +
| 12.0.0.10a
 +
| 12.1.0
 +
| EN
 +
|-
 +
| [http://thepettitforest.com The Pettit Forest]
 +
| [[User:Rcpettit|Robert Pettit]]
 +
|
 +
| 11.0.2.6
 +
| 11.0.2
 +
| EN
 +
|-
 +
| [http://www.myfamily-reunion.org/ancestry/ Family History and Ancestry]
 +
| [[User:FifthEditon|Jay Santos]]
 +
|
 +
| 12.0.0.10
 +
| 12.0.3
 +
| EN
 +
|-
 +
| [http://jrho.no/getperson.php?personID=I93&tree=jrh1 Familien Holmberg]
 +
| [[User:Jaroho|Jan Roger Holmberg]]
 +
|
 +
| 11.0.2.6
 +
| 11.1.0
 +
| NO
 +
|-
 +
| [https://www.rintoulbowman.com/index.php Rintoul/Bowman Family]
 +
| [[User:Adrintoul|Andrew Rintoul]]
 +
| Public/Private
 +
| 12.0.0.7
 +
| 12.0
 +
| EN, DE, ES, FR
 +
|-
 +
| [http://www.byberrywaltons.com Byberry Waltons]
 +
| [[User:Bwalton|Bill Walton]]
 +
| Not a public site
 +
| 11.0.2.6
 
| 11.0.2
 
| 11.0.2
| English
+
| EN
 +
|-
 +
| [https://www.ourlife.us OurLife Family History - McMullen Clan]
 +
| [[User:Seanst|Sean Thompson]]
 +
| Not a public site.
 +
| 11.0.2.6
 +
| 11.1.0
 +
| EN
 +
|-
 +
| http://wiiaas.no/
 +
| [[User:Arwiik|Arnfinn Wiik]]
 +
| Not a public site.
 +
| 11.0.2.6
 +
| 11.1.0
 +
| NO
 +
|-
 +
| [http://www.geekygenealogist.com/tng/getperson.php?personID=I6&tree=bctree Geeky Genealogist]
 +
| [[User:Wenm|Wendy Allen]]
 +
|
 +
| 11.0.2.6
 +
| 11.1.0
 +
| EN
 +
|-
 +
| [https://www.larleegenealogy.org The Larlee Genealogy]
 +
| [[User:HeatherFeuer|Heather Feuerhelm]]
 +
|
 +
| 11.0.2.6
 +
| 11.1.0
 +
| EN
 +
|-
 +
| [http://sklgenealogy.net/ Wilton, Brimson, Munro and Forward Families]
 +
| [[User:Malleefowl|Sharon Lewis]]
 +
|
 +
| 11.0.2.6
 +
| 11.1.0
 +
| EN
 +
|-
 +
| [http://www.bunkers-dolan.com Bunkers Dolan Family]
 +
| [[User:Tamid|Tami Dolan]]
 +
|
 +
| 11.0.2.6
 +
| 11.1.0
 +
| EN
 +
|-
 +
| [http://whakapapa.gen.nz/genealogy A Family Journey]
 +
| [[User:Roger NZ|Roger Williams]]
 +
|
 +
| 12.0.0.8
 +
| 11.1.0
 +
| EN
 +
|-
 +
| [http://landlfamilytree.myvnc.com DiFava / Brandt Family History]
 +
| [[User:Brewmaster|Larry DiFava]]
 +
|
 +
| 11.0.2.6
 +
| 11.1.0
 +
| EN
 +
|-
 +
| [http://genealogy.stewart-clan.com Ancestral Stewart Family Tree]
 +
| [[User:Ecks|Michael Stewart]]
 +
|
 +
| 11.0.2.6a
 +
| 11.1.1
 +
| EN
 +
|-
 +
| [http://total-family-history.com/tng11/ Total Family History]
 +
| [[User:Fallonman|Scott Bennett]]
 +
| Not a public site
 +
| 11.0.2.6a
 +
| 11.1.1
 +
| EN
 +
|-
 +
| [http://slekt.nordseth.me SiEiNo's slekt på Internett]
 +
| [[User:SieinoTng|Eilif A Nordseth]]
 +
| Not a public site
 +
| 11.0.2.6a
 +
| 11.1.1
 +
| EN, NO
 +
|-
 +
| [http://www.pepperrell.net/tng Pepperrell and Clarke Family]
 +
| [[User:Philpepz|Phillip Pepperrell]]
 +
|
 +
| 11.0.2.6a
 +
| 11.1.1
 +
| EN
 +
|-
 +
| [http://steigerwald.us Steigerwald - McManus - Hite Kaeslingk - Gaffga Families]
 +
| [[User:Ricki S|Ricarda Steigerwald]]
 +
|
 +
| 11.0.2.6a
 +
| 11.1.1
 +
| EN
 +
|-
 +
| [http://www.victoria-slekt.org Vår families slektssider]
 +
| [[User:Tasta|Jahn Edgar Michelsen]]
 +
| Not a public site
 +
| 11.0.2.6a
 +
| 11.1.1
 +
| NO, EN
 +
|-
 +
| [https://acadianfamily.com Our Acadian Family]
 +
| [[User:Randal Suire|Randal Suire]]
 +
| Public/Media Private 
 +
| 12.0.0.7d
 +
| 12.0.1
 +
| EN, FR
 +
|-
 +
| [http://hanniganfamilytree.us/ Hannigan History Pages]
 +
| John Hannagan
 +
| Public/Media Private 
 +
| 12.0.0.7a
 +
| 12.0.0
 +
| EN
 +
|-
 +
| [https://lloyd-lucas.kiwi.nz Lloyd & Lucas - A Merging of Interests]
 +
| [[User:ChrisLnz|Chris Lloyd]]
 +
| Public site
 +
| 12.0.0.8
 +
| 12.0.1
 +
| EN
 +
|-
 +
| [https://www.gambrillfamilytree.com/genealogy/getperson.php?personID=I3966&tree=treeno1 Gambrill Family Tree]
 +
| [[User:bobbyfamilytree|Bobby Gambrill]]
 +
| Public site
 +
| 12.0.0.9
 +
| 12.2
 +
| EN
 +
|-
 +
| [https://porterfieldjunction.net Porterfield Junction]
 +
| George Porterfield
 +
| Private site
 +
| 12.0.0.8a
 +
| 12.0.3
 +
| EN
 +
|-
 +
| [http://www.vanheerden.net/searchform.php vanheerden.net]
 +
| [[User:emile01|Emile]]
 +
| Private site
 +
| 12.0.0.10
 +
| 12.1
 +
| EN
 +
|-
 +
| [http://www.somejamesons.com/genealogy/index.php Some Jamesons]
 +
| [[User:Jaj|John Jameson ]]
 +
|
 +
| 12.0.0.10a
 +
| 12.1
 +
| EN
 +
|-
 +
| [https://ourfamilytreesearch.com Our Family Tree Search]
 +
| [[User:JessSenk|Jessica Senkyr-Robinette ]]
 +
| Private Site
 +
| 12.0.0.8a
 +
| 12.0.2
 +
| EN
 +
|-
 +
| [http://kilkie.org/tng Kilkie Family Tree]
 +
| Martin Kilkie
 +
| Private site, guest login: guest pwd: guest
 +
| 12.0.0.8a
 +
| 12.0.2
 +
| EN
 
|-
 
|-
 +
| [https://peekatourfamily.online Peek at out Family]
 +
| [[User:User:Ashleypeek|Ashley Peek ]]
 +
|
 +
| 14​.0​.1​.13
 +
| 14.0.1
 +
| EN
 
|}
 
|}
  
Line 715: Line 1,262:
 
* personlib.php
 
* personlib.php
 
* admin_merge.php
 
* admin_merge.php
* admin_main.php
 
* admin_leftbanner.php
 
 
* languages/English/cust_text.php
 
* languages/English/cust_text.php
 
* languages/English-UTF8/cust_text.php
 
* languages/English-UTF8/cust_text.php
Line 731: Line 1,276:
 
The following modules are added by this mod to [[Census Plus International - Options|provide options]] on how the mod behaves
 
The following modules are added by this mod to [[Census Plus International - Options|provide options]] on how the mod behaves
 
* extensions/cp_settings.inc
 
* extensions/cp_settings.inc
 +
{{TNG 13.0|and after}}In TNG V13 and later, this mod modifies the following files:
 +
* admin_leftmenu.php
 +
* admin.php
 +
{{TNG 12.3.0|and before}}{{TNG 9.1.0|and after}}In TNG V9.1 and later, this mod modifies the following files:
 +
* admin_leftbanner.php
 +
* admin_main.php
  
 
</div></div>
 
</div></div>
Line 738: Line 1,289:
 
{{:Census Plus International Related Links}}
 
{{:Census Plus International Related Links}}
  
 +
[[Category:Mods for TNG v14]]
 +
[[Category:Mods for TNG v13]]
 +
[[Category:Mods for TNG v12]]
 
[[Category:Mods for TNG v11]]
 
[[Category:Mods for TNG v11]]
 
[[Category:Mods for TNG v10]]
 
[[Category:Mods for TNG v10]]
Line 752: Line 1,306:
 
[[Category:getperson.php mods]]
 
[[Category:getperson.php mods]]
 
[[Category:personlib.php mods]]
 
[[Category:personlib.php mods]]
[[Category:admin_leftbanner.php mods]]
+
[[Category:admin_leftmenu.php mods]]  <!-- TNG v13 and later -->
[[Category:admin_main.php mods]]
+
[[Category:admin.php mods]]            <!-- TNG v13 and later -->
 +
[[Category:admin_leftbanner.php mods]] <!-- TNG v12 and earlier -->
 +
[[Category:admin_main.php mods]]       <!-- TNG v12 and earlier -->
 
[[Category:admin_deleteevent.php mods]]
 
[[Category:admin_deleteevent.php mods]]
 
[[Category:ajx_delete.php mods]]
 
[[Category:ajx_delete.php mods]]

Latest revision as of 17:59, 6 March 2024

Restricted Downloads of Census Plus International are restricted to logged in users. If you do not have a user account on the TNG Wiki use the Request Account link to request a user account Restricted
Caution If you have trouble downloading with Google Chrome, Vivaldi, Brave or other Chromium based browser, try using a right-click and select Open in new Window, then F5, or use another browser such as Firefox


Caution


Ambox notice.png V14.0.0.13a and v13.0.0.13 include changes to support the 1950 US Census and the 1921 UK Census by Brent Hemphill and Ken Roy.

The import from Ancestry is once again no longer working, you will need to use the Add tab to manually add the census transcript
Important:If you download, install, and use this mod, please update the Sites using this mod table

TNG 14.0


Ambox notice.png The latest version of this mod uses the guidelines for TNG v12+ cust_text.php files. If you are using TNGv12+, and any cust_text.php file in this mod is marked with a Bad Target error, you need to update your cust_text.php files before you can install this mod. [Show instructions]

If you upgraded to TNGv12+, and did not update your cust_text.php files as instructed in the upgrade readme script, then you must use the TNG Mod Manager to update them. To do so:

  1. Go to Mod Manager, and select its "Recommended Updates" tab.
    (If the "Recommended Updates" tab is not visible, then go to the Mod Manager Options tab, select "Display Settings", and turn on the "Recommended Updates" tab.)
  2. Click the "Update" button in the "Recommended Updates" tab.
    Installed mods do not interfere with the update, and if you already have (or think you may have) run this update, it will not hurt for you to run it again.

[See details in the TNGv12 Change Impacts Article][Hide the instructions]

TNG 14.0
TNG 13.0
TNG 12.0


Census Plus International
Summary Adds international census record data for Households on individual Info page
Validation
Mod Updated 7 Sep 2023
Download link For
TNG 14.0.1
censusplus_v14.0.1.13c.zip
censusplus_v14.0.1.13c_lang.zip
For
TNG 14.0
censusplus_v14.0.0.13a.zip
censusplus_v14.0.0.13b_lang.zip
For
TNG 13.0
censusplus_v13.0.0.13.zip
censusplus_v13.0.0.13_lang.zip

for PHP 8

TNG 13.0
censusplus_v13.0.0.12a.zip
censusplus_v13.0.0.12_lang.zip
Import from Ancestry No longer works
for
TNG 12.0
censusplus_v12.0.0.10a.zip
censusplus_v12.0.0.10a_lang.zip
[Show older versions]

Import from Ancestry NOT supported

for
TNG 11.0.2
TNG 11.0
TNG 10.1.0
v10.1.0.6 Languages
censusplus_v9.1.0.4b_French.zip

[Hide old versions]

Download stats View download statistics
Author(s) Janice Nation, Jeff Robison, and Ken Roy
Homepage Census Plus International
Mod Support TNG Forums
Contact Developer
Latest Mod 14.0.1.13c for TNG 14.0.1+
14.0.0.13a for TNG 14+
13.0.0.13 for 1950 US / 1921 UK census
13.0.0.12a for PHP 8
13.0.4.11 for TNG 13.0.4+
13.0.0.11 for TNG 13+
12.0.0.10a for TNG 12+
11.0.2.6c for TNG 11.0.2+
11.0.0.6c for TNG 11
10.1.0.6c for TNG 10.1+
Min TNG V 10.1.0
Max TNG V 14+
Files modified
Related Mods
Show/Hide Events can hide the events
Media - Census Plus International displays the Census Plus Transcript for user census Media collections
Family Edit Links Mod to quickly find the personID of family members
Person Custom Events relocates custom events below the Event Map.
Notes
This mod is an alternative to the Census Feature mod so you need to choose which one you install. They cannot both be on the system at the same time, since they both modify the tngtabs1.css files

Purpose of the mod

The Census Plus International mod allows you to display census transcript information for various countries on an individual page. It adds a Census Plus International menu to the TNG Admin screen which in turn allows an administrator to create, import, edit, search, find, update, or link international census records to individuals or a family.
Ancestry.com members can automatically import census records for the US Federal Census, UK Census, or Census of Canada.

The Census Plus International mod includes the following capabilities:

  • it uses the TNG Find Person and Advanced person search to find persons to be linked to the census transcript.
  • it uses TNG Name Order option to display Census Plus transcript on Individual Page
  • it adds a Person Preview to Census Plus Transcript Display provided by Jeff Robison
  • it allows you to Add census transcripts that cannot be imported, such as the Ireland, Scotland, Acadian, New France, and Lower Canada censuses
  • it can be used to add special census or other country census series that are not specifically defined
  • it allows the use of media collections or the use of alternate file names for your census image display
  • it allows the use of apostrophes in person and place names
  • it imports the actual census line numbers where available and allows the user to update them
  • it repeats the heading line as a table footer line for readability
  • it provides a new search capability modeled on the TNG people search
  • it adds several fields that better allow documenting your census source
  • it provides a script to copy the Census Feature tables if you were using it previously.

Script names and table names are different from the Census Feature mod, so there should be no collisions, although both mods cannot be installed at the same time since both include modifications to the TNG tngtabs1.css file to support a 7th tab.

Developer

This mod was developed by Janice Nation, Jeff Robison, Ken Roy, and Brent Hemphill

V9.0.0.2 enhancements made by Janice and Ken to the original Census Feature mod by Gerald 'Jerry' Leehan were used along with parts of Jerry's original mod. Add capability provided by Jeff Robison

V12.0.0.10 Attempted fix to Import, Secondary Check Census Link provided by Brent Hemphill

V10.1.0.6c/V11.0.0.6c/V11.0.2.6c Fix to Import, Secondary Check Census Link created with the help of Mark Wonson

V10.1.0.4/V11.0.0.4 enhancements made by Janice Nation to use a dictionary approach to process the Ancestry DOM source.

Credit for the mod also goes to Gerald 'Jerry' Leehan for the initial design and concept of the Census Feature mod and for the suggestions and testing provided by the alpha and beta testers:

V9100-V9102 V9103-V9104 V10104-V11004 V130013 beta
  • Bryan Larson
  • Klaus Dieter Cook
  • Graham Chamberlain
  • Fred Feldman
  • Heather Fueurhelm
  • Roger Mitchell
  • Bryan Larson
  • Dave Foster
  • Graham Chamberlain
  • Klaus Dieter Cook
  • Randy Farrar
  • Rick Hooley
  • Regis Carr
  • Graham Chamberlain
  • Mark Kosinski
  • Bryan Larson
  • Brent Hemphill
  • Mark Kosinski
  • Regis Carr
  • Marc Irish
  • Svein Erik Bjartheim

Requirements

Caution If you also use the Alternate spellings mod with v13.0.1.13a of the Census Plus International mod, you must update to 13.0.1.2a version of the Alternate spellings mod to eliminate the Not Unique error in personlib.php that prevents the Census Plus International mod from installing
If you also use the Create Site Map Mod in TNG v14, you must update to 14.0.0.13a version of the Census Plus International mod to resolve the conflict in the Post-Import Utilities
Caution


Note The Census Plus tables must be created in your TNG database and not your WP database


TNG version: 12.0.0
  • the v13.0.0.11 and v12.0.0.10 and later versions of the mod are the only versions that might support MySQL 8
previous versions of the mod do not support MySQL 8
TNG version: 10.1.0
  • the latest version of the mod uses MySQLi, therefore it is only available for TNG 10.1 and above
the MySQL version of the mod was not reworked
TNG version: 9.1.0
  • this mod requires jQuery, therefore it is only available for TNG 9.1 and above
  • this mod requires that the DOM extension to PHP be installed
  • A working TNG installation.
  • A backup of all affected files (see the list in the summary in the upper right corner of the page)
  • Updated versions of your cust_text.php file (see infobox at beginning of this article on how to update your cust_text.php files to the new Mod Guidelines using the Mod Manager
  • All templates/templateN folders be on your site
  • Both English and English-UTF8 folders be on your site
  • Census custom event type must be set to Accept.
    You can use personally created census event as long as the description contains census or the tag contains cens
  • for multi-language support to work, the Census Events must use either the CENS tag or contain census in the description
  • The Census custom event date can be a full date
  • two different census for the same year require two different census event types for linking
    for example the 1850 and 1860 US Federal Census and US Slave Schedule cannot be linked to the same census event
    the recommendation is to define a Slave Census event for the US Slave Schedule - note that the description must include the word census
  • Household number must be assigned for this mod to work
  • PersonID must be linked to the census entry for the person to be listed in the Census Plus transcript display
  • If you use a language other than English for TNG Admin, you need to
    • create the custom text entries in cust_text.php for your language
    • copy and translate the cp_text.php file from the English folder

Installation

  1. Download the appropriate zip file as shown in the summary in the upper right corner of the page.
  2. Extract the files and folder with all its contents from the downloaded zip file into the mods folder or FTP the extracted files and folder with its contents to your mods folder.
  3. Follow the normal automated installation for Mod Manager, as shown in the example Mod Manager - Installing Config Files to install the mod.
  4. Note - if you're using the tng.php WordPress-TNG Plugin, you might need to "Update the TNG Variables" in the WordPress Admin pane for the TNG Plugin to get this to work correctly.
  5. Note - if you're using a different language than English for TNG Admin, you will need to copy the cp_text.php file from the languages/English or English-UTF8 folder to your language folder after installing the mod, before the buttons in the Mod Manager for the Census Plus International mod will work.
    The censusplus_v12.0.0.10 and later provides a _lang.zip for the Danish-UTF8, French, French-UTF8, German-UTF8, and Norwegian-UTF8 cp_text.php files

First Time Post Install Actions

  1. Click the Create CPI Tables button shown on the Mod Manager screen to add the census plus tables if they do not exist.
  2. Click the Create CPI INDEXes button shown on the Mod Manager screen to create the census plus table indices.
  3. Click the Create Folders button on the Mod Manager screen to create the census and transcriptsource folders if they do not already exist.

Upgrading to v14.0.1.13a

If upgrading from v13.0.0.13, v14.0.0.13, or v14.0.1.13, no post install action.

upgrading from v13.0.0.12a or earlier

If you were previously using the Census Plus International mod

  • Install the Census Plus International mod
  • in the Mod Manager description section
    • click the Fix CP Table Indexes button
    • click the Check CP Base Table button
    • If Check CP Base Table indicates that the censusurl must be updated, then click the button to Update CensusURL
    • If Check CP Base Table indicates that the US Veteran Series must be updated, then click the button to Update US Veterans Series
    • If Check CP Base Table indicates that the cp_base datebase must be updated, then click the button to Update CP Base Table
    • click the Verify the CP Base Table Updates button
[Show older upgrade instructions]


Upgrading to v12.0.0.11

from any .4/.5/.6/.7/.8/.9

If upgrading to 12.0.0.10 versions from

  • any 12.0.0.9 versions
  • any 12.0.0.8 versions
  • any 12.0.0.7 versions
  • any 10.1.0.6, 11.0.0.6, or 11.0.2.6 versions
  • any 10.1.0.4, 11.0.0.4, or 11.0.2.4 or
  • any 10.1.0.5, 11.0.0.5, or 11.0.2.5 versions,

you need to

  1. Backup your Census Plus Tables
  2. Uninstall the current Census Plus International mod but do NOT drop the tables
  3. Delete the previous version of the Census Plus International mod. You can delete previous versions of the censusplus folder
  4. FTP the extracted .cfg file and the censusplus_v120010 folder and all its contents to your TNG mods folder (or extract on site)
  5. Install the new Census Plus International version of the mod
  6. Update the CPI Label table
  7. Update the CPI Veteran table

from other versions

If upgrading from versions prior to any of the 10.1.0.4 or .5, 11.0.0.4 or 5, or to 11.0.2.5 versions

  1. Backup your Census Plus Tables
  2. Uninstall the current Census Plus International mod but do NOT drop the tables
  3. Delete the previous version of the Census Plus International mod. You can delete previous versions of the censusplus folder
  4. FTP the extracted .cfg file and the censusplus_v11004 folder and all its contents to your TNG mods folder (or extract on site)
    Note the mod folder is the same for the v11.0.0.4 and v10.1.0.4
  5. Install the new Census Plus International version of the mod
  6. Create CPI Label table
Note that this is required if upgrading from 10.0.0.4/11.0.0.4 or 10.0.0.4a/11.0.0.4a to add new Ancestry column labels
  1. If you have already created the CPI indices in a prior upgrade, you can ignore this step
If already created, clicking this button will return a Cannot execute query
(#1061 - Duplicate key name 'BaseID' if you run it in phpMyAdmin)
  1. Update the CPI Veteran table

To previous versions

NOTE that v10.1.0.3 of the mod is the same as v9104d so you should not need to do any updating steps. Just install the new mod.

Likewise there are no upgrading steps if replacing V9104d or v10000, other than Creating the Census Plus table indices added in v10001

  • Census Plus International Upgrades: You should
  1. Create a backup of the Census Plus Tables before you remove the mod and do the upgrade
  2. Create a backup of the extensions/cp_settings.inc file that contains your Mod Manager Edit changes to the Census Plus International default options
  3. Remove (uninstall) the currently installed version of the mod but not the tables since they will contain your census data
  4. Download and extract the new version of the mod
  5. FTP the extracted .cfg file and the censusplus_v910n or v1000n folder and all its contents to your TNG mods folder (or extract on site)
  6. Delete the previous version of the mod and manually delete the censusplus_v910n or v1000n folder
  7. Install the new version of the mod which should leave your tables and directories intact.
    • Upgrading from v10001, go to Step 8
    • Upgrading from v9104c/d/e or v10000
    1. Create the Census Plus table indices (if you created the indices in a prior upgrade, skip this step)
    2. go to Step 8
    • Upgrading from the Census Feature v9.0.0.2 or v9.2.1.2 to this mod, you need to click the buttons in the Mod Manager screen for the Census Plus International mod to
    1. Copy the Census Feature tables
    2. Create the Census Plus Veteran table
    3. Update the Census Plus Tables
    4. Create the Census Plus table indices
    5. Backup your Census Plus Tables
    6. Check Table Integrity
    1. Update the Census Plus Summary table
    2. Update the Census Plus Tables
    3. Create the Census Plus table indices
    4. Check Table Integrity
  8. Note - if you're using the tng.php WordPress-TNG Plugin, you need to "Update the TNG Variables" in the WordPress Admin pane for the TNG Plugin to get this mod to work correctly.
  9. Create a backup of the Census Plus Tables after the upgrade before you make any changes
  10. Using the backup of the extensions/cp_settings.inc file Edit the Mod Manager option to set your preferred processing options.
  • TNG release upgrades: It is not necessary to remove (uninstall) the mod prior to installing the TNG upgrade. You will likely need to do a Clean up after the upgrade and then re-install the mod.

[Hide old upgrades]

Previous Census Feature users

NOTE: If you previously ran the Census Feature mod do not follow the First Time Install steps on the Mod Manager screen, but use the following steps.

  1. Uninstall the Census Feature mod but do NOT drop the tables
  2. Install the Census Plus International mod
  3. Copy the Census Feature Tables
  4. Create the Census Plus Veterans Table (unless you previously were alpha testing the Census Feature v9003-alpha-7 release)
  5. Update the Census Plus Tables
  6. Update the Census Plus Summary Table
  7. Backup your Census Plus tables
  8. Check Table Integrity
    This step will update the new cp_data cplineno and the cp_link eventID fields and fix integrity issues within the Census Plus tables
  9. Skip the First Time Install steps

Note that Copying the Census veteran table to Census Plus veteran cp_veteran table will result in the following error:

Cannot execute query: CREATE TABLE cp_veteran LIKE cen_veteran;

The copy was left in place to support those who were alpha testing an update to the Census Feature mod that was never released.

Use of the Mod

The Mod adds a new item "Census Plus International" to the Admin screen from which its operations can be directed to

See also Considerations

For detailed instructions on how to use it see the Related Links section at the bottom of the page.

Custom Text

This MOD contains custom text in both cust_text.php and a cp_text.php file in the English / English-UTF8 folders. A French version of the custom text is available in the download section in the top right hand corner of the page.


TNG version: 10.1.0

The TNG 10.1 version of the mod will now use the English/cp_text.php if the other language cp_text.php is not found.

cust_text.php

The following custom text entries need to be created in your language, if you do not use English for TNG Admin

// Added for TNG Admin by the Census Plus International mod
$admtext['cenplus'] = 'Census Plus International';
$admtext['cpitems'] = 'Find | Add | Edit | Delete | Import | Update | Link IDs | Image';
$admtext['cpedit'] = 'Edit';
$admtext['cpbase'] = 'Census Plus Base';
$admtext['cpdata'] = 'Census Plus Data';
$admtext['cplink'] = 'Census Plus Links';
$admtext['cpsummary'] = 'Census Plus Summary';
$admtext['cpveteran'] = 'Census Plus Veteran';
$admtext['checkcensus'] = 'Check Census Links';
$admtext['cpeventIDsupdated'] = 'Census Event IDs were updated in the CP Link Table.';
$admtext['cpeventIDsOK'] = 'CP Link Table integrity is OK - no changes were made to event IDs.';
$admtext['cplinknoevent'] = 'links do not have a Census Event created, or the event type, or the date has changed.';
$admtext['cpfixdesktop'] = 'To fix this you need to update your desktop genealogy program to add the Census Event fact for the Census Year to Person ID indicated.';
$admtext['cpimportnew'] = 'Then export a GEDCOM and import your updated GEDCOM.';
$admtext['cpselecttree'] = 'You must select a Tree to proceed with the census link check.';
$text['findcpperson'] = 'Find personID to be linked';

cp_text.php

Likewise if you do not use English for TNG Admin, you need to copy the English/cp_text.php file to your language folder and translate as appropriate.

The censusplus_v12.0.0.10_lang.zip mod can be used to add the Danish-UTF8, French, French-UTF8, German-UTF8, and Norwegian-UTF8 cp_text.php language files

Only the section of cp_text.php marked as Text that should be translated for public side of Census Plus International needs to be translated if you use English for your TNG Admin

Restrictions

  • If you import a GEDCOM as a way of supporting your web site, you must define the Census events (or facts) in your desktop genealogy program so you do not lose the events on a GEDCOM import
v9104 added a Check Census Links button to the Import Secondary Process that allows checking that you have all the correct Census Events in your desktop
  • The image file name in the census folder must be in the following format dbid=6743&iid=4241561-00594.jpg that matches the ancestryID column in the cp_base and cp_data database tables
You can use other file names provided you update the Image URL using the Image tab
  • The household number must be the same for all members in a household.
    • If a family crosses images, where the Head of household is at the bottom of one page, and part of the family is at the top of the next page, you must enter the same household number for both transcript sources when assigning household numbers.
    • If you link to Family Census events, there is NO way the mod can display both census images, since it is designed to work with Individual Census events
  • for multi-language support to work, you must use either the CENS tag or the description must contain census in the TNG Event Type
  • if you want to use Family Census event, then you
  • you cannot add more than 50 lines to a census transcript
this restriction is imposed by PHP not allowing more than 1000 input fields
the household summary type census allow more than 50 lines
  • Household that are split within a Census Year must use the same household number and the Transcript ID must be sequential.
Imported census will be sequential, so the restriction is related to manually added census transcripts.
The code in v9104 Add was updated to support adding a page before or after

Known Issues

  • Ancestry Import no longer works in v14.0.0.13 and v14.0.1.313a versions of the mod
  • Ancestry DOM source of the index might not contain any column labels
    use the Add tab and manually add the census transcript for this census
  • Ancestry Import no longer works in v11.0.0.0 and v10.0.0.3 versions of the mod
    upgrade to v11.0.2.5, v11.0.0.5, or v10.1.0.5 of the mod
    mod is no longer supported on TNG v10.0.3 and before
  • Template 5 width in some cases, like the 1830 and 1840 transcripts with household summary counts will generated table entries that exceed the page content width
You will need to increase the width for maintable class to something like 1100 px
  • Template 16 width needs to be increased to eliminate overflow
You will need to increase the width for #tpage class to something like width: 85%; to resolve the overflow on the getperson.php page
You may need to increase the width for #tpage class to something like width: 95%; to resolve the overflow on the cpdisplay.php page
  • Display on iPad or tablets where the screen width is 1024 will cause the Census Plus transcript display on the Individual (getperson.php) page to exceed the page boundary
  • Census Transcript only displays heading line and no data lines.
Select the Transcript link, and then click on Go to Update All button and update the location. If the location looks OK the just Save the Update to update the location in both the CP Base and Data records.
  • CP Veteran table uses rank as a column name which is a reserved word in MySQL 8
Versions prior to v12.0.0.10 will not install or work with MySQL 8

Revision History

Version Date Contents
14.0.1.13c 18 Sep 2023 Updated to eliminate PHP Notice and keep mod numbers in sync with change required to Media-Census Plus International to eliminate conflict with Hide private and living mod
14.0.1.13b 6 Jul 2023 Updated for TNG v14.0.1 thanks to Michael T Jones to
  • fix import from Ancestry
  • fix issue with link to Ancestry image
14.0.1.13a 19 April 2023 Updated for TNG v14.0.1 to
  • fix issue where multiple cp_base records were created but not used when using Add tab
  • fix issue with Delete having an empty transcriptID
  • fix transcript display to show fields that contain no data
14.0.1.13 20 February 2023 Updated for TNG v14.0.1 to
  • removed $flags['tabs'] = $tngconfig['tabs'] which is obsolete in TNG 14.0.1
  • fix Add Image dialog
  • fix micro_cpinclude to display No Image if
    • transcript image file does not exist
    • if censusurl is empty (thanks to Paul Rolfe for reporting the issue)
  • remove code that attempted to convert censusurl
if Ancestry censusurl is not correct, you will need to run the update buttons in the Mod Description section
  • fix US Summary and Other Summary count displays on the Individual transcript display (getperson.php micro_cpinclude) (thanks to Allen Prunty for reporting the issue)
  • added
    to several scripts to allow all fields to be displayed / entered / edited
  • fix Add tab cpcreate.php to add missing SubDist input field in 1921 UK Census (thanks to Paul Rolfe for reporting the issue)
  • fix Census Link check in Post Import Utilities to use language strings
  • fix several PHP 8.2 warnings
14.0.0.13a 7 January 2023 Updated to resolve the conflict with Create Site Map Mod in TNG v14. No other code changes made
14.0.0.13 28 Sep 2022 Updated for TNG v14
13.0.0.13 26 Sep 2022 Published the beta code. Thanks for everyone's patience during beta testing
13.0.0.13_r1 2 Sep 2022 with collaberation between Brent Hemphill and Ken Roy

Our thanks to Brent, Mark Kosinski, Regis Carr, Marc Irish and Svein Erik for testing the changes

  • updated Ancestry and TNG urls to use https
  • updated Ancestry search URL to new format
  • converted censusurl from http:interactive to imageviewer/collections/dbid/images/iid
    skip this update if manually added transcript
  • updated US Veteran Schedule to US Veterans Schedule
  • updated format field in cp_base record to correct format
  • changed format for US Veterans Schedule to US Veteran
  • changed US Summary to US Veteran for 1890 US Veterans Schedule
  • updated series field in cp_base table
  • removed unnecessary comment lines in all modules
  • updated some scripts to use variables instead of hard-code cp table names* only retrieve cp_summary table data when needed
  • only retrieve cp_veteran table data when needed
    • to eliminate high CPU usage
    • to eliminate large data retrieval
  • fixed import for 1910 census using grid-row format
  • updated cp_label table
  • removed comments added when converting queries to PDO
  • updated TNG Wiki article to indicate
    • cp_tables must be created in TNG database and not WP db
  • updated cpcreate.php to check if first transcript being added
    to fix cpbaseID = 0 being generated for autoincrement ID
  • updated cpdisplay.php, cphouseholdupdate.php, and cpupdate.php to not generate censusurl for manually added transcripts
13.0.0.13_b1 31 May 2022 with collaberation between Brent Hemphill and Ken Roy

Our thanks to Brent and Mark Kosinski for alpha testing the changes

  • added 1950 US Census
  • added 1921 UK Census
  • added link to Dr Stephen Morse ED finder in the Add tab for US census
  • Brent fixed the Import when adding the 1950 US Census import
  • fixed the import to import the high lighted family (green-bg)
  • fixed the import to import the high lighter person (yellow-bg)
  • fixed the cpupdate.php script to eliminate PHP warnings if CP Base ID does not exist such as after a census is deleted
  • fixed the cpfind2linkID.php script to eliminate PHP warnings if the CP Base ID does not exist such as after a census is deleted
  • fixed several other PHP 8.1 errors
13.0.0.12a 8 Jan 2022 Resolved conflict with Age at event by switching to triminsert instructions and fixed PHP 8 warning in Add Image tab in conjunction with Michel Kirsch, Brent Hemphill and Ken Roy
13.0.0.12 1 Dec 2021 Published the 13.0.0.12-rc1 version with major code changes made to eliminate PHP 8 warnings by Brent Hemphill and Ken Roy
13.0.0.12-rc1 18 Oct 2021 Major code changes were made to eliminate PHP 8 warnings by Brent Hemphill and Ken Roy
13.0.4.11 9 Jun 2021 Updated for TNG 13.0.4. If you are using the Alternate Spellings mod, it must be installed after the Census Plus International mod
v13.0.0.11 17 Sep 2020 Updated to
  • work with TNG 13 new Admin Layout (Note with v12.0.0.10a shows as OK to Install it will not work in the TNG 13 Admin screens)
  • fix Image URL to Ancestry to use their new URL format (../imageviewer/collections/nnnn/images/image_ID
  • re-instate code from v12.0.0.9 on how Return All and Return all linked for Media options are processed
  • fix several PHP warnings about undefined variables and indexes
  • NOTE that the Import no longer works since Ancestry has changed their DOM Source generation
12.0.0.10a 20 Jul 2019 Updated to
  • fix PHP 7.1 warnings Cannot assign an empty string to a string offset in cpdisplay.php and cpupdate.php
    caused by the Sosa mod v12.0.2.2-rev3 now putting its code snippet in customconfig.php
  • fix censusYear ambiguous error if Return All is set to default(n)
  • re-instate code from v12.0.0.9 on how Return All and Return all linked for Media options are processed
  • fix 1890 US Veteran display works with Return All in getperson.php and Return all linked in showmedia.php transcript display

Our thanks to Brent Hemphill for some of the fixes and to Rick Hooley and John Jamieson for beta testing

12.0.0.10 11 Jul 2019 Updated to
  • fix additional PHP 7.2.14 and 7.3.1 warnings
  • change Import Secondary process Check Census Links in an attempt to fix MySQL execution time outs
  • change rank to milrank in cp_veterans table for MySQL 8
  • fix processing to ignore new index columns in Ancestry DOM source import
  • change hard-coded text to use variables in CP Link to create / edit US Veteran table
  • change copy / paste of common code in cpinclude.php to media_cpinclude.php to use include micro_cpinclude.php
  • fix 1890 US Veteran display on getperson.php and showmedia.php
  • fix 1840 US Census summary display on getperson.php and showmedia.php

Our thanks to Brent Hemphill for the code change to the Import Secondary process Check Census Links and for testing the use of additional CP Link indexes that did not help and so were not implemented

12.0.0.9 1 May 2019 Updated to
  • fix several PHP 7.2.14 and 7.3.1 warnings
  • change the include(begin.php) with other includes to use include(tng_begin.php) to fix the fatal error in tng_header in several scripts
  • change the CP Update to save the format as US Summary for the 1890 US Veteran Schedule so it displays correctly on Individual page
  • fix the CP Import to recognize another Ancestry DOM source change
  • fix the CP Import to also imported the high-lighted household
  • add a mysqli_close to the CP Display to hopefully prevent the query from being put to sleep

Our thanks to Les Campbell and Carlton Brooks for beta testing this version of the mod

12.0.0.8a 23 Oct 2018 Updated to fix the import of rows that match search match
12.0.0.8 21 Oct 2018 Terminate the import with new messages if the Ancestry DOM source does not contain any column header labels
12.0.0.7d 16 Sep 2018 Added new fields to the CP Label table for UK 1841 and 1891 census imports
12.0.0.7c 24 Jul 2018 Fixed Import Secondary Process, Check Census Links to detect missing Census Events after an import
12.0.0.7b 20 Jul 2018 Fixed upgrade instructions in mod cfg file

Fixed warnings on unquoted variables in PHP 7.2.6

12.0.0.7a 23 May 2018 Fixed syntax error in cpcreate.php (Add tab)
12.0.0.7 1 May 2018 Updated for TNG v12
  • This version will now preserve the cp_settings.inc for the next upgrade
11.0.2.6c
11.0.0.6c
10.1.0.6c
5 Apr 2018 Fixed the following:
  • Fixed the Import, Secondary Check Census Link update query to reduce execution time on large tables, thanks to Mark Wonson
11.0.2.6b
11.0.0.6b
10.1.0.6b
13 Sep 2017 Fixed the following:
  • Added new cp_label columns for US 1880 Census (requires table update after install)
10.1.0.6 Languages 2 June 2017 Added the following languages to the original French language files to provide translations for getperson page display of Census Transcripts
  • Danish-UTF8 provided by Claus Martinussen
  • German-UTF8 provided by Vinzenz Lübben
  • Norwegian-UTF8 provided by Jan Holmbert
11.0.2.6a
11.0.0.6a
10.1.0.6a
24 May 2017 Fixed the following:
  • Added new cp_label columns for US 1900 Census (requires table update after install)
  • Fixed the Check Census code in admin_secondary.php so it works correctly if census are linked to more than one tree
11.0.2.6
11.0.0.6
10.1.0.6
25 March 2017 Fixed the following:
  • Removed the check for interactive viewer in DOM source that was erroneously indicating the DOM source is from the old viewer
  • Removed the household check when displaying the census transcript for the image or media display where more than one household is in the same census image
  • Added new cp_label column for Suffix (requires table update after install)
11.0.2.5c
11.0.0.5c
10.1.0.5c
25 November 2016 Added support for new URL structure that impacted the DOM source generation
11.0.2.5b
11.0.0.5b
10.1.0.5b
23 November 2016 Added support for yet a new DOM source generation
11.0.2.5a
11.0.0.5a
10.1.0.5a
17 November 2016 Fixed the following:
  • Corrected the Check Census Links counts in the Import Seconday Processes
  • Changed 1825 Census of Canada to a summary type census
  • Added support for new DOM source generation
11.0.2.5
11.0.0.5
10.1.0.5
26 September 2016 Fixed the following:
  • Fixed the CP Link ID to eliminate duplicate events being created
  • For TNG 11.0.2+ added support for $extspath variable that allows user to rename the extensions folder
11.0.0.4b
10.1.0.4b
20 July 2016 Fixed the following:
  • Updated dictionary for some Canadian Census column headings
  • Fixed the import so that utf8 to utf8 character conversion would not occur to avoid mangling accented characters
  • Fixed the import so that duplicate cp labels would be ignored and not produce an undefined index warning
  • Fixed the CP Link ID to create new census event and new place
  • Fixed Event Type queries so they work with foreign languages by checking both display and tag
11.0.0.4a
10.1.0.4a
24 May 2016 Fixed the following:
  • Updated dictionary for the 1830 column headings
  • Fixed the Create Tables for first time installs
  • Fixed missing text in Find screen
11.0.0.4
10.1.0.4
11 May 2016 Updated to use a dictionary approach for the Import from Ancestry, created by Janice Nation.

It is no longer necessary to select the series for the import.

11.0.0.0 18 March 2016 Updated for TNG V11, but Ancestry Import problem was NOT fixed
10.1.0.3g
10.0.0.2l
25 October 2015 Updates were made
  • for the US Census Import for 1920, 1930, and 1940 variations
  • for the UK Census Import for 1881 variations
  • for the person linking so it will use the correct tree and not overlay an existing census event
  • for the transcript update to update the location in both the cpbase and cpdata record
  • for importing the location in new DOM source. It still allows you to specify the location before doing the import
10.1.0.3f 5 September 2015 Updates were made
  • for the US Census Import for 1910 variations
  • for the UK Census Import for 1871 variations
  • for missing location in DOM source, which now allow you to specify the location before doing the import
Note that updates were not retrofitted to the previous version of the mod for TNG 10 to 10.0.3
10.1.0.3e 12 August 2015 Updates were made for the US Census Import for 1880, 1900, 1910, 1920, and 1940 variations
Note that updates were not retrofitted to the previous version of the mod for TNG 10 to 10.0.3
10.1.0.3d
10.0.0.2k
9 May 2015 The following updates were made:
  • updated US Census Import for 1910 variations
  • updated Census display on Individual page to check the treeID for persons linked to the census transcript
to fix links and/or census display not showing when linked to the wrong tree
  • updated Census Link to use the treeID when checking for existing census event links
so existing links are not overlaid with the same PersonID in a different tree
10.1.0.3c
10.0.0.2j
17 February 2015 The following updates were made:
  • updated US Census Import for 1920 variations
  • updated Census display on Individual page to not display the Years Married and Children Born/Living for mobile devices
10.1.0.3b
10.0.0.2i
11 February 2015 The following updates were made:
  • updated US Census Import for 1930 and 1940 variations
  • updated Census display on Individual page to correct the display when using the Display All Members of a Household option
10.1.0.3a 28 January 2015
  • Updated cfg file to indicate that if you have already created the CP Indices you should bypass that step. If you are already running v10.1.0.3 there is no reason to upgrade to this version. No code was changed.
10.1.0.3 25 January 2015
  • Removed the "or die" from the tng_query in the Import Secondary Process - Check Census Events
  • Added a debug message to the media_cpinclude.php
10.1.0.3beta 8 January 2015
  • Update for TNG 10.1 to use MySQLi and for Mod Manager syntax rule changes
  • Updated US Census Import to handle yet other different formats of the 1920 census
  • Updated to use English/cp_text.php file if language translations for cp_text.php file do not exist

See Census Plus International Revisions for previous revisions.

Visualization of this mod

See Census Plus International - Visualization

An Approach to Import

See Census Plus International - Import.

Uninstalling the mod

If you want to completely Remove (uninstall) this mod and all its tables, you should

  1. click the Drop Census Plus Tables button in the Mod Manager status screen for the mod to delete the census table before you
  2. click the Remove button to uninstall the mod and then
  3. click the Delete button to delete the config file from the mods folder.

If you are uninstalling the mod prior to an upgrade, you should only click the Uninstall button to uninstall the mod. You should not Drop Census Plus Tables nor Delete the mod since you will want to re-install the mod after the upgrade.

In the event of a problem

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
My Family History Marc Irish Beta tester - Fantastic Mod 13.0.0.13_b1 13.1.2 EN
Nation Study Janice Nation Developed dictionary and logic to use the DOM Source parser 11.0.0.4 12.1 EN
Our Roy and Boucher Family Ken Roy Repackaged and enhanced Census Feature mod 14.0.1.13c
TNG 14.0.4
EN,FR
Robison and Blythe Genealogy Jeff Robison code contributor. Created and uses the Add dialog to add census entries. 11.0.2.6 11.1.0 EN
McDonald Family (aka PFOP)
Pages From Our Past
Allen Prunty alpha/beta tester. - I think this mod rocks! (not a public site) 11.0.2.6 11.1.0 EN
MyFOOTDEEAncestors Mrs Montgomery 10.0.0.0 10.0.02 EN
Chamberlain and Eidenbenz Genealogy Graham Chamberlain Census linked to Family Census events. Data managed in desktop application. Beta tested v11.0.0.4 12.0.0.7 12.0.0 EN,DU,FR,DE,ES
Genealogy Cook Klaus Dieter Cook alpha tester. Uses Add, Other Census to enter Mexico census. 10.0.0.0 10.1.0 EN, GE, SP
Our Family Histories Bryan S. Larson alpha/beta tester 11.0.2.6b 11.1.2 EN
Feldman Family History Fred Feldman beta tester. 9.1.0.0 9.2.2 EN
Ancestral Stewart Family Tree Michael Stewart Public 9.1.0.0 9.2.2 English
Pimble One-Name Study Gerald A Cooke Not a Public Site. 9.1.0.0 9.1.0 EN
Wilder Connections P. Beth Adams Not a Public Site. 9.1.0.0 9.2.2 EN
Foster / Hartwell Dave Foster 10.0.0.1a 10.0.2 EN
The Schnetzka Family Stephen M Pritt 11.0.2.6 11.0.2 EN
Farnham & Paradise Ohana Barbara Paradise login: tngguest pwd: tngguest 10.0.0.0a 10.0.2 EN
The Duttons of New England Darrin Dutton Public / Private 13.0.0.11 13.0.2 EN
Hooley Family Links Rick Hooley Public/Private See Here See Here EN
Allen Family Dennis Allen 9.1.0.2 9.2.2 EN
Farrar Family Randy Farrar login: guest pwd: guest 9.1.0.3 9.2.2 EN
Carr Family Tree Regis Carr beta tested v10.1.0.4; XAMPP v12 w/ MOD v12.0.0.8a 14​.0​.1​.13c 14.0.3 EN
Oldham One Name Study Jan Oldham 10.0.0.1a 10.0.2 EN
Polys Family Genealogy David Polys 10.0.0.0 10.0.1 EN
Wagner Walton Genealogy Ben Wagner Not a Public Site. 10.0.0.2c 10.0.0 EN
DJCM.DK Claus Martinussen Not a Public Site. 13.0.4.11 13.0.4 DA, EN
Mackay / McCoy / McKee YDNA Surname Project Greg Roberts Public Site. 10.1.0.3c 10.1.0 EN
Roni & Jerry's Genealogy and Family History Jerry Liebowitz Public Site. Censuses linked mainly to family census event. NY State censuses added, too. 10.1.0.3c 10.1.0 EN
Brady Family Tree in Western Australia Darryl Brady Public site 10.1.0.3g 10.1.1 EN, DE
Ewbank, Smith & Hall Family Ron Hall 10.1.0.3e 10.1.2 EN
Four Branches Genealogy Mark Kosinski beta tested 12.0.0.10a 12.1.0 EN
Conjunctions: Genealogy at the Crossroads Rosina Lippi 11.0.0.4 11.0.1 EN
From Tea to Tumbleweeds Trudy Lusk Private site 11.0.0.4b 11.0.1 EN
Hammitt Roots Susan Private site 11.0.2.5 11.0.2 EN
Roebuck and Families Ancestry Website Donald Roebuck Public site except for Living 11.0.2.5c 11.0.2 EN
Bussiere, Robinson, Gingras Website Brian Bussiere Public site 10.1.3 10.1.0.5 EN, FR
Crawford County Genealogy Gateway Frank Bernosky Public site 11.0.2.6a 11.1.1 EN
Porterfield Junction George Porterfield Not a public site 10.1.0.6 10.1.2 EN
Rodriguez Lopez y Uribe Senior pagina de Genealogia Camilo Rodriguez Uribe 11.0.2.6 11.0.2 SP, EN
Whipple, White, Nelson & Duncan Families Steven Whipple 11.0.2.6 11.1.0 EN, DA, GE, SP, NE, FR, IT, and others
Hans and Hennes Families Roar Dahle 11.0.2.6 11.1.0 NO
MyMispoche Carlton Brooks 12.0.0.10a 12.1.0 EN
The Pettit Forest Robert Pettit 11.0.2.6 11.0.2 EN
Family History and Ancestry Jay Santos 12.0.0.10 12.0.3 EN
Familien Holmberg Jan Roger Holmberg 11.0.2.6 11.1.0 NO
Rintoul/Bowman Family Andrew Rintoul Public/Private 12.0.0.7 12.0 EN, DE, ES, FR
Byberry Waltons Bill Walton Not a public site 11.0.2.6 11.0.2 EN
OurLife Family History - McMullen Clan Sean Thompson Not a public site. 11.0.2.6 11.1.0 EN
http://wiiaas.no/ Arnfinn Wiik Not a public site. 11.0.2.6 11.1.0 NO
Geeky Genealogist Wendy Allen 11.0.2.6 11.1.0 EN
The Larlee Genealogy Heather Feuerhelm 11.0.2.6 11.1.0 EN
Wilton, Brimson, Munro and Forward Families Sharon Lewis 11.0.2.6 11.1.0 EN
Bunkers Dolan Family Tami Dolan 11.0.2.6 11.1.0 EN
A Family Journey Roger Williams 12.0.0.8 11.1.0 EN
DiFava / Brandt Family History Larry DiFava 11.0.2.6 11.1.0 EN
Ancestral Stewart Family Tree Michael Stewart 11.0.2.6a 11.1.1 EN
Total Family History Scott Bennett Not a public site 11.0.2.6a 11.1.1 EN
SiEiNo's slekt på Internett Eilif A Nordseth Not a public site 11.0.2.6a 11.1.1 EN, NO
Pepperrell and Clarke Family Phillip Pepperrell 11.0.2.6a 11.1.1 EN
Steigerwald - McManus - Hite Kaeslingk - Gaffga Families Ricarda Steigerwald 11.0.2.6a 11.1.1 EN
Vår families slektssider Jahn Edgar Michelsen Not a public site 11.0.2.6a 11.1.1 NO, EN
Our Acadian Family Randal Suire Public/Media Private 12.0.0.7d 12.0.1 EN, FR
Hannigan History Pages John Hannagan Public/Media Private 12.0.0.7a 12.0.0 EN
Lloyd & Lucas - A Merging of Interests Chris Lloyd Public site 12.0.0.8 12.0.1 EN
Gambrill Family Tree Bobby Gambrill Public site 12.0.0.9 12.2 EN
Porterfield Junction George Porterfield Private site 12.0.0.8a 12.0.3 EN
vanheerden.net Emile Private site 12.0.0.10 12.1 EN
Some Jamesons John Jameson 12.0.0.10a 12.1 EN
Our Family Tree Search Jessica Senkyr-Robinette Private Site 12.0.0.8a 12.0.2 EN
Kilkie Family Tree Martin Kilkie Private site, guest login: guest pwd: guest 12.0.0.8a 12.0.2 EN
Peek at out Family Ashley Peek 14​.0​.1​.13 14.0.1 EN

TNG Modules Impacted

You can click on the [Expand] link on the right to display the list of TNG Modules change and the [Collapse] link to hide this section again.

The following TNG Modules are modified, and should be backed up prior to installing this mod:

  • css/genstyle.css
  • css/tngtabs1.css
  • templates/template1/css/templatestyle.css
  • templates/template2/css/templatestyle.css
  • templates/template3/css/templatestyle.css
  • templates/template4/css/templatestyle.css
  • templates/template5/css/templatestyle.css
  • templates/template6/css/templatestyle.css
  • templates/template7/css/templatestyle.css
  • templates/template8/css/templatestyle.css
  • templates/template9/css/templatestyle.css
  • templates/template10/css/templatestyle.css
  • templates/template11/css/templatestyle.css
  • templates/template1/css/tngtabs1.css
  • templates/template2/css/tngtabs1.css
  • templates/template3/css/tngtabs1.css
  • templates/template4/css/tngtabs1.css
  • templates/template5/css/tngtabs1.css
  • templates/template6/css/tngtabs1.css
  • templates/template7/css/tngtabs1.css
  • templates/template8/css/tngtabs1.css
  • templates/template9/css/tngtabs1.css
  • templates/template10/css/tngtabs1.css
  • templates/template11/css/tngtabs1.css
  • personlib.php
  • admin_merge.php
  • languages/English/cust_text.php
  • languages/English-UTF8/cust_text.php
  • customconfig.php
  • admin_deleteevent.php
  • admin_genconfig.php
  • admin_utilities.php
  • admin_backup.php
  • admin_optimize.php
  • admin_restore.php
  • ajx_delete.php
  • deletelib.php
  • treelib.php

The following modules are added by this mod to provide options on how the mod behaves

  • extensions/cp_settings.inc
TNG version: 13.0.0
In TNG V13 and later, this mod modifies the following files:
  • admin_leftmenu.php
  • admin.php
TNG version: 12.3.0
TNG version: 9.1.0
In TNG V9.1 and later, this mod modifies the following files:
  • admin_leftbanner.php
  • admin_main.php

Related Links

Census Plus International mod

Using_the_Census_Plus_Mod

Census Plus International - Options

Census Plus International - Find

Census Plus International - Add

Census Plus International - Edit

Census Plus International - Delete

Census Plus International - Import

Census Plus International - Update

Census Plus International - Link IDs

Census Plus International - Image

Census Plus International - Restore

Census Plus International - Styles

Census Plus International - SQL Reports

Census Plus International - Census Events

Census Plus considerations when using TNG only

Census Plus considerations when importing GEDCOM

Census Plus International and Family Census

Census Plus International - Source Citation

Media - Census Plus International mod