Exploit your RootsMagic family tree database with SQLite Tools
Sources. Source Templates, Citations, Master Sources, Source Details, Lumping, Splitting, Sorting,, …
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…
Update 2021-03-10: tested with #RM8 and minor rev for wider compatibility with SQLite managers (Pat Jones) The complexity of a Source Template is somewhat proportional to the number of fields and their distribution between the Master Source and Source Details (citation-specific). It is probable that a source with a greater number of fields in total…
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…
Results of the query shown below for a database from RM v8.1.8.0 and available in this Google Sheets: SourceTemplatesByCategory (updated 2022-04-28 for RM8). Category Name InRM4? [AQS inside left] Article, online (unsigned) Y [AQS, inside left] Article, online archive (print publication) Y [AQS, Front] Basic Ancestry Database Template Y [AQS, Front] Basic Ancestry Images Template…