Exploit your RootsMagic family tree database with SQLite Tools
Problem RootsMagic provides no means to change all events of one fact type to another fact type, e.g., convert Residence events to Census events or vice versa. Or convert events for a custom fact type to a standard one. All it offers as of version 7.6.3 is to do so for one person, one event…
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…
Update 2021-03-11: added version by Pat Jones for RM8. This page brings together a set of scripts that: adds ‘friendly’ Waymarks in views of each database table to aid in navigating through RootsMagic to the responsible screen and to help understand the role of each table builds a Full Text Search table, first described on…
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…
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…
2023-02-19 Version for #RM8 added. Creates a Named Group in the open database with the name “SQL: Duplicate Events” if one does not already exist Removes all members from that named group Populates that named group with persons having “duplicate” events Duplication is declared if a pair of events: (have dates for which the span…