Tables XI and XM are a list of unused/deleted RINs and MRINs for internal use within Legacy. Each table will only include 500 numbers at a time. They are rebuilt as required by searching for a new batch of unused numbers in the RIN table (IR) or the MRIN table (MR). Neither table is designed to include all the unused/deleted numbers.
Brian Customer Support Millennia Corporation [email protected] http://www.LegacyFamilyTree.com We are changing the world of genealogy! When replying to this message, please include all previous correspondence. Thanks. On 08/02/2011 11:48 PM, Laird wrote: > 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 > > > > 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
