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
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
I just saw your comment here but your link to the RootsMagic Community topic on Resetting TreeShare has no comment…
On Media – Set Primary Photo for Persons #media #update
There are a couple of partial solutions: - a SQLite script by me published here: Facts – Change Fact Type…
On RESIDENCE conversion to CENSUS
Solved by @thejerrybryan in a post in the Forum: https://sqlitetoolsforrootsmagic.com/forum/topic/ctes-can-be-useful-in-update-queries/
On Weblinks in footnotes
I've added an explanation of the basic script's processes at https://docs.google.com/document/d/1eXr0z8d2AFuswc2H6wLuUBB4DgOEwzgh8WfVFOmy9kc/edit?usp=sharing
On RM-LineageLoopDetector.sql: Uncovering Lineage Loops in RootsMagic Databases
Wow! What's the subject of your dissertation? I'm impressed that Gemini could ingest the whole spreadsheet. Thanks to @kevinm for…
On Unlocking Your RootsMagic 10 Data: A Deep Dive into SQLite Queries (with AI)
load more comments