Exploit your RootsMagic family tree database with SQLite Tools
WARNING 2022-06-18: This script has been found defective in the handling of reused citations – see Comments at the bottom. UPDATE 2022-06-12: a version of the script now imports the RM8 ConfigTable to RM7 as it appears to be compatible with RM7, so far. Because the RM8 import or conversion of a RM7 files seems…
UPDATE 2022-05-14: better than GEDCOM is to convert directly from RM8 to RM7 for which there are a couple of possibilities: RM8’s File > Export Data > DropBox creates a copy of the active .RMTREE file to a RM7 compatible .RMGC file intended for use with the RootsMagic Mobile app (now retired for Android). It…
Database Diagram for RootsMagic version 8 – there are probably more table relationships to be added.
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…
Thanks to member momakid, we have a new spreadsheet of data definitions available on Google Sheets. The new fields in RM8 are not completely described so your input is welcome. You may comment directly on the spreadsheet, on this page or in the Forum. Open full spreadsheet
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…
More changes than expected with the result that many (most?) of the queries and scripts published on this site won’t work with RM8 databases. New Tables CitationLinkTable: was expected to support the announced new feature of master citations. AncestryTable and FamilySearchTable: replace the former LinkAncestryTable and LinkTable, now gone. TagTable: looks to have replaced LabelTable,…
Problem TreeShare update operations that add images from Ancestry to the RootsMagic database can result in successive downloads of the same image file saved to a revised name, each added to the Media Gallery and independently tagged to their respective subjects. I don’t think this is either necessary or desirable (maybe there is a good…
I found some discrepancies in RootsMagic and posted a question. This was in an answer: C:\Users\Tom\AppData\Roaming\RootsMagic\AMT (change the “Tom ” to your Windows username). In this folder is a .DAT file for each connected Ancestry Member Tree (AMT), named “AT-AncestryTreeID.DAT”, where AncestryTreeID is an integer. This file is a SQLite database containing tables named identically…