Exploit your RootsMagic family tree database with SQLite Tools
Operations on facts and events
I have recently added a Parents “fact” to everyone in my RM database who has parents. These Parents events really are new rows added to the EventTable, even though parentage is already denoted in RM by entries in the ChildTable joined with entries in the FamilyTable. The reasons for the new events are two-fold. First,…
I recently went through an exercise of removing all sentence customization for specific events in my RM database. The purpose of this change was to allow my Point Form sentence templates from the Fact Type Table to be used in all cases. It is not possible in the RM user interface to search for specific…
This page presents a family of scripts that: Creates a SQLite View of Standardized Place names in reverse order N.B.: The Standardized Place field name is [Normalized] and the value is empty unless the Place has been successfully geocoded or the field manually entered. To view the values of the Place [Name] field in reverse order,…
An earlier script copied the FamilySearch Family Tree ID into the Reference Number fact. One user uploaded a file to an Ancestry Member Tree where it was grown through online evidence-based research and then downloaded the GEDCOM back into RootsMagic. RootsMagic’s Auto-Match feature in FamilySearch Central failed to rematch all the previously matched people. However,…
RootsMagic 7, as does some other software, uses the date of the Christen event as a substitute birth date for age calculations and summary displays when there is no Birth event. But RootsMagic’s own mobile application for iOS and Android does not. Moreover, some users object to using the Christen fact type, on principle or…
Update 2023-11-22: #RM9 version Problem Description This script responds to a user’s problem posted on FaceBook: she had two databases with overlapping people in them. One was her master with people matched to FamilySearch; the other was developed independently using FamilySearch. Because the duplicated people were created independently, she cannot rely on the RootsMagic File>Compare…
Problem The order in which witnesses of an event (sharers other than the Principal(s) are listed on screen and in reports is set by the order they were entered. Users have no control over it. A Workaround The WitnessOrder field in WitnessTable controls the order of output in the display of witnesses and in narrative…
Based on discussion in the RootsMagic Forums topic Display & report children’s births
This script moves the entire contents of event descriptions of a selected fact type to the Note for that event. If there is already content in the Note, the Description value is appended as a new paragraph. To select a Fact Type, you must use a SQLite manager that supports SQLite run-time variables, such as…
RootsMagic 4-7 (current) list the user-added roles in the Edit Fact Type dialog in the order that they were created, after the builtin roles such as Principal and Witness. For fact types to which many roles have been added, it is desirable that they be sorted alphabetically. While this should easily be done within the…