Admin Cemetery Edit

From TNG_Wiki
(Redirected from Cemetery Edit)
Jump to: navigation, search
Construction This article is in transition from Cemetery Edit v8b to Admin Cemetery Edit v9. The text describes version 9, but, at the moment, the Visualizations describe version 8. See the Revision History for a list of changes in version 9.

Robin Richmond 28 Sep 2019


Admin Cemetery Edit
Summary Makes workflow and presentation changes to the Cemetery Edit form and the Cemeteries "Add New" tab.
Mod Updated 28 Sep 2019
Download link
TNG 12.0
See older versions in the Revision History
Download stats
Author(s) Robin Richmond
Homepage this page
Mod Support My Mod Support form or TNG Community Forums
Contact Developer My Mod Support form
Latest Mod v12.0.0.9
Min TNG V 10.0.1
Max TNG V 12.2
Files modified
Modifies: admin_editcemetery.php, admin_updatecemetery.php, admin_cemeteries.php, admin_newcemetery.php, admin_addcemetery.php, cemeteries_help.php, admin_genconfig.php, admin_updateconfig.php, English cust_text.php.

Installs: rrcemeteryedit_ajx.php, img/rrcemeteryedit_right.gif

Installs shared files: rrinnermodmenu1_include.php, rrmodoptions1.php, img/rrmodadmin_wikilogo.png
Related Mods
Because this mod shares a subfolder with other mods, when you unzip the mod's zip file or move the files to the mods folder, you may get a "Folder already exists" warning, which you can ignore.

Purpose of the Mod

This mod is intended to improve the workflow and layout of the Cemetery Edit form, and, particularly to clarify the differences among the buttons that fill in the Associated Placename field.

Functional changes in the Cemetery Edit page include:

  • A new Associated Placename lookup tool (in addition to the one in the native Edit form). The new "Place Lookup & Copy" form:
    • Provides buttons that copy Cemetery city, county, state, and country values to the search field,
    • Has more search options,
    • In the search results:
      • Displays Geocodes, Tree, Number of Burials
      • Separates the Cemetery Name from the City, County, State, and Country in the Placename
    • Provides a way to copy the new Associated Placename's Cemetery Name, City, County, State, Country, and Geocodes to Cemetery fields.

Other page layout and content changes include:

  • Mod settings control whether some form fields appear above or below the Gooogle map.
  • New help links and annotation,
  • The two old buttons and one new button that populate the Associated Place field are side-by-side above that field.
  • There is now an Inner Mod Menu in the page's Inner Menu. (See Inner Menu Links below.)

See a detailed list of changes in the Visualizations below.

This mod also changes the Admin Cemeteries "Add New" tab so that the "Add New" tab invokes the Cemetery Edit page instead of the nearly-identical (in pristine form) Cemetery Add form. As a result, the changes this mod makes to the Cemetery Edit form do not need to be made to the Cemetery Add form.

Mod Options

All options are custom TNG settings, which are defined and edited in the form at Admin>>Setup>>General Settings, in the new subform Robin's Mods, where the options for various mods are organized into Mod Settings Blocks.

  1. Default country for new cemeteries
  2. Put Geocode fields above the map? - The pristine code put the Cemetery Image fields at the bottom of the form, below the Google map. This parameter allows them to be placed before or after the map.
  3. Put Image Upload fields above the map? - The pristine code put the Cemetery Image fields at the beginning of the form. This parameter allows them to be placed before or after the Google map.
  4. Delimiter within Placenames - Just a comma ("Erie County,Ohio,USA") or comma-space ("Erie County, Ohio, USA").
  5. When filling the Associated Placename, include the extra delimiter if a place-part is missing?
    This is invoked when the Cemetery form fields (cemetery name, city, county, state, country) are used to create a new Associated Placename. If, say, the city is missing, the new Associated Placename can be
    • "Bethel Cemetery, , Erie County, Ohio, USA" (with an empty placeholder for the City), or
    • "Bethel Cemetery, Erie County, Ohio, USA" (with no City placeholder).
  6. Count burials at the Associated Place in the Placename Lookup and Copy Widget? - The widget normally displays the number of Burial events at each Placename that matches the search, but for some large databases, it may take too long to count burials, so the burial count can be suppressed.
  7. In the Placename Lookup and Copy Widget results, check the boxes that copy these values to the Cemetery fields - Checkboxes cause specific (groups of) values to be copied to the Cemetery form when an Associated Placename is selected. The checkbox value are:
    • Cemetery Name (which is extracted from the Associated Placename),
    • City,County,State,Country (also extracted from the Associated Placename),
    • Geocodes - Latitude, Longitude, Zip

Inner Menu Links

In admin_editcemetery.php, some links in the Inner Menu have been modified:

  1. Cemetery Report - This was labeled 'Test' in the native page, and launches showmap.php, which is effectively the "Cemetery Detail Report".
  2. Places Search - A pop-up link to Admin>>Places. This link makes it easy for you to find and edit a Burial Place record that you wish to associate with this Cemetery.
  3. Mod Information - This link drops down what I call an Inner Mod Menu, which contains these links to information about this mod:
    • This Wiki Article,
    • The "Mod Options" section of this Wiki article,
    • The mod options editor (Admin>>Setup>>General Settings>>Robin's Mods). When you follow this link, the options edit form display only this mods options. If you want to see tall of the mod options in the subform, just click on the heading Robin's Mods. (See the visualization below, or at Inner_Mod_Menus.
    • The Add/Edit section of the Cemetery help file, which has been modified to reflect the changes made by this mod.
      This mod's changes have also been highlighted with blue outlines.

Related Mods

  • This mod uses the Field Buttons mod to attach small 'field buttons' to several text fields, but it is not dependent on Field Buttons. Field buttons are configurable (and generally one-character) buttons that are attached to HTML form fields, and that reduce the typing or mouse movements needed to perform several common editing tasks. This mod is not compatible with Field Buttons mod versions earlier than version 3.
  • Admin Cemeteries Search mod is a companion to Admin Cemetery Search (this mod). It was motivated by essentially the same purposes as this mod, and focuses on the Cemetery Search/Selection page, whereas this mod focuses on the Cemetery Edit page. Admin Cemeteries Search also changes the Cemeteries>>Add New tab to use admin_editcemetery.php rather than admin_newcemetery.php (no matter whether admin_editcemetery.php has been modified by this mod).
  • This mod will round Cemetery geocoordinates to the number of decimal digits specified by the mod option for Admin Places Geocode, if and only if Admin Places Geocode version 4+ is installed.
  • This mod saves information that can be displayed by Show Mod Names, but is not at all dependent on Show Mod Names.

Mod Conflicts

No known conflicts. Admin Cemeteries Search is the only other mod that targets the Cemetery add and edit modules.


This mod uses the standard installation procedure, though it should be noted that this mod contains two mod subfolders that are shared with other mods that implement Mod Settings Blocks' Admin>>Setup forms, and Inner_Mod_Menus. Because of the shared subfolders, as you unzip or copy the mod, you might get a warning noting that a folder already exists. You can just ignore that warning.
[Show Installation Details]


  • A working TNG installation.
  • An installed current version of the Mod Manager.
  • You should backup files listed in the panel on the right.


  1. Remove and delete previous version of this mod.
  2. Backup the files updated by this mod. They are listed in the panel at the upper right.
  3. Download the .zip file, Extract its .cfg file to the mods folder.
  4. Follow the normal automated installation for Mod Manager, as shown in the example Mod Manager - Installing Config Files.


  1. Try using the Mod Manager Remove capability
  2. Contact me through My Mod Support form.
[Hide Details]


BEFORE: The unmodified Cemetery edit form, with the Google map hidden. The areas in red rectangles are moved, changed, or removed by the mod.
Cemetery edit-before.png
Cemetery edit-after1-fullv9.jpg Starting from the top:
  1. The "Cemetery Report" inner menu link used to be labeled 'Test'
  2. The new "Place Search" link opens the Admin>>Places>>Search in a new window. This link's purpose is to allow you to find and modify Places that will be used as as Cemetery's Associated Placename.
  3. The "Mod Information" link pulls down the Inner Mod Menu.
  4. The Cemetery Name, City, and County/Parish fields now have "field buttons", which are one-character buttons that perform editing shortcuts such as "Clear the field" and "Restore the field's initial value". The field buttons are visible only if the optional Field Buttons mod has been installed.
  5. The "Save and Exit" button duplicates one of the Save options at the bottom of the screen. It is most handy when the map is visible and the original Save button is not.
  6. The "Delete Selected" button for the Country field is disabled when the current Country value is the same as the Default Country value that is specified by a mod option. (That is, in this case, "USA" is the default Country, and cannot be deleted from the Countries table.)
  7. The Fill Placename button has been moved. It does virtually the same thing as before, but its action is now affected by two mod options
      1. Whether Place delimiters have spaces, and
      2. Whether empty Place components are shown by adjacent delimiters.
    That is, it can generate names such as 'Huron County,Ohio,USA' (without spaces), 'Huron County, Ohio, USA' (with spaces), 'Peace Cemetery, , Dover County, Utah, USA', (with a placeholder for the missing city), and 'Peace Cemetery, Dover County, Utah' (with no indication of the missing city).
  8. The spyglass button has moved, but still invokes the native Find Placename function.
  9. A new button opens the "Place Lookup & Copy" Widget, which is essentially an enhancement to the native Find Placename function.
    • There are some enhancements to the lookup itself.
    • The key enhancements affect what happens when a Placename in the lookup results is selected, and are especially useful when new Cemetery records are being created. The core purpose of the "Find Placename" and "Place Lookup & Copy" buttons is to select the Associated Placename for a Cemetery. The key "Place Lookup & Copy" enhancements, unsurprisingly, add "Copy" functionality, that is, the Place Lookup & Copy widget can use values in the selected Place record to populate
      1. The Cemetery name,
      2. The Cemetery's location components (City, State, County, Country), and/or
      3. The Cemetery' Geocoordinates (Latitude, Longitude, and Zoom).
  10. The "Associated Placename" label used to be "Associated Place". The change emphasizes that the Associated Placename is not necessarily a single Place (in a single Tree), but rather is a Placename that can match Places in multiple trees.
  11. The the three Geocoordinates fields are enclosed in a Fieldset, and have been moved above the map. A mod option controls whether they are above or below the map. In addition, the wording of the 'Copy this geocode information...' checkbox has been changed to emphasize that the information might be copied to multiple Place records in the Places table.
  12. The Cemetery Image fields are now enclosed in a Fieldset, and have been moved so that they are below the map. Their position on the page is controlled by a mod option.
  13. The placement of the 'On save' options and "Save" button have been adjusted to improve readability.
  14. The Cemetery Image is now scaled to the browser window.
AFTER INSTALLATION: The modified Cemetery edit form.

Green rectangles mark what's new , and red rectangles mark things that have been moved or changed .

The workflow of the "Placename Lookup & Copy" Widget

Step 1: Click on the "Placename Lookup & Copy" button
Cemetery edit-after-step1v9.png
Step 2: The Placename Lookup & Copy Widget
  • The button pops up a new panel in front of the form. The new panel contains the Placename Lookup & Copy "Widget". The Widget is placed in the very center of the screen, and can be moved to uncover fields that you may want to see. (It cannot be resized, however.)
    The widget contains:
    1. The search string for the lookup, populated with the Cemetery Name from the form.
    2. A radio button set that controls the type of search:
      • Starts With - The search string looks only at the beginning of a Place value,
      • Contains - The search looks anywhere within a Place value, or
      • 'Contains Each - The search looks for each place component (the comma-pieces) in each Placename in the database. (This option is disabled if the search string consists only of a Cemetery Name.)
    3. The "Search" button, and
    4. An information icon next to the Search button.
  • Right-arrow keys are displayed next to the City, County, State, and Country fields. These keys copy a value into the search field, separated from the previous value by a comma (or comma-space, depending on a mod option).
  • The screen clip below shows
    1. The value ", Cleveland" that was copied to the search field when the arrow key next to the city name was clicked.
    2. The help text that is displayed when the information icon is clicked.
Cemetery edit-after-step2v9.png
Step 3: Placename Search Results
  • The Search results are displayed below the search form. (If needed, the search form can be modified and a new search can be performed.)
  • The search results contain not only only all matching Places, but also other values from their Place records.
  • Note that, in this case, identical placenames that match the Cemetery search are found in two trees ('rr' and 'b'). Selecting either of those Place records will copy the same Associated Place value to the Cemetery form.
  • (The "Tree" column heading is a hyperlink that switches the Tree column between the tree IDs and the tree names.
  • The widget can also copy the Cemetery Name, the place components, and/or the geocodes from the selected Place record to the Cemetery form.
    • The initial state of each checkbox is determined by mod options
    • The values that will be copied (according to the checkboxes) when a record is selected are shaded in grey.
    • Note that the two "Fort Hill Cemetery" records have 'different geocodes , so, even though they both will copy the same "Associated Placename" value, they will copy different geocodes (assuming that the Geocodes checkbox remains checked).
Cemetery edit-after-step3v9.jpg
Step 4: The Selected Values are Copied to the Cemetery Form

When the Widget's "Select" button is clicked:

  • The Lookup Widget disappears.
  • The Associated Placename field is populated by the selected Placename.
  • In this case, since the Geocodes checkbox remained checked, the 3 geocode values ("Zoom" is not shown in the search results) have been copied to the Cemetery Form.
  • Note that the new values in the Associated Placename and Geocode fields have changed the state of those fields' field buttons.
    • Where there was an empty Associated Placename value, with two greyed-out field buttons with greyed-out X and R buttons,
      • The X button will now clear the field, and
      • The R button will revert to the field's initial value, which is blank.
    • Initially (in this example), the Latitude, Longitude, and Zoom fields had values, but now the values have changed, so, in each field:
      • The X button, as before, will clear the field, and
      • The R button, which was initially greyed out, will revert the field to the value it had when the form was loaded.

The Cemetery Help Page provides more information about the Widget, including what happens when the placename components are copied to the Cemetery form, but a placename component (such as City or County) is missing from the selected Placename.

Cemetery edit-after-step4v9.jpg

Revision History

Mod Version TNG Version Date Note 12.0 - 12.2+ 28 Sep 2019 No real functional changes. Besides these changes, See the .cfg file for bug fixes and other internal changes.
  • Small user interface changes to Admin>>Cemeteries>>Edit include:
    • Added an 'Inner Mod Menu to the right end of the standard TNG Inner Menu.
    • Changed the placement of and tweaked the behavior of the Place Lookup & Copy widget.
    • Changed the placement of the "Fill Associated Place" button and the native Associated Place find button.
    • Added an info icon and help text to the Place Lookup & Copy popup search form.
    • The "Tree" column heading in the Place Lookup & Copy results table is now a hyperlink that switches between the Tree ID and Tree Name.
    • Added a "Save & Exit" button near the top of the form that duplicates one of the Save options at the bottom of the form.
    • Modified the Add/Edit section of the Admin Cemeteries help page to reflect changes made by the mod.
    • The cemetery image is now scaled to the display window.
  • Changes to the Cemeteries help page
    • Reworked the help text extensively. The help text gives particular attention to the three ways to populate the Associated Place field. (Two are native; one is the mod's Place Lookup & Copy widget.
  • Internal changes include:
    • Renamed the mod from Cemetery Edit to Admin Cemetery Edit
    • The mod's options were mod parameters (managed by the Mod Manager), and are now mod options in a new subform at Admin >> Setup >> General Settings.
    • Changed calls to the Field Buttons library, requiring version 3 of the Field Buttons mod (well, if the Field Buttons mod is installed at all)
    • The Inner Mod Menu and mod options require that the mod subfolder robin_modadmin_shared_subfolder be zipped into this mod, and that several files from that subfolder be installed (in protected mode).
    • admin_editcemetery.php now handles rounding of the geocoordinates slightly differently. Rounding is still based on the "Round to how many decimal digits" mod option in Admin Places Geocode. Installation of Admin Places Geocode is still optional, but now, this mod doesn't do any rounding unless the Admin Places Geocode is installed and the rounding option is set. 12.0+ 15 May 2018 No functional changes; made compatible with TNGv12. 10.1 - 11.1.2+ 10 Feb 2017 No visible changes on-screen, though the page as printed is different. Specifically:
  • Applied a "don't print on printer" class to the tab menu and inner menu, and the Action and Select columns of the results table.
  • No longer uses the external spreadsheet robinmods.css. Instead, style rules specific to this program are defined in an embedded stylesheet. The rules can be overridden in css/genstyle.css.
  • All links to the TNG Wiki use https 10.1 - 11.1.1+ 9 Sep 2017 Production version. Additional changes include:
  1. A link to the list of Mod Parameters (i.e. "Options") in the mod's Wiki article has been added to the Inner Menu.
  2. A link to the Visualizations in the mod's Wiki article has been added to the Inner Menu.
  3. The link to pop-up an Admin Places window (so that burial places can be created or edited as necessary while a Cemetery Edit page is open) has been moved to the Inner Menu.
  4. The fields that upload or assign a Cemetery map or photo image can be displayed at the top or bottom of the form, depending on a mod parameter.
  5. Several layout changes make the form less cluttered than previous versions of the mod.
  6. The table of matching Places (which supplies candidates for the Associated Place value and values for numerous fields on the form) is now placed in a pop-up LITBox, and uses AJAX so that the list of matching Places can be updated when the Cemetery Name and/or Location fields are updated.
  7. The search key for the table of matching Places is now a visible field that is automatically populated by the Cemetery Name as well as the location fields. It can be changed by the user before doing a Place Lookup.
  8. A new Mod Parameter allows the Map to be hidden (initially) if there are already Geocodes, so that the fields below the map can be more visible.
  9. The 'zoom' field is now numeric, and the checkbox for copying the Cemetery's geocode data to the associated places has been moved next to the zoom field.
  10. The "On save..." radio buttons and the Save button at the bottom of the form are now laid out horizontally. TNGv10.1+ 7 May 2017
  1. Added a border around the Add New Cemetery form
  2. Fixed a bug where a SQL statement used single quotes instead of double quotes and couldn't handle a value with a single quote.
  3. The CopyPlace button copies the City, County, State, and Country from the associated place, and creates database records for the State and Country if necessary.
  4. There is now a Round button that rounds the geocordinates to 6 decimal places.
  5. Renumbered the locations.
  6. The .rrnoprinter style class (which prevents an element from printing on a printer) is now defined locally. This removes a dependency on what is now an obsolete mod. TNGv9.2.2-10.1+ 11 Jan 2015 TNG v10.1 compliance - Changed trimreplace directives to replace, and changed mysql_* function calls to tng_* TNGv9.2.2-10.0.3 04Oct2014 Fixed bug with respect to selection of default country. Added $defaultcountry parameter so that administrators can pick the default country for new cemeteries. TNGv.2.2-10.0.1 05Apr2014 Restored the "Fill Place" button, and allowed users to enter an associated place directly. TNGv9.2.2-10.0.1 14Mar2014 Initial Release

Sites using this mod

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

URL User Note Mod-Version TNG-Version User-language
Robin Richmond's Genealogy Database Robin Richmond Mod developer 11.1.2+ English
Total Family History Scott Bennett Private Site (For right now) V9.2.0.3 TNG 10.0.1 English
The Dutton's of Vermont Darrin Dutton 10.1.0 EN
MOTYER Family Genealogy John Mark Motyer Public site see here see here EN, DE, RU
R G Strong Family Genealogy Russell G Strong Public Site v11.0.0.0 v11.0.0 EN (DE, FR, NL)
Cole / Tanner Family Tree David Cole Public/Private see here see here English
Woking Family Tree Project Pete Smee Public/Private Brilliant Mod many thanks v12.0.0.8b v12.1 English
Our Family Histories Bryan S. Larson Public - T8 customized see here see here EN