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.
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…
RootsWeb is deactivating its Mailing List service on March 2, 2020, but leaving the archive of each List online, for now. A successor has been set up on Groups.io, operated by users. The old and the new list appeal to those who refuse to participate in the now 21,000 member facebook group and others for…
Search for: The above Search widget is the same as the one visible in the side panel. Tip: tag names imported from Wikispaces are searchable as hashtags, e.g., #events will have narrower results than events. The cloud below of Popular Tags excludes less common ones that may still be found in a post through Search.…
Home A Migration Test Page A Proposal for a Named Group and Color Manager A Query for a To Do List in a Grid Format A Sample Query Created with Views Adding Virtual Columns to an RM4 Table Addresses – How Used Ahnentafel 64 generations All Citations & Dupes Count – Query All Citations –…