Exploit your RootsMagic family tree database with SQLite Tools
A category for pages that don’t fit any other category.
Does not include any pages that have yet to be categorised.
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) to which the Child is separately linked. So the queries below fail to address the…
Two SQLite queries developed by DeepSeek under my direction: These queries can be adapted to other SQLite database columns that employ comma-separated strings. Problem These queries were created when I was asked to convert Place Details into Places in a very large database with 48,000 records in the PlaceTable. I was able to use my…
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: Simple Feature Requests Free – User Feedback Board By Patrick Garman. I’m not offering to…
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 #database. He is counting on users better-versed than himself in sqlite3 and #RM9 (#RM10) to…
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 of them screenshotted below 2023-05-19. Check for updates and fuller descriptions. He has posted notices…
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: Solution Because the sources were imported via TreeShare, they are Ancestry Record type, i.e., they are created using the…
Introduction This script was prompted by a discussion in the RootsMagic Community on Feb 10 ’23: Notes are duplicated. The duplicate begins with MERGED NOTE. It is not uncommon, viz this Google search for the MERGED NOTE flag generated by RootsMagic. Its results return many pages, from sites.rootsmagic.com and from other sites with content from…
Introduction This procedure responds to a call for help from a RootsMagic user who had received a 40,000 person GEDCOM file in which all the surnames were in capital letters and which he wanted to integrate with a database in which surnames are mixed case. How could the SURNAMES be converted to Surnames without editing…
Issue As for earlier versions, the order in which Citations for a given fact are presented in RM8 is the order in which they were added. Some users wish for them to be sorted alphabetically by name. Solution A brute force method was described for earlier versions at Source Citation Sort . In that case,…
Yeah, really interesting… but you may notice some things are better than they have been: the Forum pages update from your post much more quickly images that previously were illegible and would not open to full size now do Forum It’s bothered me for quite a while that it would take several seconds for a…