Exploit your RootsMagic family tree database with SQLite Tools
Design, definitions, structure, operations…
RootsMagic 7 was released on 25 Nov 2014. It will take some time to answer the following questions: Which SQLite scripts on this wiki need to be revised? Identifying changes in the database design will trigger areas to investigate. Which ones can be retired? Requires comparing the functional capabilities of RootsMagic 7 to those of…
A feature oft-requested that, as of version 6.3.3.2, RootsMagic still does not offer while other software does is the ability to create a new database with custom elements from an existing database. This script works around that shortcoming by copying what might be called “Master Lists” from a developed database to a shell database newly…
This script deprecated in favour of Database – Copy Master Lists to Shell (2014-10-13). Makes an empty Master from current database, preserving custom fact types and source templates, Places, Master Sources and associated Repositories and Addresses, and Place/Source Media. Written for RM4 with instructions to edit for RM5. CustomDatabaseShell.sql There are two ways to do…
I thought I would post some results from a little project I’ve recently been working on. Consider a descendant narrative report in RM in any of the supported formats: outline, NEHGS, etc. In any of these reports, the parents of the spouses will be listed as a part of the birth sentence for the spouse,…
Rev 2019-02-12 Whether you have deleted or merged within RootsMagic itself or used one of the Delete Many procedures, there remain in various tables residues from the deleted targets that unnecessarily clutter the database and may give rise to phantom appearances related to the deleted targets. For very large databases built from many merges, the…
Rebuilding the indexes of large databases using RootsMagic’s File > Database tools > Rebuild Indexes function is ponderously slow, still at version 6.0.0.2. A 162000 person database took over 100 minutes. This page provides procedures that take but a few minutes. In RootsMagic version 5.0.2, the Rebuild Indexes tool was introduced under Menu > File…
There are a number of reasons that it would be desirable or necessary to get out from under the limitations imposed by the proprietary RMNOCASE collation sequence used for indexing (comparing strings) in RootsMagic 4 and 5. Without a SQLite manager that can provide a fake substitute with the same name, there are several key…
This is just curiosity more than anything, but does anybody here know how the infrastructure in RM works to support FSFT? I can’t find any tables that support FSFT, for example, but I’m probably just missing them. For example, how does RM know who in your RM database has been matched against somebody in FSFT…
Work in progress. This query lists tasks related to Individuals, Families (Father’s name only outputted) and General research. Check it out and see if it’s useful. You can run it on the same database as RM4 is using (at your own risk) to assist finding tasks in RM4 or people to work on; alternatively, make…
Lists individuals whose Death Year is missing from RootsMagic Explorer (and other views and reports where just the YEAR is outputted) or mismatches the value that has been stored in the Date field of the Death fact. Adapted from the query Birth Year Mismatch. New: see Rebuild Indexes and Update Birth and Death Years for…