Admin Cemetery Edit

From TNG_Wiki
(Redirected from Cemetery Edit)
Jump to: navigation, search
Admin Cemetery Edit
Summary Makes workflow and presentation changes to the Cemetery Edit form and the Cemeteries "Add New" tab.
Mod Updated 22 Nov 2020
Download link
TNG 13.0
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 v13.0.0.9f
Min TNG V 10.0.1
Max TNG V 13
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
Related Mods

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 now side-by-side above that field.
  • There is now an Inner Mod Menu in the page's Inner Menu.

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

These mod options are custom TNG settings, defined and edited in a Mod Settings Block in the form at Admin>>Setup>>General Settings, in a new subform named Mod Settings Blocks. (In TNGv12, the subform heading is "Robin's Mods") See the last visualization below

  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.

Other Mods

Mod Conflicts

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

Related Mods

  1. The Mod Settings Blocks mod packages this mod's options into what I call a "Mod Settings Block", which is a set of form fields that formatted and labeled so that it stands out among other options in an Admin>>Setting form. The Mod Settings Blocks mod must be installed before this mod can be installed.
  2. The optional mod Inner Mod Menus displays an "Inner Mod Menu" in the TNG "inner menu" (just below the tab menu). The Inner Mod Menu is defined by this mod but is visible only if Inner Mod Menus is installed. It is also visible only to TNG administrators; never to end-users. I highly recommend that you install the Inner Mod Menus mod because Inner Mod Menus provide links to handy information - particularly to the mod settings blocks for this mod's options.
  3. This mod gathers data that can be used by the optional mod Show Mod Names, but there is no dependency on Show Mod Names
  4. 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.
  5. Admin Cemeteries Search 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).
  6. 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.


Files Installed

  1. rrcemeteryedit_ajx.php - An AJAX program that helps to populate the Cemetery's "Associated Place" field. It finds Cemeteries that match specifications provided in the edit page, lists them with some of their data, and allows the user to select one.
  2. img/rrcemeteryedit_right.gif - A small image the points to the right when field values can be copied to the right to add specifications to the Associate Place lookup described above.

In TNGv13, this mod includes a typical mod subfolder, with the same base name as the mod's .cfg file. The subfolder is atypical in that no files in it are installed to working TNG folders. However, it does contain critical files that contain the mod's language strings, which the mod does not add to standard cust_text.php files. Instead, the PHP code modified by this mod loads the language strings from files in the mod's languages/ subfolder. Read more about this technique.

In TNGv12 only, there is a second mod subfolder, which is shared by several mods. The folder RR-shared_mod_includes_v12.0.0.4 contains Include files that help to manage mod options in many of my mods:

  1. rrshared_modsettingsblocks4.php - Mod Settings Blocks
  2. img/rrshared_wikilogo.gif - An icon that links to a mod's TNG Wiki page from a Mod Settings Block

Each mod that contains the shared folder may install some or all of its shared files, depending on whether those files already exist. Once a file from the shared folder has been installed (by any mod), that file will not be overwritten or removed by the subsequent installation or un-installation of any mod (including this one), nor will its presence or absence generate any Mod Manager errors.

If you unzip mod distribution files directly into your mods folder, then the presence of the shared subfolder and the installation of its files should be invisible to you. But if you generally copy mod subfolders to your mods folder after you have unzipped the distribution file, then you need to make sure to copy the folder RR-shared_mod_includes_v12.0.0.4 (well, unless you are confident that it is already in your mods folder because it was part of another mod).

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

Cemetery edit-after1-fullv9.jpg

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
Cemetery Edit form After Installation- The Inner Mod Menu

In admin_editcemetery.php the Inner Mod Menu links to:

  • The Admin Cemetery Edit Wiki article.
  • The Mod Options section of the Wiki article,
  • The mod setting block for this mod. (See the next visualization), and
  • A popup box describing what the mod has done.
Cemetery edit-imm.jpg
After Installation- The Admin Cemetery Edit Mod Settings Block

A Mod Settings Block is an outlined subform within an Admin>>Setup program that contains the options for a single mod. What is most notable about a Mod Settings Block is that a hyperlink directly to a Mod Settings Block displays only that block (i.e. only one mod's options), not all of the other options in the form or subform.

Here, you see the this mod's Mod Settings Block, in admin_genconfig.php, at Admin>>Setup>>General Configuration. The triangular arrow next to the subfolder heading Mod Settings Blocks is pointing to the right, meaning that the subform is not open, and that your site's other mod settings blocks are not visible. If you were to open the subform by clicking on the heading, you would see the mod settings blocks for other mods that you have installed.

Admin cemetery edit-msb.jpg

Revision History

Mod Version TNG Version Date Note 13 22Nov2020 Cleaned up language strings and removed some extra characters from the page 13 11Oct2020 Upgraded to TNGv13 12.0-12.3 28Mar2020
  1. Fixed a bug in the options editor; it was not saving all of the settings.
  2. Modified the Lookup help text in the Lookup & Copy Widget
  3. Added Selection/Copy help in the Lookup & Copy Widget
  4. Upgraded to version 5 of the shared mod Includes libraries.
  5. Added a link to the mod's options from a dummy mod parameter 12.0-12.3 26Feb2020 No functional changes.
  • A file being installed was being pulled from the wrong folder, and thus would not be present if Admin Cemeteries Search is not present.
  • Upgraded to version 4 of the shared mod libraries. 12.0 - 12.2 28 Sep 2019 No significant functional changes; but several user interface and help file changes. Also 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)
    • 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-12.2 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 13.0.1 English
Total Family History Scott Bennett Private Site (For right now) V9.2.0.3 TNG 10.0.1 English
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