RM11 Bug – Duplicate Couples from FamilySearch Download – Workarounds
Custom colour coding using SQLite to pop out the areas of erroneous duplication of lineage on this Fan chart by RootsMagic 11.5 for Pauline Christiane Grimmer (GQ5X-3XD) in a database created by a download of ancestors of Helmut Karle Heinle ...
Delete Duplicate Child-Parent(s) Relationships
UPDATE 2026-08-17 This page is NOT applicable to the case described in the Community Forum. Having imported the problem tree branch reported there, I've found that the duplication of ChildParent linkages is due to there being duplicate Couples (two FamilyIDs) ...
CSV: Reverse order, comma count queries #places #AI
Two SQLite queries developed by DeepSeek under my direction:
- Update the Reverse column in PlaceTable from the Name, a comma-separated string
- Count the number of commas in Place Name for each Place
RM-LineageLoopDetector.sql: Uncovering Lineage Loops in RootsMagic Databases
Breakthrough! Something I've wanted for as long as I can remember is a means of detecting lineage loops (an ancestor is their own descendant) in family tree databases created with RootsMagic. This is my second major interaction with Google Gemini ...
Unlocking Your RootsMagic 10 Data: A Deep Dive into SQLite Queries (with AI)
I just finished a session with the free Google Gemini Flash 2.5 model to develop a quite complex query to identify couples in a RootsMagic database who are cousins of each other (see the discussion that led to it in ...
New Page for Tool Requests
Stemming from recent discussion in the RootsMagic Community about the desire for a system to track Feature Requests for the RootsMagic application, I was curious to see what might be readily available and came across a free plugin for WordPress: ...
Custom functions in SQLiteSpy with sqlean extension are mighty and fast!
Intro I first reported on the #sqlean extensions for SQLite3 in my 2022 post In Praise of SQLite. What I did not pick up then that I have just now discovered is that sqlean supports the creation of user-defined or ...
RM9 (now 10) Data Documentation Initiative
Please join me in welcoming Kevin McLarnon ( @kmclarnon ) in the role of Editor on this site and, especially, for volunteering to lead a renewed initiative to improve the documentation we have on the design of the RootsMagic v9 ...
Richard Otter Genealogy Scripts
https://github.com/ricko2001/Genealogy-scripts Richard Otter is a skilled, professional developer who is also a RootsMagic user and has been building a library of scripts that are worthwhile checking out for possible solutions for your own needs. He publishes them on GitGub, list ...
Sources – Newspapers.com – Cleaner Footnotes and Simpler Bibliography
Issues This project arose from a request Fix & Merge Hundreds of Newspapers.com Sources in the Forum. The poster is a heavy consumer of the Newspapers.com sources through RM's TreeShare with Ancestry.com and had issues with:
- A long Source ...
