Exploit your RootsMagic family tree database with SQLite Tools
TestExternalFiles by Richard J. Otter is a new Windows utility that helps identify these issues: A file on disk may get renamed, or moved, breaking the linkfrom the database. A file may be added to the media folder on disk but then not attached to thedesired database element. A file may be added to RM,…
Issue As of writing, still no Book Publisher feature in RM8 and along with other persistent issues, some users wish to return to the RM7.5 database from which they had ‘upgraded’. However, the only ways back using the RM user interface are lossy: #GEDCOM which, along with other attendant losses (see GEDCOM & DnD transfer losses) does…
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…
WARNING 2022-06-18: This script has been found defective in the handling of reused citations – see Comments at the bottom. UPDATE 2022-06-12: a version of the script now imports the RM8 ConfigTable to RM7 as it appears to be compatible with RM7, so far. Because the RM8 import or conversion of a RM7 files seems…
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…