Exploit your RootsMagic family tree database with SQLite Tools
2024-08-06 updated script for RM8-10 added Migrants to RootsMagic from other genealogy software are often disappointed in the invisibility of the Marriage Record Identification Number or MRIN and may have a filing system based thereon. While the individual’s record number (RIN) may be preserved in certain imports either in the RootsMagic RIN or in a…
Revised scripts for #RM8 and #RM9 added 2023-03-09. Lightly tested – feedback appreciated. This page looks into the challenges involved in converting shared events to individual ones and tries to come up with a solution using SQLite queries (also integrated in the friendly app RMtrix for RM4-7). The Quandary of Shared Events We are caught…
RootsMagic 4+ Database Design You will need to know a little about the RootsMagic database to design your own queries and modify others to suit your needs. A picture is worth many words so here is a series of Entity Relationship Diagrams by different authors: RM9 Database Diagram #rm9 #database Roots Magic 8 Database –…
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…
RootsMagic 4+ Built-In Fact Types 2023-05-22 updated to RM9 The built-in fact types for RM4 and later can be found in the FactTypeTable with FactTypeID less than 1000. User-defined/custom types are assigned values of 1000 and higher by the program when created. Between RM4 and RM9, only the 902-Associations fact type has been added. There…
2025-03-01 FactsHavingPlaceDetails_RM10.sql version 3 updated to support the Association fact type introduced in #RM9 2025-02-28 All scripts below function with all versions from #RM4 to #RM10 but without support for Associations. FactsHavingPlaceDetails3.sql Returns all Places with Place Details and the Persons or Families (couples) and their Facts, including Shared events, using the Place Detail. Results…