Exploit your RootsMagic family tree database with SQLite Tools
Update 2021-03-11: #RM8 version by Pat Jones added. Having the married name of a person as an Alternate Name can be useful to those more familiar with it than the birth name as per LessTX’s posting on the Wish List: Add Married Name as Alternate Name and has been requested over the years in these…
Problem: MarkVS posted: I have still not tackled the task of going through my RM4 database to merge up events that were originally added separately for each individual (in RM3) but would have been added as a shared event in RM4, and RM5. A Query that would show events that were likely to be suitable…
Update 2021-03-10: tested with #RM8 and minor rev for wider compatibility with SQLite managers (Pat Jones) The complexity of a Source Template is somewhat proportional to the number of fields and their distribution between the Master Source and Source Details (citation-specific). It is probable that a source with a greater number of fields in total…
Intro Builds a group of persons whose lifetime probably spanned a user-defined Census Year and who had some event in the user-defined jurisdiction but not a Census fact for that year. The same script can be used for many named groups having different Census Years and target locations. The script includes examples of building lists…
RM8 replaced Edit Date with UTCModDate Previous versions had an EditDate column in a few tables. In #RM8, these have been replaced by UTCModDate which is present in most tables and appears to serve the same functions, one of which is to populate the “Date Edited” field in the People List view. The “Date Edited”…
Results of the query shown below for a database from RM v8.1.8.0 and available in this Google Sheets: SourceTemplatesByCategory (updated 2022-04-28 for RM8). Category Name InRM4? [AQS inside left] Article, online (unsigned) Y [AQS, inside left] Article, online archive (print publication) Y [AQS, Front] Basic Ancestry Database Template Y [AQS, Front] Basic Ancestry Images Template…
I collect images and files in sporadic flurries under each RootsMagic database’s Media folder intending to use them in the database later on, when I have time. Naturally, I get sidetracked and forget about some of them. So I thought it would be desirable to have a report that listed all the files under the…
2021-11-22 Compatible with #RM8 Have you ever wished to be able to look at all the facts in your family tree database that happened within a day’s horseride of a certain location? Until RootsMagic contains such a report, this adaptation of the LifeLines query helps you view your events for any geographic area in addition…
CTE Versions for RM7 and RM8 Revised code by Pat Jones using common table expressions:Version for RM7 and below AllCitations-RM7.sql tested 2021-01-20 Version for #RM8 and above AllCitations-RM8.sql revised 2022-04-27 to include duplicate uses Unlike the old version, this script does not appear to be able to display “headless citations” or “phantom sources or citations”…
This discussion was started around the Database System Catalog page and all posts up to its continuation on this page can be reviewed in full here. In summary, MarkVS posed this problem: One thing that I wanted to do, and I expect might be of interest to others, is to be able to stream all…