Exploit your RootsMagic family tree database with SQLite Tools
Design, definitions, structure, operations…
Pic 1 The explanation for the Details field in the EventTable of the Data Definitions states Content of Description field in Edit Person fact/event pane. Pic 2 I take that to mean it should contain Marital Status: MarriedRelation to Head of House: Head in the above print screen. I created the following query to get…
ConfigTable RecID 1 DataRec Default The first record of ConfigTable consists of XML in the RecID field that stores various database file settings. The current version and its data can be restructured and displayed as follows (Values column to be verified): See sheet “ConfigTableDefaultRec1” on Database Design Spreadsheets.
RootsMagic 4+ creates a database file with the same root name as the .rmgc file but with the extension .DUP when Tools > Merge > Duplicate Search Merge is started. It contains one table that serves the Merge dialog until it is exited. This database is unused thereafter until the next Duplicate Search Merge is…
RootsMagic 4+ Data Definitions See spreadsheets “DataDefsMstr” and “DataDefsFieldSort” on Database Design Spreadsheets. Discussions & comments from Wikispaces site romermb Adding To/Updating File romermb 08 January 2010 21:35:48 A few of us so far have been trying to add the Notes, etc details to the various table fields in the file referenced in this page.…
RootsMagic 4+ Database Tables – Summary See the sheet “TblSum” on Database Design Spreadsheets.
RootsMagic 4+ 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. A picture is worth many words so here is a series of Entity Relationship Diagrams by different authors: RM9 Database Diagram #rm9 #database Roots Magic 8 Database –…
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
RootsMagic 7 was released on 25 Nov 2014. It will take some time to answer the following questions: Which SQLite scripts on this wiki need to be revised? Identifying changes in the database design will trigger areas to investigate. Which ones can be retired? Requires comparing the functional capabilities of RootsMagic 7 to those of…
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…