Exploit your RootsMagic family tree database with SQLite Tools
RM9 Color Picker Changed & Color Coding Sets Added Versions prior to RM9 have but one set of color codes; RM9 added 9 more sets for a total of 10, any one of which can be active. Each color in each set and each set can be uniquely labelled to make it easier to understand…
RootsMagic 8 introduced indirection between citation data (text fields) and the fact to which a citation is attached, In RM7, the citation data and linkage was combined in the CitationTable. To use the same citation data for more than one fact meant that it had to be replicated in another record, making revisions to the…
Database Diagram for RootsMagic version 8 – there are probably more table relationships to be added.
RootsMagic 8 Community Preview was released Dec 31, 2020. Its database design has been substantially changed from the prior version, rendering much of the information and many of the scripts on this site inapplicable to or unusable with RM8 databases. This page attempts to collect in one spot references to posts and scripts for RM8…
Many tables within RootsMagic have fields which are know to mean something but do not have lookup tables. So far I have collected the following: (more to follow) Fields named OwnerType – see Understanding the RootsMagic 8 database – Ownership Addresses AddressType field Value Meaning 0 Correspondence 1 Repository Citations The Quality field in the…
The RootsMagic 8 database structure has seen a few changes from RM7 and one of these is that more objects can “own” other objects in the data. A task can have media, citations and web tags for example. To achieve this many tables have an OwnerType field and an OwnerID field and the owner type…
RootsMagic group details are held in the database and can be queried using SQL scripts.
Comparing the CREATE statements for a database file of each version reveals changes to persisting tables in addition to tables deleted and added per First Look at RM8 #Database. This post provides DDL files from RM7.6.5 and the RM8 Preview 7.9.101. The two files can be compared line by line in Notepad++ using the Compare…
File above incorporates revision from discussion below to correct the count of children. Tested with #rm7 #rm8 and should be compatible with prior versions. TH 2021-03-03 The following script was developed in response to the discussion Search for family by given names of children (was RM-8) — three_childrens_names.sql– Jerry Bryan, 22 May 2020– This query…
TBA: Rev 2021-03-0x above script adapted for RM8 by Tom Holden from the #RM7 script described below by the original author, Jerry Bryan. Note that the custom fact type ‘Parents’ and the role ‘Birth_of_Child’ must be created separately in advance of executing this script. This is a query I wrote just for myself and I…