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
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
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
load more comments