Exploit your RootsMagic family tree database with SQLite Tools
Operations on persons and families and relationships, esp on PersonTable, FamilyTable and ChildTable.
Update 2021-03-11: scripts work on #RM8. This page stems from weird behaviour that surfaced in a database that suffered from the initial direct TMG import by RM 6.2.3 which created a single parent family for each child (see discussion – link broken in migration from Wikispaces). After running the script Merge Duplicate Single Parent Couples, inspection…
A member of the RootsMagic-Users Facebook Group posted this question: =====Ted Duffy===== February 3 at 11:04am I just imported my Legacy Family Tree database into RM7. Many of my female ancestors now have exact duplicate Alt Name Facts in RM7. Is there a way to bulk delete these duplicates? Of course, the answer is not…
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…
This page is intended to collect some scripts in support of calculating and displaying relationships between people in a RootsMagic database. Kinship List This first script produces a table similar to the RootsMagic Kinship List report but it does so markedly faster for a large database. RootsMagic 7.0.11.0 took almost five minutes (290s) to calculate…
Trees Two related problems 1) Finding all names in a selected person’s tree 2) Count Trees 1) Finding all names in selected person’s tree Does anyone have any idea how to emulate the function that is in the RM Mark Group of “Everyone in the highlighted person’s tree”? RM does this very efficiently/quickly.I break the…
Stats-MaxChildren.sql 2016-02-12 Result from Stats-MaxChildren.sql in SQLiteSpy
When the person highlighted in Pedigree View or Family View is linked to more than one spouse, RootsMagic 7 lets you select the one to be shown from the dropdown Spouse list. This list also offers a “Rearrange spouses” control which sets the order of the spouses in the dropdown list and the order in…
Why? RootsMagic has three different storage mechanisms for Nicknames: Nickname field in each Name record In quotation marks or parentheses in the Given field of each Name record As above in a Name record of type “Nickname” Different outputs from RootsMagic have differing usage of these. Box charts cannot use Alternate Names and only include…
As of Feb 3, 2014 and version 3.8.3, SQLite introduced “Recursive common table expressions (that) provide the ability to do hierarchical or recursive queries of trees and graphs, a capability that is not otherwise available in the SQL language”. (http://www.sqlite.org/lang_with.html) This means it is now possible to generate ancestry or descendancy lists within SQLite, without…