Exploit your RootsMagic family tree database with SQLite Tools
This is an ‘upgrade’ from RMGC_Properties – Query #database for pre-RM8 databases. It provides an expansion over the information provided on the RM8 Home – File Properties screen. With a SQLite manager that supports runtime variables, a summary report can be given (just those variables with no leading hyphen). It ATTACHes a reference empty, unused…
UPDATE 2022-05-14: with one fix, there is a procedure in RM8 that would be more attractive operationally than using these outboard scripts: 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).…
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…
RM8 Color Picker Chart with Names & Codes Colors available in RootsMagic 8 color coding. labelled with names and database code numbers. The above chart is an adaptation of a file posted by Lynn Christiansen to facebook Dec 31, 2021. He took a screenshot of the RM8 Color Coding window color picker and labelled each…
RootsMagic 8 introduced indirection between citation data (text fields) and the fact to which a citation is attached, In RM7, the citation data and linkage was combined in the CitationTable. To use the same citation data for more than one fact meant that it had to be replicated in another record, making revisions to the…
Database Diagram for RootsMagic version 8 – there are probably more table relationships to be added.
RootsMagic 8 Community Preview was released Dec 31, 2020. Its database design has been substantially changed from the prior version, rendering much of the information and many of the scripts on this site inapplicable to or unusable with RM8 databases. This page attempts to collect in one spot references to posts and scripts for RM8…
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…
RootsMagic group details are held in the database and can be queried using SQL scripts.