Exploit your RootsMagic family tree database with SQLite Tools
I don’t usually post a page here requesting help, but I’ll make an exception in this case. I have created a query that adds rows to the MediaLinkTable. The purpose of the added rows has to do with the fact that I’m an extreme source splitter and therefore I link media files to RM’s Master…
A longstanding wish is for RootsMagic to list sources alphabetically in the Citation Manager rather than in the order they were cited for the particular fact. This would seem to be a fairly trivial programming change but as of RootsMagic 7, it has yet to be delivered. Here is a script that accomplishes the same…
With the flurry of users of Family Tree Maker looking to migrate their database to RootsMagic, an outcry has gained volume because of the disappearance of some citations. This problem was described here in 2012 in Citations Invisible Revealed which offered two scripts, both of which are available in the RMtrix utility, one to find…
N.B. This is now the background page for a pair of revised scripts that supersede the conversion script here and make the process reversible. See Citations Invisible – Reveal and Revert. First reported by Paul Harris in the RootsMagic Forums in the discussion Unused Citations after Import, we have concluded that there is a bug…
In RootsMagic 4 (and maybe still in RM6), merging databases having common people with identical citations has resulted in duplicate citations for the merged person or couple and their events. These are counted in RM’s database properties report but not flagged as a problem and may not be detected until running a report or editing…
Rev 2023-02-23 added versions for #RM8 Getting at a WebTag for a Citation from the Edit Person screen takes many clicks and loses the big picture. If Citation WebTags were also accessible from the WebTags button on the Edit Person screen (and, hopefully, we will soon see this button also on the TimeLine View and…
Description One query lists all the media files in the RM4 Media Gallery and the ID of the Person, Family, Event, Source, Citation or Place to which each is linked. Used in conjunction with other queries, one can look up the media item or find the details about the item to which the media are…
Download: AllCitations+Dupes.sql 2010-07-07 Revised: 2012-02-23 to accelerate family fact citations by 200:1 (in one case) 2011-11-04 to correct spouse and family fact citations Discussions & comments from Wikispaces site Geraniums Runs too long? Geraniums 23 February 2012 12:03:32 I tried running this query, and it ran for nearly an hour and still no results were…
CTE Versions for RM7 and RM8 Revised code by Pat Jones using common table expressions:Version for RM7 and below AllCitations-RM7.sql tested 2021-01-20 Version for #RM8 and above AllCitations-RM8.sql revised 2022-04-27 to include duplicate uses Unlike the old version, this script does not appear to be able to display “headless citations” or “phantom sources or citations”…
This page was stimulated by a question Jerry Bryan posed in the discussion on the Submit Your Problem page about finding and viewing the value of the Page field for a Free Form template. That led to a series of SQLite queries culminating in this one that I thought warranted a page for further discussion…