Exploit your RootsMagic family tree database with SQLite Tools
The title of this page was really difficult to compose. It has to do with records in a RootsMagic database’s FamilyTable for which each record pairs the record numbers of a ‘husband’ and a ‘wife’, i.e., columns named “HusbandID” and “WifeID”. Set aside questions of gender. When a person is linked to a single parent,…
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…
When the person highlighted in Pedigree View or Family View is linked to more than one spouse, RootsMagic 7 lets you select the one to be shown from the dropdown Spouse list. This list also offers a “Rearrange spouses” control which sets the order of the spouses in the dropdown list and the order in…
Update 2021-03-11: compatible with RM4 to #RM8 When I ran the RootsMagic 4 Statistics List report on my database, I was startled by the stat for Maximum marriages per person – 7 for one or more males! That did not seem right for my genealogy – maybe it was a merging artifact. What if there…
Update 2021-03-11: #RM8 version by Pat Jones added. Having the married name of a person as an Alternate Name can be useful to those more familiar with it than the birth name as per LessTX’s posting on the Wish List: Add Married Name as Alternate Name and has been requested over the years in these…
The order in which multiple spouses and families are listed in RootsMagic’s Individual Report and in narrative reports is determined by the order that they are also shown in the dropdown list from the Spouses button in the upper left of the Main View window. Some prefer that this order should always be chronological while…