Exploit your RootsMagic family tree database with SQLite Tools
This page presents a family of scripts that: Creates a SQLite View of Standardized Place names in reverse order N.B.: The Standardized Place field name is [Normalized] and the value is empty unless the Place has been successfully geocoded or the field manually entered. To view the values of the Place [Name] field in reverse order,…
RootsMagic 7, as does some other software, uses the date of the Christen event as a substitute birth date for age calculations and summary displays when there is no Birth event. But RootsMagic’s own mobile application for iOS and Android does not. Moreover, some users object to using the Christen fact type, on principle or…
This script moves the entire contents of event descriptions of a selected fact type to the Note for that event. If there is already content in the Note, the Description value is appended as a new paragraph. To select a Fact Type, you must use a SQLite manager that supports SQLite run-time variables, such as…
RootsMagic 7 direct import from Family Tree Maker (not GEDCOM) as of March 2016 imports event descriptions into two different places, depending on the fact type: to the RM event description or to the Place Detail for that event. Some users disagree with that decision and want the FTM event descriptions to remain event descriptions…
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…
After importing a TMG project, there is considerable cleanup to be done in the resulting RootsMagic database. There are differences in their respective sentence template languages that cannot translate well or could be translated better (improvement possible in the direct import process). This script addresses some of these outcomes and some unwanted artifacts that could…
Do you have a lot of empty Description fields for facts or events that you would like to fill with short contents from the corresponding Note field? This might be the case for certain fact types after an import from TMG, directly or via GEDCOM. Or maybe you have chosen to enable the Description field…
Purpose This page responds to a request posted in the RootsMagic Forums by Forum member JoyceAE5 on 21 Jan 2014. Basically, what I want is a list of everyone in my database with the following information: Person’s RefNo, Person’s Name, Spouse’s RefNo, Spouse’s Name, Father’s RefNo, Father’s Name, Mother’s RefNo & Mother’s Name Building…
Description This query helps you plot events from your RootsMagic database on Google Maps, Google Earth, and Bing Maps, provided there are geo-coded Places and Place Details (sites) in your database. It generates results in the Keyhole Markup Language (KML) that can be pasted into a KML shell file and then imported into these mapping…
Why? How? Example of an MRIN event added by the script. (click for full size) Main Script | Mismatched FMNO Report | Earlier GEDCOM Solution RootsMagic 6 hides the record number commonly known as MRIN except as an option in the title of the Family Group Sheet and in the Marriage List report. This is…