Exploit your RootsMagic family tree database with SQLite Tools
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…
Here are some tricks using a shortcut and a Windows command file (.bat file for old DOS programmers) in conjunction with the command line version of SQLite3. The shortcut, which you can place in your Start menu, on your desktop or wherever it is convenient, calls the batch file and passes the path and name…
RootsMagic 4+ Database Tables – Summary See the sheet “TblSum” on Database Design Spreadsheets.
RootsMagic 4-7 Database Design You will need to know a little about the RootsMagic database to design your own queries and modify others to suit your needs. File Types installed and created by RootsMagic 4+ each .rmgc database file Table Summaries role of each table in the database Database System Catalog tables and indexes along…
The database documentation was done largely on RootsMagic version 6.0.0.2. It’s unlikely that the database schema will change through successive updates. However, any changes may be detected by opening a database created by each version with a SQLite manager, then exporting either a query of the full sqlite_master table or the database schema (just the…
Full screen. | Google Sheet
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…
A feature oft-requested that, as of version 6.3.3.2, RootsMagic still does not offer while other software does is the ability to create a new database with custom elements from an existing database. This script works around that shortcoming by copying what might be called “Master Lists” from a developed database to a shell database newly…
This script deprecated in favour of Database – Copy Master Lists to Shell (2014-10-13). Makes an empty Master from current database, preserving custom fact types and source templates, Places, Master Sources and associated Repositories and Addresses, and Place/Source Media. Written for RM4 with instructions to edit for RM5. CustomDatabaseShell.sql There are two ways to do…
Promo Using many of these SQL queries or procedures is pretty easy with a SQLite manager such as SQLiteSpy as illustrated in the example below. Even easier, because you don’t even see the SQL scripts that underlay them, is to use the utilities bundled in the dead simple RMtrix application. The stories following relate the…