Exploit your RootsMagic family tree database with SQLite Tools
Search techniques
RootsMagic 6 has a very powerful search tool under the main menu item Search > Find Everywhere… However, it really falls short of everywhere, omitting a number of tables and fields within the tables it does search. Notably, it omits the: AddressTable (Repositories, Contacts, Correspondence) FactTypeTable (Fact Types) SourceTemplateTable (Source Templates) URLTable (WebTags) WitnessTable (non-Principals…
Update 2021-03-11: added version by Pat Jones for RM8. This page brings together a set of scripts that: adds ‘friendly’ Waymarks in views of each database table to aid in navigating through RootsMagic to the responsible screen and to help understand the role of each table builds a Full Text Search table, first described on…
Restricted in RootsMagic RootsMagic 4 users are sometimes frustrated that they cannot do a search or search/replace on certain fields within the application. RM4’s Search & Replace is especially restricted to a small set of fields: Person name fields, Place name, Multimedia filenames and Notes (General, Family & Facts). SQLite opens up all fields to…
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:…
Producing a list of names from your database similar to what is found by RootsMagic 4’s Search > Person List > NameFind, this query does it faster. Moreover, you can sort and filter the results, not supported in RootsMagic Explorer’s NameFind. As a list, it may prove handy to use in conjunction with RM Explorer’s…