I have questions about a topic in the archives, so I included previous messages below: http://www.mail-archive.com/[email protected]/msg04740.html ======= I like to keep certain families within a range of RIN's. So when I import a new family I set the new member RINs to begin after the highest RIN. To add family members to a previous family, I select the correct RINs in the range of that family. Before I import into my main database, I import a GEDCOM and tell Legacy to renumber RINs and MRINs starting at _______. I select a number where I want the family to be in my main database. Next I import that Legacy file into my main database and the RINs will mesh within the range I wanted. I have been doing this for the past year of so without any problems. The past few days I had been using tblXI to find the holes in the RIN list to place people, this was a very nice shortcut without manually looking for gaps in the RIN range. Something went wrong and the tblXI results no longer gave realistic numbers. I have tested 18 previous database versions with varying results using Ltools and Legacy. One of my files (97 individuals) has huge numbers of unused/skipped RINs. This number is calculated as follows: (highest RIN - number of individuals) (14,339 - 97) = 14,242 unused in the database, which tblXI reports as only 500. I think this file may be the one I exported a persons descendants from Legacy with about 50 people and added another 47 or so and used IntelliShare to import it back into my main database.
There are about 500 unused RINs in the range of 9,000 to 10,000 in my main database. And 500 is the typical number [incorrectly?] reported in tblXI for most of the files. I do have one database in which the unused counts are much closer i.e. RIN count = 26,944 - 19,133 individuals, calculated = 7,811 vs tblXI = 7,303. I have used a WinXP laptop with Legacy version 7.4.0.45 and a desktop WinVista-64 with Legacy version 7.5.0.47 to enable and disable"Reuse abandoned RINs". I check tblXI before turning on "Reuse abandoned RINs" and then again after turning it off. I also did a File Maintenance> Check/Repair on some of the files and didn't see any difference, but I don't remember which files I this did this. I didn't do a test on tblXM like tblXI, but the MRINs appear to be in the range I would expect. Has anyone had any experience similar to mine? Is there a difference between deleted vs missing/unused RINs? Maybe tblXI is for RINs that been used and then deleted? Maybe this is just an inconvenience for me and there isn't anything wrong with my database. And I should just bite the bullet and go back to determining the missing RINs manually. Thanks for any comments you may have about this. Laird ------------------------------------------------ > Re: [LegacyUG] Missing RINs > > Dennis M . Kowallek > Wed, 19 May 2010 07:16:55 -0700 > > On Wed, 19 May 2010 00:27:00 -0500, Robert Carneal USA > <[email protected]> wrote: > >> Does anyone know of a way to get Legacy to generate a report listing >> the RINs that are empty? >> >> Then the report tells me "7" is not used? > > Robert (and others): > > If you have "Reuse abandoned RINs" turned on, then tblXI contains a list > of the missing RINs. You can run the following query in Access, LTools, > OOBase, etc.: > > SELECT tblXI.DeletedID FROM tblXI ORDER BY tblXI.DeletedID > > If you do not have "Reuse abandoned RINs" turned on, you can turn it on > temporarily. This will cause tblXI to be rebuilt. Then you can run the > above SELECT query. When you are done you can turn off "Reuse abandoned > RINs". > > -- > > Dennis Kowallek (LTools) > http://zippersoftware.com/ltools > http://groups.yahoo.com/group/ltools > Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
