Exploit your RootsMagic family tree database with SQLite Tools
2024-08-06 updated script for RM8-10 added Migrants to RootsMagic from other genealogy software are often disappointed in the invisibility of the Marriage Record Identification Number or MRIN and may have a filing system based thereon. While the individual’s record number (RIN) may be preserved in certain imports either in the RootsMagic RIN or in a…
rev 2023-02-20 added version for #RM8 As executed and displayed in SQLiteSpy. This small query returns a list of named groups with the total number of people in each group. It also includes the GroupID number which may be useful for inspecting the GroupTable. It creates a temporary View which is dropped when the SQLite…
Disconnect but preserve Ancestry Sources links for next Upload Subsequent to this script being published 2017-07-21, RootsMagic 7.5 was updated so that its File Option > TreeShare > Disconnect from Ancestry Tree behaves the same way or similarly in that the links with Ancestry Sources are not deleted. RootsMagic 7 Update History is silent on…
Revised scripts for #RM8 and #RM9 added 2023-03-09. Lightly tested – feedback appreciated. This page looks into the challenges involved in converting shared events to individual ones and tries to come up with a solution using SQLite queries (also integrated in the friendly app RMtrix for RM4-7). The Quandary of Shared Events We are caught…
Description Here are the most advanced and useful SQLite queries for reviewing citations in your RootsMagic 4-8 database. They provide some of the same info that you would get in the RootsMagic Source List report and then some you don’t… You have the advantage of sorting and filtering results in ways you cannot within RM…
Update 2021-03-11: scripts work on #RM8. This page stems from weird behaviour that surfaced in a database that suffered from the initial direct TMG import by RM 6.2.3 which created a single parent family for each child (see discussion – link broken in migration from Wikispaces). After running the script Merge Duplicate Single Parent Couples, inspection…
Update 2023-11-22: #RM9 version Problem Description This script responds to a user’s problem posted on FaceBook: she had two databases with overlapping people in them. One was her master with people matched to FamilySearch; the other was developed independently using FamilySearch. Because the duplicated people were created independently, she cannot rely on the RootsMagic File>Compare…
2022-03-24 test with #RM8 successful. RootsMagic has no Merge Source Templates function and it really needs one. When you copy multiple times from one database to another and there are citations involved that use the same custom source template, each time that source template is brought over it is treated as a new source template…
2021-11-22 Compatible with #RM8 See Maps – markers proportional to number of events for an extension of this script to produce results suitable for mapping. This script produces a list that I think is useful for finding the places that lack an abbreviated name or geographical coordinates and for tackling first the ones having the…
2021-11-22 Compatible with #RM8 An earlier script, Places – Frequency of Use, produced a result set that counted the number of events in each Place in a RootsMagic database. This script builds on that query to generate a comma-delimited data set suitable for uploading to GPSVisualizer.com to generate a map with circle markers that are…