Exploit your RootsMagic family tree database with SQLite Tools
TestExternalFiles by Richard J. Otter is a new Windows utility that helps identify these issues: A file on disk may get renamed, or moved, breaking the linkfrom the database. A file may be added to the media folder on disk but then not attached to thedesired database element. A file may be added to RM,…
This is NOT SQLite! Rather, RMπ (RMpi) is a little application that tweaks a GEDCOM file you want imported into RootsMagic for potentially more complete data transfer. More development may come later but it could be useful now, especially to early emigres from The Master Genealogist 9.0.3 and earlier. Perhaps equally importantly for exchanges between…
RootsMagic 8 has changes to its database design that render many of the items in RMtrix unusable. It will throw an unhandled exception error in most, if not all, cases. RMtrix collects a bunch of SQLite queries under a simple, easy-to-use interface. It does many of the queries reported on this wiki – some of…
This page gathers links to the RootsMagic utilities developed by R. Steven Turley. 2012-11-08 Copying Custom Reports copies a custom report from one database to another. 2012-11-08 Source Template Maintenance list all of the sources using a particular template find a template containing certain phrases list those custom templates I have created list the templates…
The RMSplit C# program below allows you to create a group in RootsMagic5 which contains a selected person, their ancestors, and a selected number of “leaves” (collateral lines us a given depth). If you choose one leaf, you will get children of everyone in the direct line (and their spouses if that is checked). If…
Source code The following paragraphs are extracted from private messages from Tom, davistom1, who kindly agreed to their being brought onto a page for wider dissemination. He talks about the relationship between his RM4 database and media collection and two websites he operates, one a webtrees, the other GenWeb, both worth a visit. He developed…
As of 2012 and following the release of RootsMagic 5, a small team of enthusiasts is embarking on a software project to consolidate the various SQLite queries reported on this wiki into a user-friendly application, accessible to more RootsMagic users. Additional utilities will, hopefully, be added once the basics are running. The project team is…
I like this: RMtrix has a magical element to it in the sound alike to “tricks” with an appropriate implication as to what the software does – it carries out tricks on the RootsMagic database. Also can work as an acronym: RM obviously, tools or tricks, repairs, information, experiments or an algebraic unknown variable, x,…
I’m going to write this up as a free standing utility program that performs only one function. But of course I would prefer that it be included in a bundled and comprehensive utility program. The proposal is for a Named Group and Color Coding Manager for RM5. This intent is to supplement the Named Group…
This page is intended to stimulate some discussion about developing utilities for RootsMagic in a high level programming language. Please add your thoughts. Would you be interested in: using utilities that do things RootsMagic does not currently do? developing such utilities? testing? Development Platform? I had been setting up an old Borland Delphi 4 with…