'''Experienced'''
5 069
modifications
Modifications
mod version 5a
| mod_summary = Causes the Gedcom Import Process to delete Medialinks records that have been deleted from the source database, and to retain some Places records that otherwise would be purged.
| mod_summary = Causes the Gedcom Import Process to delete Medialinks records that have been deleted from the source database, and to retain some Places records that otherwise would be purged.
| mod_validation =
| mod_validation =
| mod_last_update = 2 Dec 2019
| mod_last_update = 28 Aug 2020
| download_link = [[Media:gedcom_import_purge_v12.0.0.5.zip|v12.0.0.5.zip]]{{Tv120}}
| download_link = [[Media:gedcom_import_purge_v12.0.0.5a.zip|v12.0.0.5a.zip]]{{Tv120}}
<div style='font-size:90%'>Older versions can be downloaded from the [[#Revision_History|Revision History]].</div>
<div style='font-size:90%'>Older versions can be downloaded from the [[#Revision_History|Revision History]].</div>
| download_stats =
| download_stats =
| mod_contact = [http://www.robinrichmond.com/family/mod_support.php My Mod Support form]
| mod_contact = [http://www.robinrichmond.com/family/mod_support.php My Mod Support form]
| mod_support = [http://www.robinrichmond.com/family/mod_support.php My Mod Support form] or [http://tng.community/ TNG Community Forums]
| mod_support = [http://www.robinrichmond.com/family/mod_support.php My Mod Support form] or [http://tng.community/ TNG Community Forums]
| mod_version = v12.0.0.5
| mod_version = v12.0.0.5a
| min_TNG_ver = 10.1
| min_TNG_ver = 10.1
| max_TNG_ver = at least 12.2
| max_TNG_ver = 12.3
| TNG_file_list = admin_dataimport.php, admin_gedimport.php, gedimport_trees.php, gedimport_misc.php, admin_editmedia.php, js/mediafind.js, js/mediautils.js, micro_medialinks.php, ajx_updateorder.php, admin_importconfig.php, admin_updateimportconfig, English/data_help.php, English cust_text.php.
| TNG_file_list = admin_dataimport.php, admin_gedimport.php, gedimport_trees.php, gedimport_misc.php, admin_editmedia.php, js/mediafind.js, js/mediautils.js, micro_medialinks.php, ajx_updateorder.php, admin_importconfig.php, admin_updateimportconfig, English/data_help.php, English cust_text.php.
<br>Installs: rradminbranches_ajx.php, rradminbranches_lib.php.
<br>Installs: rradminbranches_ajx.php, rradminbranches_lib.php.
<br>Installs shared files: rrshared_innermodmenu2.php, rrshared_modsettingsblocks2.php, img/rrshared_wikilogo.gif
<br>Installs shared files: rrshared_innermodmenu2.php, rrshared_modsettingsblocks2.php, img/rrshared_wikilogo.gif
| related_mods = [[Admin Media Search]], [[Gedcom Import Mediatype]], [[Gedcom Import Monitor]], [[Show Mod Names]]
| related_mods = [[Admin Media Search]], [[Gedcom Import Mediatype]], [[Inner Mod Menus]], [[Show Mod Names]]
| notes =
| notes =
}}== Purpose of the Mod ==
}}== Purpose of the Mod ==
This mod changes the Gedcom Import process to
This primary purpose of this mod is to make sure that old imported Medialinks do not hang around and disrupt TNG pages after they have been deleted from the source database. To recognize imported Medialinks, it flags all Medialinks that are created through a gedcom import. See the [[#Purging_Medialinks|Purging Medialinks]] section below for details.
It also retains certain Places that are purged by the native TNG code.
It is important to realize that this mod purges Medialinks that were created by a previous Gedcom Import ''and that were flagged during that Gedcom Import.'' That is, the mod purges old Medialinks that were created ''after the mod was installed'', but cannot recognize and purge old Medialinks that are already causing trouble when the mod is installed. See "[#[Pre-Existing_Medialinks|Pre-Existing Medialinks]] below.
{| style="margin-right:0.5 em;" align="right"
{| style="margin-right:0.5 em;" align="right"
| __TOC__
| __TOC__
Without this mod, the Gedcom Import Process:
Without this mod, the Gedcom Import Process:
* Leaves ''all'' Medialinks intact, including those that have been removed from the source database,
* Leaves ''all'' Medialinks intact, including those that have been removed from the source database,
* May purge Place records or Places data that is not replaced by the Gedcom Import.
* May purge Place records or Places data that are not replaced by the Gedcom Import.
== Details ==
== Details ==
## Use the new "createdbygedcom" Medialinks field to flag the Medialinks it creates and
## Use the new "createdbygedcom" Medialinks field to flag the Medialinks it creates and
## Purge (delete) Medialinks that are flagged as having been created by a Gedcom Import - but only if the user checks the new "Purge media links created by previous Gedcom imports" checkbox in the Gedcom Import kickoff form,
## Purge (delete) Medialinks that are flagged as having been created by a Gedcom Import - but only if the user checks the new "Purge media links created by previous Gedcom imports" checkbox in the Gedcom Import kickoff form,
# Modifies the Medialinks section of the Edit Media form to display and edit the "createdbygedcom" flag. The flag is turned off when new Medialinks are created via TNG data entry, and, from that point, can be changed, though it is not likely to be changed.
# Modifies the Medialinks section of the Edit Media form to display and edit the "createdbygedcom" flag. The flag is turned off when new Medialinks are created via TNG data entry
* This mod creates a checkbox for each Medialink in a Media Edit page so that you can see whether a given medialink came from a Gedcom Import or from TNG data entry. The checkbox status ''can'' be changed, though you are not likely to want to change it, unless you have created a Medialink in your source database that duplicates a Medialink you have created through TNG data entry.
<!-- BUTTON AT THE BOTTOM OF TOGGLED CONTENT --><div class="mw-customtoggle-mlinks1 mw-customtoggle-mlinks2" style="text-decoration:underline;color:#0645ad;text-align:right;">[Hide details]</div>
<!-- BUTTON AT THE BOTTOM OF TOGGLED CONTENT --><div class="mw-customtoggle-mlinks1 mw-customtoggle-mlinks2" style="text-decoration:underline;color:#0645ad;text-align:right;">[Hide details]</div>
</div><!-- END TOGGLED CONTENT and END DOUBLE TOGGLE -->
=== Pre-Existing Medialinks ===
<!-- *** BEGIN DOUBLE TOGGLE --><div class="mw-collapsible mw-customtoggle-old1 mw-customtoggle-old2" id='mw-customcollapsible-cm1' style="text-decoration:underline;color:#0645ad;">[Show Details]</div>
<div class='mw-collapsible mw-collapsible-content mw-collapsed' id='mw-customcollapsible-old2' style="border:thin solid grey;"><!-- BEGIN TOGGLED CONTENT -->
<!-- BUTTON AT THE TOP OF TOGGLED CONTENT --><div class="mw-customtoggle-old1 mw-customtoggle-old2" style="text-decoration:underline;color:#0645ad;float:right;">[Hide details]</div>
Medialinks that already exist ''before this mod is installed'' will not be purged by the mod for the same reason that they are not purged by the native TNG code. That is, when it is first installed, the mod cannot tell the difference between old Medialinks that were created by a previous Gedcom import and those that were created through TNG data entry. If you have not created Medialinks through TNG data entry, or if you are content to delete those medialinks, then, before running the first Gedcom import after you install the mod, you can clean up those old medialinks by using a tool such as phpMyAdmin
# To delete all medialinks in your tree, with a SQL statement such as <code style="white-space:nowrap">DELETE tng_medialinks WHERE gedcom='xx'</code> (where 'xx' is your tree abbreviation,
# If you have only one tree, you can more thoroughly clean up the Medialinks table by truncating it with the SQL statement <code style="white-space:nowrap">TRUNCATE tng_medialinks</code>
On the other hand, if your database has Medialinks that you do want to preserve, well, you have to be able to identify those Medialinks when you purge the table. If the only media items that you have added through TNG data entry are links to Places (which cannot be created through a Gedcom import), then you can use a variant of the DELETE statement suggested above:
* Before TNGv12: <code style="white-space:nowrap">DELETE tng_medialinks WHERE gedcom='xx' AND linktype!='L' AND linktype!=''</code>
* IN TNGv12.0 and after: <code style="white-space:nowrap">DELETE tng_medialinks WHERE gedcom='xx' AND linktype!='L'</code>
If you have created other Medialinks, well, those medialinks cannot easily by identified in a purge. If you have created medialinks to only a very few different media items, then my best suggestion is to
# Launch the Media Edit page for those media items, and make note of their mediaIDs,
# Create a comma-delimted list of those mediaIDs.
# Paste that list in to this SQL query: <code style="white-space:nowrap">DELETE tng_medialinks WHERE mediaID NOT IN "({your list})".
#* For example, if you only need to preserve Medialinks to media items with mediaIDs 350 and 580 the command would be <code style="white-space:nowrap">DELETE tng_medialinks WHERE mediaID NOT IN "(350,580)"</code>
<!-- BUTTON AT THE BOTTOM OF TOGGLED CONTENT --><div class="mw-customtoggle-old1 mw-customtoggle-old2" style="text-decoration:underline;color:#0645ad;text-align:right;">[Hide details]</div>
</div><!-- END TOGGLED CONTENT and END DOUBLE TOGGLE -->
</div><!-- END TOGGLED CONTENT and END DOUBLE TOGGLE -->
<div class='mw-collapsible mw-collapsible-content mw-collapsed' id='mw-customcollapsible-cm2' style="border:thin solid grey;"><!-- BEGIN TOGGLED CONTENT -->
<div class='mw-collapsible mw-collapsible-content mw-collapsed' id='mw-customcollapsible-cm2' style="border:thin solid grey;"><!-- BEGIN TOGGLED CONTENT -->
<!-- BUTTON AT THE TOP OF TOGGLED CONTENT --><div class="mw-customtoggle-cm1 mw-customtoggle-cm2" style="text-decoration:underline;color:#0645ad;float:right;">[Hide details]</div>
<!-- BUTTON AT THE TOP OF TOGGLED CONTENT --><div class="mw-customtoggle-cm1 mw-customtoggle-cm2" style="text-decoration:underline;color:#0645ad;float:right;">[Hide details]</div>
Until version 12, TNG's Gedcom Import process ignored Citation Medialinks, basically assuming (I presume) that the Gedcom medialinks were repeated in the relevant higher-level source and person or family records. In fact, because TNG did not handle citation medialinks, the "Modify Gedcom files for TNG" option in the Gedcom Converter mod specifically creates those higher-level medialinks when it encounters citation medialinks.
Until version 12, TNG's Gedcom Import process ignored Citation Medialinks, basically assuming (I presume) that the Gedcom medialinks were repeated in the relevant lower-level source and person or family records. In fact, because TNG did not handle citation medialinks, the "Modify Gedcom files for TNG" option in the Gedcom Converter mod specifically creates those lower-level medialinks when it encounters citation medialinks.
Now that the TNG Gedcom Import process does create citation medialinks, Gedcom files that have citation medialinks ''and'' higher-level medialinks generate redundant medialinks. In addition, (as of TNGv12.2) not all TNG program that display medialinks handle citation medialinks cleanly.
Now that the TNG Gedcom Import process does create citation medialinks, Gedcom files that have citation medialinks ''and'' lower-level medialinks generate redundant medialinks. In addition, (in TNGv12*) not all TNG program that display medialinks handle citation medialinks cleanly.
To handle redundant Citation Medialinks;
# Installs a setup program that create a new database field named "createdbygedcom" for keeping track of Medialinks that are created by the Gedcom Import Process, and
# If you use the Gedcom Converter,
# Modifies the Gedcom Import process to:
#* You can remove Citation Medialinks through the Gedcom Converter option<br>Suppress Citation Medialinks
## Use the new "createdbygedcom" Medialinks field to flag the Medialinks it creates
#* If you want Citation Medialinks to be defined for lower-level records (i.e. the Event and the Person or Family) ''and'' your source Gedcom file does not already have such medialinks, then you can create them through the Gedcom Converter option<br>Create Individual, Family, and Source medialinks from Citation Medialinks
## Purge (delete) Medialinks that are flagged as having been created by a Gedcom Import - if the user checks the new "Purge media links created by previous Gedcom imports" checkbox in the Gedcom Import kickoff form,
# In the Gedcom Import kick-off page (whether or not you have used the Gedcom Converter) you can control the creation of Citation Medialinks through option (created by the Gedcom Purge mod)<br>Supress the creation of Citation Medialinks
#* Of course, you would never want to use this option unless the Gedcom file that you import contains lower-level Medialinks that substitute for those Citation Medialinks
Note that neither the Gedcom Converter nor the Gedcom Import process can keep only the Citation Medialinks, and suppress the matching lower-level Medialinks.
<!-- BUTTON AT THE BOTTOM OF TOGGLED CONTENT --><div class="mw-customtoggle-cm1 mw-customtoggle-cm2" style="text-decoration:underline;color:#0645ad;text-align:right;">[Hide details]</div>
<!-- BUTTON AT THE BOTTOM OF TOGGLED CONTENT --><div class="mw-customtoggle-cm1 mw-customtoggle-cm2" style="text-decoration:underline;color:#0645ad;text-align:right;">[Hide details]</div>
</div><!-- END TOGGLED CONTENT and END DOUBLE TOGGLE -->
</div><!-- END TOGGLED CONTENT and END DOUBLE TOGGLE -->
I do not know of any conflicts with other mods.
I do not know of any conflicts with other mods.
* [[Admin Media Search]] - This mod changes the way that TNG displays all medialinks, and it handles citation medialinks, which are a significant concern of this mod.
* [[Admin Media Search]] - This mod changes the way that TNG displays all medialinks, and it handles citation medialinks, which are a significant concern of this mod.
* [[Gedcom Import Mediatype]] and [[Gedcom Import Monitor]] are related only in that they also affect the Gedcom Import kickoff form and the Gedcom Import process. Aspects of those mods are ''coordinated'' with this mod, but there are '''no dependencies'' among them and this mod.
* [[Gedcom Import Mediatype]] is related only in that it also affects the Gedcom Import kickoff form and the Gedcom Import process. Aspects of that mods are ''coordinated'' with this mod, but there are '''no dependencies'' between them.
* [[Inner Mod Menus]] This optional, but for me, very important, mod displays a drop-down menu at the right end of the Gedcom Import kickoff-form's "Inner Menu" (where the "Help for this Area" is at the left end). That drop-down menu provides links to the mod's Wiki article and to the mod's options.
* If the ''optional'' [[Show Mod Names]] mod is installed, this mod will utilize its functionality.
* If the ''optional'' [[Show Mod Names]] mod is installed, this mod will utilize its functionality.
=== Files Installed ===
=== Files Installed ===
This mod has two mod subfolders:
This mod has two mod subfolders:
# '''gedcom_import_purge_v12.0.0.5''' - The subfolder that you expect to exist for any mod that installs files. It contains
# '''gedcom_import_purge_v12.0.0.5a''' - The subfolder that you expect to exist for any mod that installs files. It contains
#*'''rrgedcomimportpurge_dbsetup.php''' This is ordinarily run once, from a link in the Mod Manager, to define the new Medialinks table field that keeps track of medialinks that are created by the Gedcom Import. The field is called '''createdfromgedcom'''.
#*'''rrgedcomimportpurge_dbsetup.php''' This is ordinarily run once, from a link in the Mod Manager, to define the new Medialinks table field that keeps track of medialinks that are created by the Gedcom Import. The field is called '''createdfromgedcom'''.
# The shared folder '''RR-shared_mod_includes_v12.0.0.3''', which contains files that support mod option management in many of my mods:
# The shared folder '''RR-shared_mod_includes_v12.0.0.4''', which contains files that support mod option management in many of my mods:
#* '''rrshared_innermodmenu2.php''' - [https://tng.lythgoes.net/wiki/index.php?title=Inner_Mod_Menus Inner Mod Menus]
#* '''rrshared_modsettingsblocks4.php''' - [https://tng.lythgoes.net/wiki/index.php?title=Mod_Settings_Blocks Mod Settings Blocks]
#* '''img/rrshared_wikilogo.gif''' - An icon that links to a mod's TNG Wiki page.
#* '''img/rrshared_wikilogo.gif''' - An icon that links to a mod's TNG Wiki page.
The shared folder is packaged with several mods, each of which may install some or all of its files. 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 generate any Mod Manager errors.
The shared folder is packaged with several mods, each of which may install some or all of its files. 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 generate any Mod Manager errors.
If you unzip mod distribution files directly into your mods folder, then the presence of this second subfolder and the installation of its files should be invisible to you. But if you generally ''copy'' mod subfolders to your mods folder, you need to make sure to copy the folder '''RR-shared_mod_includes_v12.0.0.2''' (well, unless you are confident that it is already in your mods folder because it was part of another mod).
If you unzip mod distribution files directly into your mods folder, then the presence of this second subfolder and the installation of its files should be invisible to you. But if you generally ''copy'' mod subfolders to your mods folder, 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).
{{RobinInstallationBoilerplate}}
{{RobinInstallationBoilerplate}}
{| border="0" cellspacing="1" cellpadding="2" class="wikitable"
{| border="0" cellspacing="1" cellpadding="2" class="wikitable"
! Mod Version !! TNG Version !! Date !! Note
! Mod Version !! TNG Version !! Date !! Note
|- style="vertical-align:top;" <!-- ############################################################## -->
| [[Media:gedcom_import_purge_v12.0.0.5a.zip|12.0.0.5a]]
| 12.0-12.3
| 20Aug2020
| Functional:
# Added a checkbox to the Gedcom Kickoff import form that can suppress the creation of citation medialinks.
# Does not purge places if there is more than one tree but only one places list, since purging places without regard to their use in other trees can break external reference to those places.
Visual & Internal:
# Added a document.ready function in admin_importconfig.php to move a footnote from the bottom of the page to a position right below the text it refers to. The insertion of the Gedcom Import mods made that footnote too far from where it needs to be.
# Fixed two missing %end:% tags that break installation in TNGv12.3
|- style="vertical-align:top;" <!-- ############################################################## -->
|- style="vertical-align:top;" <!-- ############################################################## -->
| [[Media:gedcom_import_purge_v12.0.0.5.zip|12.0.0.5]]
| [[Media:gedcom_import_purge_v12.0.0.5.zip|12.0.0.5]]
| 12.0+
| 12.0+
| 2 Dec 2019
| 2Dec2019
|
|
# Modified the Place purge process so that it does not purge places on sites that have multiple trees and have one shared Places list.
# Modified the Place purge process so that it does not purge places on sites that have multiple trees and have one shared Places list.
| [[Media:gedcom_import_purge_v12.0.0.4.zip|12.0.0.4]]
| [[Media:gedcom_import_purge_v12.0.0.4.zip|12.0.0.4]]
| 12.0+
| 12.0+
| 15 May 2018
| 15May2018
| No functional changes; made compatible with TNGv12.
| No functional changes; made compatible with TNGv12.
| [[Media:textplus_charts_v10.1.0.3p.zip|10.1.0.3p]]
| [[Media:textplus_charts_v10.1.0.3p.zip|10.1.0.3p]]
| 10.1-11.1
| 10.1-11.1
| 26 Mar 2017
| 26Mar2017
| Removed the second line from the cust_text.php target location search string
| Removed the second line from the cust_text.php target location search string
| 10.1.0.3
| 10.1.0.3
| 10.1-11.1
| 10.1-11.1
| 26 Mar 2017
| 26Mar2017
| A technical update that, mostly, just makes [[Show Mod Names]] optional, and avoids a installation conflict introduced by TNGv11.0.1. That is, this version omits the adminlib.php patch that was part of v2 of this mod, and changes this mod's database setup program so that it works independently of that adminlib.php patch (which was fixed in TNGv11.0.1).
| A technical update that, mostly, just makes [[Show Mod Names]] optional, and avoids a installation conflict introduced by TNGv11.0.1. That is, this version omits the adminlib.php patch that was part of v2 of this mod, and changes this mod's database setup program so that it works independently of that adminlib.php patch (which was fixed in TNGv11.0.1).
| 10.1.0.2
| 10.1.0.2
| 10.1-11.0.1
| 10.1-11.0.1
| 25 May 2016
| 25May2016
| Removed a unneeded <script> element that incorrectly referenced an external file, and that - under rare circumstances I still don't understand - could cause the database setup program to log you out from your TNG session. Also fixes a similarly incorrect <script> element in adminlib.php.
| Removed a unneeded <script> element that incorrectly referenced an external file, and that - under rare circumstances I still don't understand - could cause the database setup program to log you out from your TNG session. Also fixes a similarly incorrect <script> element in adminlib.php.
| 10.1.0.1b
| 10.1.0.1b
| 10.1-11.0
| 10.1-11.0
| 25 Mar 2016
| 25Mar 2016
| Fixed an error in a JavaScript warning. Cleaned up the code. Changed the Mod Parameters to strings rather than boolean values to be more tolerant of data entry errors.
| Fixed an error in a JavaScript warning. Cleaned up the code. Changed the Mod Parameters to strings rather than boolean values to be more tolerant of data entry errors.
| 10.1.0.1a
| 10.1.0.1a
| 10.1-10.1.3
| 10.1-10.1.3
| 21 Feb 2016
| 21Feb2016
| No new end-user functionality. Now depends on [[Show Mod Names|Show Mod Names v2+]].
| No new end-user functionality. Now depends on [[Show Mod Names|Show Mod Names v2+]].
| 10.1.0.1
| 10.1.0.1
| 10.1-10.1.3
| 10.1-10.1.3
| 6 Feb 2016
| 6Feb2016
| New mod.
| New mod.
|}
|}
| [[User:Robinrichm|Robin Richmond]]
| [[User:Robinrichm|Robin Richmond]]
| Mod developer
| Mod developer
| 10.1.0.3
| 12.0.0.5a
| 11.1.0
| 12.3
| English
| English
|-
|-