Exploit your RootsMagic family tree database with SQLite Tools
Design, definitions, structure, operations…
Is it possible to open the databases as read only? Obviously SQLite is opening the database for edit capability. I am getting the database is locked when I have the database open in sqlite and try to open RootsMagic. I am 95% of the time using sqlite for query only. I rarely do an update…
I am trying to put query together that will get the information for the Date, Place, Place Details, Description, Citation, and media fields on the following screen: Pic 1 The put the following query together to get the above information: select et.ownerid, nt.surname, nt.given, et.eventid, et.eventtype, nt.birthyear, ft.Name, et.placeid, et.siteid, substr(et.date,4,4) as Ev_Date, –(select pt.name…
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