Difference between revisions of "Change ID prefix"

From TNG_Wiki
Jump to navigation Jump to search
(1b correction to tng_associations)
 
(8 intermediate revisions by 4 users not shown)
Line 3: Line 3:
 
|}
 
|}
 
The prefix for IDs for individuals (personIDs) is "I" which is very easily mistaken for "1". This mod allows you to change it to another character, the default being "P" for person. The option to change the prefix already exists in Setup, but if you already have entries in the database, or have imported entries from an offline database which already uses I, then you need change all occurrences in the database.
 
The prefix for IDs for individuals (personIDs) is "I" which is very easily mistaken for "1". This mod allows you to change it to another character, the default being "P" for person. The option to change the prefix already exists in Setup, but if you already have entries in the database, or have imported entries from an offline database which already uses I, then you need change all occurrences in the database.
 +
 +
This version will not change place names, for which there are photos, starting with the same letter.
  
 
==Installation and use==
 
==Installation and use==
Line 10: Line 12:
 
| mod_validation  =  
 
| mod_validation  =  
 
| mod_last_update = 24 Mar 2018
 
| mod_last_update = 24 Mar 2018
| download_link  = [http://mossfamilytree.info/download.php?mod=changeprefix&version=11.1.0.1b 11.1.0.1b]
+
| download_link  = [http://mossfamilytree.info/download.php?mod=changeprefix&version=11.1.0.2 11.1.0.2]
 
| download_stats  = [http://mossfamilytree.info/downloadstats.php?mod=changeprefix show]
 
| download_stats  = [http://mossfamilytree.info/downloadstats.php?mod=changeprefix show]
 
| mod_author      = [[user:Chris Moss|Chris Moss]]
 
| mod_author      = [[user:Chris Moss|Chris Moss]]
Line 18: Line 20:
 
| mod_version    = 11.1.0.1b
 
| mod_version    = 11.1.0.1b
 
| min_TNG_ver    = 10.0
 
| min_TNG_ver    = 10.0
| max_TNG_ver    = 11.1.2
+
| max_TNG_ver    = 12.3
 
| TNG_file_list  =  
 
| TNG_file_list  =  
 
| related_mods    =
 
| related_mods    =
Line 30: Line 32:
  
 
Several mods install tables which contain personIDs. The mod checks those for Census Plus International and Cousins. If the tables aren't found it records the fact. So if you don't have these loaded they will be ignored and a "not found" message will be printed. It may be there are other such mod-tables. If you know of any please let me know.
 
Several mods install tables which contain personIDs. The mod checks those for Census Plus International and Cousins. If the tables aren't found it records the fact. So if you don't have these loaded they will be ignored and a "not found" message will be printed. It may be there are other such mod-tables. If you know of any please let me know.
 +
 +
Note that if you've used hypertext links anywhere which include the ID prefix, these will not be adjusted by the mod and will need to be adjusted manually.
  
 
==TNG version==
 
==TNG version==
Line 56: Line 60:
 
| 11.1.0.1
 
| 11.1.0.1
 
| En, Fr, De
 
| En, Fr, De
 +
|-
 +
| [http://www.colegenealogy.net/ The Cole / Tanner Family Tree]
 +
| [[User:dlcole|David Cole]]
 +
| Public/Private
 +
| [[User:Dlcole|see here]]
 +
| EN, DE, FR, ES, NL
 +
 
|}
 
|}
  
Line 65: Line 76:
 
! Date
 
! Date
 
! Contents
 
! Contents
 +
|-
 +
| 11.1.0.2
 +
| 2 Aug 2020
 +
| Don't tamper with placenames which start with the letter being changed.
 
|-
 
|-
 
| 11.1.0.1a
 
| 11.1.0.1a
Line 75: Line 90:
 
|}
 
|}
  
 
+
[[Category: Mods for TNG v12]]
 
[[Category: Mods for TNG v11]]
 
[[Category: Mods for TNG v11]]
 
[[Category: Mods for TNG v10]]
 
[[Category: Mods for TNG v10]]

Latest revision as of 19:37, 22 April 2021

The prefix for IDs for individuals (personIDs) is "I" which is very easily mistaken for "1". This mod allows you to change it to another character, the default being "P" for person. The option to change the prefix already exists in Setup, but if you already have entries in the database, or have imported entries from an offline database which already uses I, then you need change all occurrences in the database.

This version will not change place names, for which there are photos, starting with the same letter.

Installation and use

Change prefix
Summary Allows a simple change of character set and collation sequence for the TNG database
Validation
Mod Updated 24 Mar 2018
Download link 11.1.0.2
Download stats show
Author(s) Chris Moss
Homepage
Mod Support contact author
Contact Developer contact author
Latest Mod 11.1.0.1b
Min TNG V 10.0
Max TNG V 12.3
Files modified
Related Mods
Notes
only available with English instructions


Download and install the mod in the normal way. Then click on the line for the mod in the mod manager and you will see a button marked "Change database". Click on this and it will change all the tables in the database which have individual ids.

If for any reason you want to revert to the original, click on the Edit options button and swap around the I and P in the $from and $to boxes, pressing Update in each case. You can select any other prefix by putting it in the $to box.

There is also an option called $change here: setting it to 0 will cause the mod to list the number of entries in each table which have the existing ($from) prefix but it won't change anything. Sometimes the same table will show twice if there is more than one field containing personIDs.

Several mods install tables which contain personIDs. The mod checks those for Census Plus International and Cousins. If the tables aren't found it records the fact. So if you don't have these loaded they will be ignored and a "not found" message will be printed. It may be there are other such mod-tables. If you know of any please let me know.

Note that if you've used hypertext links anywhere which include the ID prefix, these will not be adjusted by the mod and will need to be adjusted manually.

TNG version

This has only been tested on TNG11 but it should work on much earlier versions as it has very little dependence on the coding of TNG, including any version that allows the person prefix to be set.

Search engines

Changing the prefix does change the URL of many pages which refer to individuals and will therefore invalidate the references held by Google etc. It is advisable to create or update a site index using Create Site Map Mod.

Don't forget to change any hard links to people that you have on the site, e.g. on the front page.

TNG User sites who have used this mod

If you have installed this mod, please add your TNG sites to the table below.

URL User Note Mod-Version/TNG-Version User-language
http://mossfamilytree.info Chris Moss 11.1.0.1 En, Fr, De
The Cole / Tanner Family Tree David Cole Public/Private see here EN, DE, FR, ES, NL

Revision History

Version Date Contents
11.1.0.2 2 Aug 2020 Don't tamper with placenames which start with the letter being changed.
11.1.0.1a 24 Mar 2018 Add tng_forumthreads and tng_forumposts tables. Thanks Erik.
11.1.0.1b 26 Mar 2018 Add passocID field in tng_associations. Thanks Jürgen.