Exploit your RootsMagic family tree database with SQLite Tools
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…
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