Census Plus International

From TNG_Wiki
Revision as of 10:52, 25 March 2017 by KenRoy (talk | contribs) (Revision History)

Jump to: navigation, search
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 are having trouble downloading with the Google Chrome browser, try another browser Caution

Ambox notice.png 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.

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.

TNG 10.1.0

Census Plus International
Summary Adds international census record data for Households on individual Info page
Mod Updated {{{mod_last_update}}}
Download link Import from Ancestry supported
TNG 11.0.2
TNG 11.0
TNG 10.1.0
Import from Ancestry NOT supported
TNG 10.0
French Language Files
TNG 9.1
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 for TNG 11.0.2 for TNG 11 for TNG 10.1 and later for TNG V10 for TNG v9.1 and above
Min TNG V 9.1.0
Max TNG V 11+
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.
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.


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

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.

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
  • 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


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)
  • An installed current version of the Mod Manager (is already included in TNG v9)
  • 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


  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.

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 Indices 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.


To versions

If upgrading to,, or 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_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 or 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)

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
    • Upgrading from Census Plus International
    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.

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.


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';


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.

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


  • 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 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
  • 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.

Revision History

Version Date Contents
March 2017 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)

25 November 2016 Added support for new URL structure that impacted the DOM source generation
23 November 2016 Added support for yet a new DOM source generation
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
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


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


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 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.

v11.0.0.0 18 March 2016 Updated for TNG V11, but Ancestry Import problem was NOT fixed
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
v10.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
v10.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
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
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
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
v10.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.
v10.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
v10.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
Nation Study Janice Nation Developed dictionary and logic to use the DOM Source parser 11.0.1 English
Our Roy and Boucher Family Ken Roy Repackaged and enhanced Census Feature mod 11.0.2 English,French
Robison and Blythe Genealogy Jeff Robison code contributor. Created and uses the Add dialog to add census entries. 10.0.3 English
McDonald Family (aka PFOP)

Pages From Our Past

Allen Prunty alpha/beta tester. - I think this mod rocks! 10.1.0 English
MyFOOTDEEAncestors Mrs Montgomery 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 11.0.2 English,Dutch,French,German,Spanish
Genealogy Cook Klaus Dieter Cook alpha tester. Uses Add, Other Census to enter Mexico census. Guest access login: guest pwd: guest 10.0.0 English,German,Spanish
Our Family Histories Bryan S. Larson alpha/beta tester 10.0.3 English
Feldman Family History Fred Feldman beta tester. 9.2.2 English
Ancestral Stewart Family Tree Michael Stewart Public 9.2.2 English
Pimble One-Name Study Gerald A Cooke Not a Public Site. 9.1.0 English
Wilder Connections P. Beth Adams Not a Public Site. 9.2.2 English
Foster / Hartwell Dave Foster 10.0.2 English
The Schnetzka Family Stephen M Pritt 10.1.1 English
Farnham & Paradise Ohana Barbara Paradise login: tngguest pwd: tngguest 10.0.2 English
The Dutton's of Vermont Darrin Dutton Public Site 11.0.1 English
Hooley Family Links Rick Hooley Public Site 10.1.1 English
Allen Family Dennis Allen 9.2.2 English
Farrar Family Randy Farrar login: guest pwd: guest 9.2.2 English
Carr Family Tree Regis Carr beta tested v10.1.0.4 10.1.2 English
Oldham One Name Study Jan Oldham 10.0.2 English
Polys Family Genealogy David Polys 10.0.1 English
Wagner Walton Genealogy Ben Wagner Not a Public Site. 10.0.0 English
DJCM.DK Claus Martinussen Public Site. 11.0.0 Danish, English
Mackay / McCoy / McKee YDNA Surname Project Greg Roberts Public Site. 10.1.0 English
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 English
Brady Family Tree in Western Australia Darryl Brady Public site 10.1.1 EN, DE
Ewbank, Smith & Hall Family Ron Hall 10.1.2 EN
Four Branches Genealogy Mark Kosinski beta tested v11.0.0.4 11.0.1 English
Conjunctions: Genealogy at the Crossroads Rosina Lippi 11.0.1 English
From Tea to Tumbleweeds Trudy Lusk Private site 11.0.1 English
Hammitt Roots Susan Private site 11.0.2 English
Roebuck and Families Ancestry Website Donald Roebuck Public site except for Living 11.0.2 English
Bussiere, Robinson, Gingras Website Brian Bussiere Public site 10.1.3 English, French
Crawford County Genealogy Gateway Frank Bernosky Public site 11.1 English

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
  • admin_main.php
  • admin_leftbanner.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

Related Links

Census Plus International 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