Exploit your RootsMagic family tree database with SQLite Tools
Applications that use SQLite with the RM database or operate on RM’s inputs or outputs.
SQLite Management Tools : a comprehensive table for multiple operating systems but not updated since 2011. The following table describes a few tried by one member of this wiki. The page SQLite Managers for Mac OS looks into some for the Mac. Win Mac Product Review Rating TomH Y N SQLite Expert Personal Free subset…
RootsMagic 7 was released on 25 Nov 2014. It will take some time to answer the following questions: Which SQLite scripts on this wiki need to be revised? Identifying changes in the database design will trigger areas to investigate. Which ones can be retired? Requires comparing the functional capabilities of RootsMagic 7 to those of…
A question by MaryLou1955 about swapping a Name with an Alternate Name prompted this look at an easy way to do it, especially for someone new to SQLite. This page starts by showing how one can answer MaryLou’s question by directly editing the RootsMagic database with a SQLite manager without needing to know anything about…
Another possible candidate for a substitute collation for RMNOCASE is Nunicode. It would have to be compiled into a DLL as a loadable extension for use with certain SQLite managers or incorporated into a custom SQLite application.
Promo Using many of these SQL queries or procedures is pretty easy with a SQLite manager such as SQLiteSpy as illustrated in the example below. Even easier, because you don’t even see the SQL scripts that underlay them, is to use the utilities bundled in the dead simple RMtrix application. The stories following relate the…
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…