Cookies help us deliver our services. By using our services, you agree to our use of cookies.


Jump to: navigation, search

Census Plus International

6,192 bytes added, 20:32, 13 October 2019
no edit summary
{{restricted}}{{V12_cust_text}}{{TNGver| ver = 10.1.0 1010120|notes= <span style="color:red">'''Note that recently Ancestry is generating some index with no column headings, thus there are no column headings in the DOM source. <br />You may have no option other than using the Add tab to manually add the census transcript in those cases.'''</span>.<br />The new versions v12.0.0.10a of the mod are is only supported on TNG 10.1 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 />The v10.1.0.4 and v11<span style="color:red">'''NOTE: Only v12.0.0.4 versions of the mod use a new Census Plus Label Dictionary10a supports MySQL 8 environments. 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>
| mod_summary = Adds international census record data for Households on individual Info page
| mod_validation =
| mod_last_update = 1 May 201820 Jul 2019| download_link = Import from Ancestry supported<br />for {{Tv120}} [http{{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}}]<br />[http{{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}}]<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}} [http{{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}}]<hr /></div>Expand for older versions<div classstyle='mw-collapsible mw-collapsedoverflow:none'>for {{Tv110}} [http{{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}}]<hr /></div><div style='overflow:none'>for {{Tv1010}} [http{{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}}]<hr /></div>Import from Ancestry NOT supported<br /><div style='overflow:none'>for {{Tv100}}[{{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}}]<br/></div><div style='overflow:none'>for {{Tv1102}}{{Tv110}}{{Tv1010}}[{{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} v10.1.0.6 Languages]<br /></div><div style='overflow:none'>[{{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} French Language Files]<hr /></div><div style='overflow:none'>for {{Tv91}}[{{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}}]<hr /></div> <div style='overflow:none'>[{{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}}] <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 = [ View download statistics]
| mod_author = Janice Nation, Jeff Robison, and Ken Roy
| mod_support = [ TNG Forums]
| mod_contact =
| mod_version = 10a for TNG 12+<br /> for TNG 11.0.2+<br /> for TNG 11<br /> for TNG 10.1+<br /> for TNG V10<br /> for TNG v9.1 and above
| min_TNG_ver = 9.1.0
| max_TNG_ver = 12+
| 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
<!-- v12.0.0.10 Languages file = -->
<!-- v10.1.0.6 Languages file = Censusplus v10.1.0.6 -->
<!-- French language file = -->
<!-- French language file = -->
<!-- French language file = -->
{|style="margin-right:0.5 em;" align="right" |__TOC__
== Purpose of the mod ==
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.
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
== Requirements ==
{{TNG 12.0|and after}}
* the v12.0.0.10 version of the mod is the only version that supports MySQL 8
: previous versions of the mod do not support MySQL 8
{{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
# 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.
#: The provides the Danish-UTF8, French, French-UTF8, German-UTF8, and Norwegian-UTF8 cp_text.php files
=== 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 IndicesINDEXes''' 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.
=== Upgrading ===
==== from any .4/.5 /.6/.7/.8/.9 ====
If upgrading to versions from * any versions* any versions* any versions* any,, or versions from * from any,, or or * from any,, or 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_v11026 censusplus_v120010 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.6 and v10.1.0.6
# Install the new Census Plus International version of the mod
# Update the CPI Label table
# Update the CPI Veteran table
==== from other versions ====
:: If already created, clicking this button will return a Cannot execute query
::(#1061 - Duplicate key name 'BaseID' if you run it in phpMyAdmin)
# Update the CPI Veteran table
==== To previous versions ====
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 [{{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}}] 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
== Known Issues ==
* 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
* 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>
* 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
* 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 ==
! Date
! Contents
|- valign="top"
| v12.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"
| v12.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"
| v12.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
| v12.0.0.8a
| 23 Oct 2018
| Updated to fix the import of rows that match search match
| v12.0.0.8
| 21 Oct 2018
| Terminate the import with new messages if the Ancestry DOM source does not contain any column header labels
| v12.0.0.7d
| 16 Sep 2018
| Added new fields to the CP Label table for UK 1841 and 1891 census imports
| v12.0.0.7c
| 24 Jul 2018
| Fixed Import Secondary Process, Check Census Links to detect missing Census Events after an import
| v12.0.0.7b
| 20 Jul 2018
| Fixed upgrade instructions in mod cfg file<br />
Fixed warnings on unquoted variables in PHP 7.2.6
| v12.0.0.7a
| 23 May 2018
| Fixed syntax error in cpcreate.php (Add tab)
| v12.0.0.7
| Developed dictionary and logic to use the DOM Source parser
| 11.012.1
| English
| [[User:Ken Roy|Ken Roy]]
| Repackaged and enhanced Census Feature mod
|| 12.01.0
| English, French
| [ Hooley Family Links]
| [[User:lastejas|Rick Hooley]]
| loginPublic/Private| [[User: guest pwd: guestlastejas|See Here]]|[[User: lastejas| 11.1.1See Here]]| EnglishEN
| [ Allen Family]
| [ Carr Family Tree]
| [[User:Regis Carr|Regis Carr]]| beta tested v10.1.0.4; XAMPP v12 w/ MOD v12.0.0.8a|
| 10.1.2
| English
| Claus Martinussen
| Public Site.
| 1112.0.0.0 8a | 1112.0.03
| Danish, English
| EN
| [httphttps://gen.markkosinskifourbranches.comorg/ Four Branches Genealogy]
| Mark Kosinski
| beta tested v11.0.0.4| 1112.0.20.610a| 1112.1.0
| English
| [[User:Carltonb|Carlton Brooks]]
| 1112.0.20.610a| 1112.1.0.2
| English
| [[User:FifthEditon|Jay Santos]]
| 1112.0.20.610| 1112.10.03
| English
| Norwegian
| [http Rintoul/Bowman Family]
| [[User:Adrintoul|Andrew Rintoul]]
| Public/Private
| 1112.0.20.6b7| 1112.1.20
| EN, DE, ES, FR
| [[User:Roger NZ|Roger Williams]]
| 1112.0.20.68
| 11.1.0
| English
| Norwegian, English
| [ Our Acadian Family]
| [[User:Randal Suire|Randal Suire]]
| Public/Media Private
| 1112.0.20.6a7d| 1112.10.1
| English, French
| [ Hannigan History Pages]
| John Hannagan
| Public/Media Private
| 12.0.0
| English
| [ Lloyd & Lucas - A Merging of Interests]
| [[User:ChrisLnz|Chris Lloyd]]
| Public site
| 12.0.1
| (EN)
| [ Gambrill Family Tree]
| [[User:bobbyfamilytree|Bobby Gambrill]]
| Public site
| 12.2
| (EN)
| [ Porterfield Junction]
| George Porterfield
| Private site
| 12.0.3
| English
| []
| [[User:emile01|Emile]]
| Private site
| 12.1
| English
| [ Some Jamesons]
| [[User:Jaj|John Jameson ]]
| 12.1
| English
| [ Our Family Tree Search]
| [[User:JessSenk|Jessica Senkyr-Robinette ]]
| Private Site
| 12.0.2
| English

Navigation menu