Census Plus International Revisions

From TNG_Wiki
Jump to: navigation, search

Previous Revision History

The following is the previous revision history for the Census Plus International mod. Moved here to reduce the size of the page.

Version Date Contents
v10.0.0.2h 8 January 2015 Updated US Census Import to handle yet other different formats of the 1920 and 1940 census
v10.0.0.2g 27 December 2014 Updated US Census Import to handle yet a several different formats of the 1920 and 1940 census
v10.0.0.2f 30 October 2014 Updated US Census Import to handle yet a different format of the 1920 census
v10.0.0.2e 7 October 2014 Updated US Census Import to handle yet a different format of the 1920 census
v10.0.0.2d 28 September 2014 Removed include of language/text.php which was causing overlay of cust_text.php in CP Include display on Individual page
v10.0.0.2c 19 September 2014 Updated US Census Import to handle yet a different format of the 1920 census
v10.0.0.2b 6 September 2014 Updated US Census Import to handle yet a different format of the 1920 census
v10.0.0.2a 25 August 2014 The following updates were made:
  • updated US Census Import to handle two different formats of the 1920 census
  • updated US Census Import to handle a different format of the 1940 census
v10.0.0.2 25 Jun 2014 The following updates were made:
  • updated all census imports to verify the interactive viewer differently
  • updated CP Import for US Census to handle different DOM source formats for 1860 census
  • added new messages on interactive viewer verification
v10.0.0.1a 23 Jun 2014 The following updates were made:
  • updated all census imports to capture the Collection ID and Image ID differently
removing the restriction that Next and Prev buttons cannot be used to get the next or previous census page
  • updated CP Include to correctly display the Image link for 1851 or basic Census of Canada
  • updated CP Import for UK Census to handle different DOM source formats for 1851 census
v10.0.0.1 16 Jun 2014 The following updates were made:
  • updated all census imports to handled new Ancestry DOM source format
  • updated CP Display to correctly display Census of Canada columns
  • updated CP Update to allow update of Census of Canada columns
  • updated CP Import for Census of Canada to handle different DOM source formats for 1921 census
  • added a script to create indices to eliminate the Max_Join_Row error
v10.0.0.0a 10 April 2014 The following fixes and changes were made in this update:
  • updated the import scripts for US Census to correctly recognize the Occupation field in some 1940 census
  • updated the CP Link script to add the location to the TNG Places table when the location does not exist
Note that this impacts users who use TNG only more since those who do Import Data would replace the Census Event location and TNG will create the missing location in the TNG Places table on import
  • updated the CP Include script to drop the Veteran and Street columns for the 1900 and 1910 census so the transcript fits on a laptop screen display and since the fields cannot be updated
v10.0.0.0 8 Feb 2014 The following updates were made:
  • updated for TNG V10 Admin menu change
  • dropped the mods to the template tngtabs1.css files since they are now part of TNG V10
  • updated the CP Make Tables for First Time installs to create the tables correctly
  • updated the CP Transcript included on the Individual page to display less data on mobile and tablet devices
  • updated the Import scripts for the Census of Canada, UK, US, and US veteran censuses to handle the latest changes to the DOM Source
  • fixed the Import scripts for the UK Census to find the field differences correctly
  • updated the import scripts for for the Census of Canada, UK, US, and US veteran censuses to find the Transcript ID in the DOM Source
  • updated the CP Transcript display to find the household that crosses a page boundary when the Transcript ID increments from 199 to 200 for example
  • added templatestyle.css for templates 13 and 14
  • updated templatestyle.css for templates 5, 11, 13, and 14 transcript displays fit on 1366 wide screen (laptop)
  • updated Admin General Settings for new table layout in TNG V10
v9.1.0.4e 10 April 2014 The following fixes and changes were made in this update:
  • updated the import scripts for US Census to correctly recognize the Occupation field in some 1940 census
  • updated the CP Link script to add the location to the TNG Places table when the location does not exist
Note that this impacts users who use TNG only more since those who do a Import Data would replace the Census Event location and TNG will create the missing location in the TNG Places table on import
v10.0.0.0 8 Feb 2014 The following updates were made:
  • updated for TNG V10 Admin menu change
  • dropped the mods to the template tngtabs1.css files since they are now part of TNG V10
  • updated the CP Make Tables for First Time installs to create the tables correctly
  • updated the CP Transcript included on the Individual page to display less data on mobile and tablet devices
  • updated the Import scripts for the Census of Canada, UK, US, and US veteran censuses to handle the latest changes to the DOM Source
  • fixed the Import scripts for the UK Census to find the field differences correctly
  • updated the import scripts for for the Census of Canada, UK, US, and US veteran censuses to find the Transcript ID in the DOM Source
  • updated the CP Transcript display to find the household that crosses a page boundary when the Transcript ID increments from 199 to 200 for example
  • added templatestyle.css for templates 13 and 14
  • updated templatestyle.css for templates 5, 11, 13, and 14 transcript displays fit on 1366 wide screen (laptop)
  • updated Admin General Settings for new table layout in TNG V10
v9.1.0.4d 5 Feb 2014 The following fixes and changes were made in this update:
  • updated the import scripts for for the Census of Canada, UK, US, and US veteran censuses to find the Transcript ID in the DOM Source
  • updated the CP Transcript display to find the household that crosses a page boundary when the Transcript ID increments from 199 to 200 for example
v9.1.0.4c 18 Jan 2014 The following fixes and changes were made in this update:
  • fixed the CP Make Tables for first time installs to create the tables correctly
  • fixed the font size CP Transcript display for US 1900/1920 census Children Born/Living
  • updated the Import scripts for the Cencus of Canada, UK, US, and US vetearn censuses to handle the latest changes to the DOM Source
  • fixed the Import scripts for the UK Census to find the field differences correctly in the 1911 census
v9.1.0.4b 30 Dec 2013 The following fixes and changes were made in this update:
  • fixed the CPI Image tab to not display the variable in the input fields if accessed directly
  • fixed the Extended Census Event Find to allow for the 1921 Census in the missing years for Canada
  • added the Enumerated date to the Census Plus transcript reference display and added label tag formatting
  • repeated the table headers for Other Full, Other Basic, and Other Summary formats if more than 25 detail lines
  • fixed the 1851 Census of Canada to handle 66 lines
  • added an ORDER BY lineno clause to the CP Display and Update to display the census transcript in the correct order
  • fixed the CP Check Table Integrity to update the eventIDs in the cp_link records correctly
  • fixed the Link PersonID in CP Display to pass the correctly selected Census Event
  • updated the scripts to use Other Basic for the 1851 Census of Canada
v9.1.0.4a 14 Dec 2013 The following fixes and changes were made in this update:
  • fixed the missing Add of the cplinkID column in the cp_summary record in the Census Plus Table update script
  • fixed the display of Enumeration District and page number for census other than UK and US in the CP transcript include on the person page
v9.1.0.4 9 Dec 2013 The following fixes and changes were made in this update:
  • made several updates to the Import from Ancestry
    • fixed the UK 1901 import to handle two new DOM source formats
    • fixed the import of 1911 Census of Canada for a new format
    • added import for 1921 Census of Canada
    • added checks on import to issue error messages if DOM Source is different than expected
  • fix CP Edit location field so that cp_data record is also updated and not just the cp_base record
  • changed cpinclude.php Other Full display for Census of Canada and for Lower Canada (Other Summary) 1825 census
  • several clean up actions removing or replacing old variable names
  • fixed birth year calculation in CP Update
  • added birth year calculation if age is entered in CP Add
  • added a Close Window button to the process CP Update
  • added a pull down selection to the CP Find of last names currently in the Census Plus tables
  • fixed the extended search to link to familygroup.php if the link is a FamilyID
  • added a search of TNG people table for Census Events to the CP Find screen that
    • allows searching using the names in your TNG database rather than the names in the census transcript
    • identifies Census Events with no linked transcripts
    • identifies possible missing census events based on birth and death dates
  • added a search of TNG family table for Family Census Events to the CP Find screen that
    • allows searching using the names in your TNG database rather than the names in the census transcript
  • moved the footer on CP Display and Update to the top of the screen to avoid scrolling on a laptop. Repeated as a footer if more than 20 data lines
  • added three new Mod Manager Edit options
    • Display the Show / Hide empty columns on CP Display. Defaults to Yes
    • Display the Next and Previous ID links. Defaults to No.
    • Return all linked PersonIDs for Media transcript display regardless of household. (added for Media - Census Plus International mod)
    Note that doing so will not display all members of a household that are not linked
  • fixed several scripts to allow linking the same census transcript to a different PersonID in a different tree so the transcript only displays for the correct personID/treeID being processed
  • fixed the add / update of 1830-1850 US Summary
  • fixed the creation of the cp_summary record for First Time installs
  • updated the CP Add Image to process census media collection links found on a search
  • fixed the CP Link query to eliminate Census Year in where clause is ambiguous error on some MySQL environments
  • fixed the CP Include queries to eliminate Census Year field list is ambiguous error on some MySQL environments
  • fixed the Other Summary update to display and update correct fields
v9.1.0.3 13 Nov 2013 The following fixes and changes were made in this update:
  • Fixed Interactive Import for
    • US 1790 Census to allow 130+ lines to be imported
    • UK 1851 Isle of Man Census
    • UK Census to handle two different formats of the 1861 census
    • Census of Canada to generate the line number from the actual line for the 1851 census
  • Fixed the DOM Source window interactive import and added ability to rename 0domdata.txt file.
  • Changes made to displays
    • Corrected the heading for the US 1800 and 1810 census
    • Added Years Married, Children Born, and Children Living to the 1900 and 1910 US census (replaces Veteran and Street fields)
    • Changed the US Full (1880-1940) to display in the same order as the 1910 census
    • Added Nbr Slaves for the 1850 and 1860 and Nbr Slave Houses for the 1860 US Slave Schedules
    • Added the Slave counts for the 1830 and 1840 US Federal Census
    • Updated the CP Display to show the 1820 Slave and Free Colored counts
    • Added support for the 1820 Slave and Free Color counts
    • Fixed the CP Update display for screen widths less than 1366
  • Changed the message for Household not assigned to use Not Assigned instead of "Action Required"
  • Fixed the delete transcript link from CP Update
  • Added new fields to tables
    • Publication for NARA pub or PRO Class (UK Census) and volumePage fields for UK Folio to better document census source
    • cplinkID to the CP Summary record to allow having 2 separate Household Summary records for the same PersonID / tree / CensusYear
    • cplinkID field to the CP Veteran record to allow having 2 separate US Veteran Schedule records for the same PersonID / tree / CensusYear
  • Added 2 new Mod Manager Edit parameters - Display Reference and Delete Events
  • Added several database integrity enhancements:
    • Updated Check Table Integrity to delete cp_link records that do not match cp_base and cp_data
    • Updated the Add process to facilitate adding related page transcripts using a unique ID to better handle split households
    • Added a Check Census Link button to the TNG Import Secondary Process for those of us using a GEDCOM Import
    • updated the hook in personlib.php to pass the eventtypeID to better insure display of the correct census
    • updated CP Delete to delete linked summary record
  • added US Summary format support to Other Census using 1820 as the default format if year does not match US household summary years to support creating US State census that are household summaries
  • Replaced the CPI Find tab with an extended search capability that will
    • facilitate linking existing census media collections and
    • allow searching using various criteria
    • allow sorting the results on different columns
v9.1.0.2a 25 Sep 2013
  • Fixed Interactive Import for US 1920 Census which has yet a 3rd variation on DOM Source input
v9.1.0.2 22 Sep 2013 The following fixes were made in the update:
  • Fixed Interactive Import so that complete Location name is imported and not just the State
    Note to those using TNG only, you will need to update the location in the Census Plus International mod created Census Events from the Import from Ancestry
  • Fixed the Image hover message when Image URL is used
v9.1.0.1 21 Sep 2013 The following fixes and enhancements were made in the update:
  • Changed to allow the Census Location to be updated in CP Update using the Town, County, State, and Country fields.
  • Added Roll to CP Display and Update
  • Changed Add to populate required fields with ?
  • Fixed the Ln display for the US 1850-1870 Census
  • changed the logic to set the Image link to the imageurl if it exists
  • fixed the CP Household Update so that the link to the Ancestry Images uses the Census Plus International option
  • standardize the Header displays for CP Display, Update, and Household Update
  • fixed the Image link for Ancestry images to open correctly in a separate window
  • fixed personlib.php hook in the cfg file to eliminate the conflict with the DoNotMap Custom Events mod
  • fixed the Selected option for TreeID to be set correctly when passed from previous script
  • added 1921 to the Census of Canada Add screen
  • fixed split household so that it displays correctly for Transcript IDs that are sequential
  • fixed to delete the census event when person is unlinked.
v9.1.0.0 15 Sep 2013 This is a new mod is an alternative to the previous Census Feature mod and provides the following enhancements
  • uses TNG Find Person dialog for linking TNG persons to Census Plus transcripts
  • uses TNG Name Order option to display Census Plus transcript on Individual Page
  • repeats the heading line as a table footer line for readability
  • adds the Person Preview to Census Plus Display
  • adds several new fields to the Census Plus base record to help better document sources
  • adds the 1890 Veteran Schedule
  • adds the 1790-1820 and updates the 1830-1840 household summaries
  • adds household summaries for the Lower Canada Census and allows you to select a household summary for other censuses
  • fixes the DOM Source import to handle apostrophes in names
  • fixes searches so they find a person whose name contains an apostrophe, like O'Regan
  • updates scripts to use options set by the user in Mod Manager Edit, such as controlling
    • whether 'United States' or 'USA' or nothing is added to US locations
    • whether 'Co.' or 'County' or nothing is added to the County in the location name
    • whether all members of a household are displayed whether linked or not
  • adds a Delete capability, to allow users to delete the imported entries they do not want
  • adds an Edit capability that allows users to delete lines within an imported transcript they do not want
  • adds the capability to use a TNG User Media collection or your own file name. See update imageurl
  • adds a single line census add capability
    • with several new census selections
    • with confirmation prompts for the Create New Transcript or Cancel
    • with a format selection in Add, Other Census that allows you to enter census not defined in the mod and control the row or line formatting
  • adds a new search capability that was cloned from the TNG Advance Search dialog to locate Census Plus transcripts