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.
There is growing interest in the RootsMagic user community in being able to run SQLite Tools for RootsMagic scripts under the Apple MacIntosh operating system. If RootsMagic Inc succeeds in releasing a multi-platform version, then there will undoubtedly be a surge in the number of native-Mac OS users of RootsMagic and corresponding pursuit by some…
You need a SQLite manager such as SQLiteSpy to read and modify a RootsMagic database using the queries or scripts from this wiki. That’s because RootsMagic incorporates the SQLite 3 database engine to write and read its database files. SQLite acts on the database in response to SQL statements or commands it is given. These…
This page has not been updated since 2012 but many scripts have been added since. The tag cloud on the home page and the search control are two good ways to find pages of interest. RootsMagic Queries Many of these were developed around RootsMagic 4 and should also work on RootsMagic 5 and 6 with…
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…