Blog

Understanding the Roots Magic 8 Database – Database Diagram #rm8 #database

Database Diagram for RootsMagic version 8 - there are probably more table relationships to be added. Database Diagram as pdf file to download ...
Read More

Understanding the RootsMagic 8 database – Type Decodes #rm8 #datadefinitions

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 ...
Read More

Understanding the RootsMagic 8 database – Ownership #database #datadefinitions #rm8

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 ...
Read More

Group Queries #namedgroup #colorcoding #rm8 #rm7

In RootsMagic 7 group names are stored in the LabelTable and the group members in GroupTable with group id and RIN. The LabelTypes in the LabelTable are 0 – groups, and thus it is the label value field that links ...
Read More

Common Table Expressions – The Building Blocks of SQL

Common Table Expressions (CTE) are a feature that was first introduced to SQL in about 2005 and provide a method of defining a temporary result set then using that in the query as if it were another table. Yes, subqueries ...
Read More

RM8 Data Definitions Spreadsheet #database #datadefinitions

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 ...
Read More

Comparing #Database Definitions RM8 versus RM7 #datadefinitions

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 ...
Read More

First Look at RM8 #Database

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 ...
Read More

Query to Search Parents by Children’s Given Names #search #family

Parents-Three_Childrens_NamesDownload File above incorporates revision from discussion below to correct the count of children. Tested with #rm7 #rm8 and should be compatible with prior versions. TH 2021-03-03 The following script was developed in response to the discussion Search for family ...
Read More

Updating to WordPress 5.4.1

I'm going to attempt an update from WordPress 4.9.14 to 5.4.1 sometime today. The disruption will either be minimal or disastrous. I've made a backup of the files and database. But I'm no WP expert and things may get broken ...
Read More