Exploit your RootsMagic family tree database with SQLite Tools
Operations that affect RootsMagic reports or provide a report missing from RM
This script sets private the events, alternate name facts, and personal notes for persons whose Living flag is set. Thus, reports and GEDCOM can take full advantage of the options: Privatize living people (GEDCOM only) Include private facts Include {private} notes Strip { } brackets thus providing many more combinations by which these outputs may…
Work in progress. This query lists tasks related to Individuals, Families (Father’s name only outputted) and General research. Check it out and see if it’s useful. You can run it on the same database as RM4 is using (at your own risk) to assist finding tasks in RM4 or people to work on; alternatively, make…
I’ve discussed this query before, but this is my first attempt to post a real, live query in both MS Access and SQLite formats. At the present time, my To Do grid only includes 17 rows and 2 columns but I will be adding additional rows and additional columns. I should mention up front that…
Paragraph control in the narrative reports in RootsMagic 4 and 5 leaves much to be desired. A richly facted person with many notes will be described in one long paragraph, apart from any paragraphing within the body of a fact note, unless special non-intuitive measures are taken. Likewise, another long paragraph of family facts and…
2021-10-28: The following queries are compatible with #RM8 but, while included in , the app itself is not. If a user has set certain Fact Types to be excluded from GEDCOM export, those fact types are also not transferred to another database via Drag and Drop (DnD). This setting is controlled in the Edit Fact…
Unlike the names of persons, RootsMagic 6 does not yet have any mechanism for automatically revolving through Place names in reports, i.e., using the full place name only if it has not been previously used for a person while taking advantage of the first or lowest level place name or the abbreviated place name for…
RootsMagic 5 and below support for Ahnentafel numbering is limited to 32 bits, or 32 generations, even though the report allows the user to select a larger number. If the report does run over 32 generations, the Ahnentafel number starts over and is therefore incorrect. This query demonstrates that SQLite itself can support a 64…
RootsMagic 4 allows one to add a DNA Test fact to a person and enter the results of two types of test. However, there is no report available for the results making it difficult to verify that all data have been accurately transcribed. The results are stored in the EventTable Details column in XML format,…
Microsoft Excel is a great tool for filtering/sorting/reporting on data in a Grid format. It also provides additional features such as various sorts of in-built graphs based on the data you are using as well as providing, for more advanced users, in-built calculation functions (formulas) that can be used to manipulate the data. Naturally, as…
RootsMagic 4 updates in the 4.0.9.x series to 4.0.9.3 should install this file in the RootsMagic 4 program directory. For some reason, some installations fail to do so. The result is that reports cannot be saved to PDF format and an error message indicates that the file cannot be found. Downloading this file to the…