SQLite Tools for RootsMagic

Exploit your RootsMagic family tree database with SQLite Tools

Tom Holden

Upload
Change your cover photo
Upload
Apply Cancel
Tom Holden
Tom Holden
This user account status is Approved
About About
Posts Posts
Comments Comments
Hi @momakid, Your comment today is outside the subject of the subject of the original tool request and the website…
On List all events in eventable with facts > 1
UPDATE 2026-08-27: replaced two queries that proved to be unusably slow on larger databases with far faster ones.
On RM11 Bug – Duplicate Couples from FamilySearch Download – Workarounds
UPDATE 2026-08-26: added Purple to colorcoding to highlight significant children; replaced image zoom on click to open in browser.
On RM11 Bug – Duplicate Couples from FamilySearch Download – Workarounds
Updated for RM 11, changed date prefix to 'by' instead of 'before', added update to 'Date last edited' for People…
On Births – Add from Christening or Baptism #birth #events
Hi Peggy, I have just now revised the query to take advantage of an improvement is SQLite syntax (or my…
On Media – Set Primary Photo for Persons #media #update
That's an intriguing question and is a feature that is not provided by any of the mainstream family tree software.…
On Tool for calculating the Coefficient of Relationship
If Relate2=0 and 0 < Relate1 < 999 for a person, then that is a descendant of the reference person.…
On Color Code by Consanguinity Degree #colorcoding #relationships
What RM version are you using? The procedure was developed for RM7. The text says it "should work on RM8…
On Sources – Newspapers.com – Cleaner Footnotes and Simpler Bibliography
There's no new tool required. If you click on the tag #rmnocase in the sidebar and look for the subjects…
On rmnocase
I've adapted my script referenced above and the OP has used it successfully. I may publish it after possibly generalising…
On RESIDENCE conversion to CENSUS
load more comments