Exploit your RootsMagic family tree database with SQLite Tools
Sources. Source Templates, Citations, Master Sources, Source Details, Lumping, Splitting, Sorting,, …
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…
Most of the built-in source templates have the comma or period separating a quotation from the rest of a Footnote, Short Footnote or Bibliography sentence (or ending the sentence with a quotation) inside the quotation marks. This is known as ‘US’ style or convention. ‘UK’ or ‘logical’ convention places them outside the quotation. This query…
RootsMagic invited users to submit any issues they are having with the built in source templates as of version 6.3.0.3 in the Forum thread Sentence Templates To Be Fixed on 20 Sep 2013. Extraneous punctuation and text when one or more fields is left empty was identified as an issue and one that the RootsMagician…
Why? The RootsMagic Source List window has an AutoMerge function that can merge Master Sources that are identical in every respect, including the pointer to the Source Template and the name of the Master Source. Thus it fails to merge sources that are practically identical and that we would wish were merged. Source Templates –…
One of the three source templates compared in the study Source Templates, A Comparative Example.pdf was Jeff La Marca’s Simplified Citations – Census. As it did not fare well in the tests, he has objected strenuously and frequently. To eliminate his need to do so every time I post something that refers to the study,…
I haven’t posted here in rather a long time. Here is a little query I wrote to identify Sources without media. By “Sources”, I mean the same thing that RM calls Master Sources, but I think that they should just be called Sources along with their associated Source Details in common with having Places 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…
For a comprehensive comparison of the outputs from !MyFreeForm3, built-in and custom source templates, and Free Form see A Trio of Templates. A Better Free Form Source Template Give me a template that is easy to use, produces good full and short footnotes without extraneous punctuation and exports cleanly via GEDCOM to other software! WARNING:…
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…