And this was intended to go to the List, too! ---------- Forwarded message ---------- From: Tom Holden <ve3meo@gmail.com> Date: Wed, Sep 24, 2014 at 10:37 PM Subject: Re: [TMG-REFUGEES] RM SQLite renumber RIN/TMG_ID To: LornaMoa <lornamoa@gmail.com> Lorna, you are doing something that sounds quite awesome and which I confess I don't fully understand, not having done anything with DNA testing, nor logging it in RootsMagic, let alone in TMG and I have never scratched the surface of Second Site. When SS imports from RootsMagic I will start looking at it. Your site looks very well organised. You mention custom two-principal tags as a linking mechanism. RootsMagic only supports spousal two-principal events so some other mechanism would be needed in it. Maybe it is a patriarch-descendant fact with the Principal as Patriarch and each descendant is a witness. But that's just imagining... I think for changing a small number of RINs in a large RM database, I would revise the script so that it does not have to update every row of every table. And, it probably would be best if it were wrapped in an application to check that the desired RIN is an unassigned one, else there could indeed be database corruption. Tom On Wed, Sep 24, 2014 at 9:58 PM, LornaMoa <lornamoa@gmail.com> wrote: > Thanks Tom > >>So you cannot combine two TMG projects with overlapping TMG IDs in a > common RootsMagic database and have all the RINs match all the TMG_IDs. I > wonder if you can even do that in TMG. To keep common RINs, yet keep the > persons separate, they must be in separate databases. << > > Fully understood. > And yes, TMG-IDs are unique within a database but there's nothing stopping > us in TMG from using the same id in another database should we wish too. > > The linked projects I'm talking about are currently in two databases (with > some of the individuals having the same id between the two db) because the > end results required are quite separate and my ingenuity within TMG ran out > when trying to keep them only in one AND to show both real parents and DNA > "parents". > Quite apart from which, many of the dna project participants are of no > interest to my personal research, even if they do turn up as dna matches to > the One Name Study people. > > My main database already contains all of my own family research, PLUS two > one name studies, and I happily produce the separate One Name Study > webpages from my main database using flags and contains 10s of 1000s of > people from many years of research. > But the dna website was a step too far given I needed (well wanted) to > show a tested person both with his actual pedigree and with his DNA lineage. > http://dnasurnames.info if you are at all curious. > > I cheat within the dna database so I can show both sets of "parents" for > selected people. > The ones I show on the haplogroup charts are the dna haplogroup branch > "person", with a "son" being the patriarch of the line associated with the > Y/mtdna value, and the "child" being the tested person. > The latter two are duplicated in the database but linked using custom two > principal tags. > In the Lineages aka Surnames section the duplicated people above show up > with normal family relationships, and usually a link to where else they are > published (linked by TMG-ID and smarts in SSite), eg one name study or my > personal family webpages. > > Yes, a RM Gedcom output to SSite would probably work, but for the above > site, as it currently is configured, only if I can control some of the > RINs/TMG_IDs, hence my question about whether your utility would also work > on one person in isolation to change the RIN as opposed over the whole > database. > > Some year I may well rethink the whole thing, but for now, my energy is > directed elsewhere. > > > Lorna Henderson > http://lornahen.com > > > On 25/09/2014 1:10 p.m., Tom Holden wrote: > >> All that this script does is to replace the imported Record Number with >> the numerical value of the TMG_ID fact. I suppose that you could edit the >> TMG_ID value or add a TMG_ID fact to a new person and rerun the script and >> it would change the RIN to match. BUT RIN must be unique and there is no >> control on the TMG_ID fact to ensure that. >> >> So you cannot combine two TMG projects with overlapping TMG IDs in a >> common RootsMagic database and have all the RINs match all the TMG_IDs. I >> wonder if you can even do that in TMG. To keep common RINs, yet keep the >> persons separate, they must be in separate databases. >> >> John Cardinal is developing Second Site to work with RootsMagic extended >> GEDCOM. Maybe there is a possibility for there to be some mechanism by >> which SS websites from two RootsMagic databases may be interlinked. >> >> Another consideration might be an entirely different approach - why two >> databases? Why two websites? Maybe one database outputting two kinds of >> websites? Or one website with filters or two ways of looking at people? >> Maybe your current solution is predicated on the way things work in TMG and >> Second Site and another solution is more appropriate and even better with >> different platforms. >> >> Tom >> >> On Sep 24, 2014, at 6:47 PM, LornaMoa <lornamoa@gmail.com> wrote: >>> >>> A question on the >>Replace the RootsMagic RIN with the TMG_ID number << >>> will that work on a specific RIN/TMG_ID? >>> With TMG's ability to assign numbers on input, or renumber a person >>> after input, I use this in my separate but connected DNA project so that >>> the people (several 100s) that are in both the DNA project and in my main >>> project (many thousands), have the same id. >>> Which means in SecondSite I can create (using the flag event facility) >>> automatic links for interested readers to jump between the two websites >>> (dna/family) >>> >>> So whereas at a conversion to RM yes your utility would be great, >>> ongoing use / divergance could cause me some issues (currently still well >>> into the future for these two projects at least so I can still use SSite to >>> generate web pages) >>> >>> Lorna Henderson >>> http://LornaHen.com >>> >>

If anyone is interested in being able to change RootsMagic record numbers (RINs) whether for the purpose of aligning them with an imported TMG ID value or to some other number for whatever purpose, I have revised my script extensively to do that, providing protection against corruption due to conflicts between the new numbers and the existing ones. It is described and available for download at http://sqlitetoolsforrootsmagic.wikispaces.com/TMG-RM+Convert+TMG_ID+to+Record+Number Tom On Wed, Sep 24, 2014 at 11:07 PM, Tom Holden <ve3meo@gmail.com> wrote: > And this was intended to go to the List, too! > ---------- Forwarded message ---------- > From: Tom Holden <ve3meo@gmail.com> > Date: Wed, Sep 24, 2014 at 10:37 PM > Subject: Re: [TMG-REFUGEES] RM SQLite renumber RIN/TMG_ID > To: LornaMoa <lornamoa@gmail.com> > > > > I think for changing a small number of RINs in a large RM database, I > would revise the script so that it does not have to update every row of > every table. And, it probably would be best if it were wrapped in an > application to check that the desired RIN is an unassigned one, else there > could indeed be database corruption. > > >