RootsMagic group details are held in the database and can be queried using SQL scripts.
Exploit your RootsMagic family tree database with SQLite Tools
A category for pages that don’t fit any other category.
Does not include any pages that have yet to be categorised.
RootsMagic group details are held in the database and can be queried using SQL scripts.
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.
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 or in the Forum. Open full spreadsheet
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 7.9.101. The two files can be compared line by line in Notepad++ using the Compare…
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 FamilySearchTable: replace the former LinkAncestryTable and LinkTable, now gone. TagTable: looks to have replaced LabelTable,…
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 by given names of children (was RM-8) — three_childrens_names.sql– Jerry Bryan, 22 May 2020– This query…
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. I think all the plugins have been tested to the higher level. Wish me luck!
I’ve just discovered that I caused a systemic error in several scripts dealing with Groups in relating the LabelTable.LabelID to the GroupTable.GroupID when the latter is actually related to LabelTable.LabelValue. It’s of no consequence when groups are consecutively created but not deleted because the LabelID and LabelValue match. The problem arises when a group before…
This script does two things: For those persons having one Alternate Name of type “Birth” and a Primary name of “undefined” type, it sets the Alt name as the Primary name and changes the previous Primary name to an Alternate Name. For those persons having more than one Name of type “Birth”, it lists the Record…
I am having trouble setting up this query. I want the results of the first query to merge/join/union with the second query where the ownerid from the first query equals the ownerid from the second query. The bold line should not be part of the query. I put it in to get the records from…