Exploit your RootsMagic family tree database with SQLite Tools
Design, definitions, structure, operations…
WARNING 2022-06-18: This script has been found defective in the handling of reused citations – see Comments at the bottom. UPDATE 2022-06-12: a version of the script now imports the RM8 ConfigTable to RM7 as it appears to be compatible with RM7, so far. Because the RM8 import or conversion of a RM7 files seems…
UPDATE 2022-05-14: better than GEDCOM is to convert directly from RM8 to RM7 for which there are a couple of possibilities: RM8’s File > Export Data > DropBox creates a copy of the active .RMTREE file to a RM7 compatible .RMGC file intended for use with the RootsMagic Mobile app (now retired for Android). It…
I am trying to find duplicate spousess. I created the following query: select fatherid, (select n1.surname || “, ” || n1.given from nametable n1 where fatherid = ownerid) as fathername, motherid, (select n2.surname || “, ” || n2.given from nametable n2 where motherid = ownerid) as mothername from familytable order by fatherid, motherid; 1. Should…
Problem Neither the RootsMagic File>Backup nor File>Copy can proceed because the database file “is being used by another process” (RootsMagic’s own or your SQLite manager or other outboard SQLite connection). And if you’ve chosen Backup, RM gracelessly blocks you from further work with an always-on-top fake news message window “Creating backup file…” requiring closure of…
Problem TreeShare update operations that add images from Ancestry to the RootsMagic database can result in successive downloads of the same image file saved to a revised name, each added to the Media Gallery and independently tagged to their respective subjects. I don’t think this is either necessary or desirable (maybe there is a good…
I found some discrepancies in RootsMagic and posted a question. This was in an answer: C:\Users\Tom\AppData\Roaming\RootsMagic\AMT (change the “Tom ” to your Windows username). In this folder is a .DAT file for each connected Ancestry Member Tree (AMT), named “AT-AncestryTreeID.DAT”, where AncestryTreeID is an integer. This file is a SQLite database containing tables named identically…
Here are some tricks using a shortcut and a Windows command file (.bat file for old DOS programmers) in conjunction with the command line version of SQLite3. The shortcut, which you can place in your Start menu, on your desktop or wherever it is convenient, calls the batch file and passes the path and name…
Problem I was going through my database looking for United States of America and USA in the Place, Place Details and Description fields on the Edit Person screen. I am using the following query for the Place field: — Place with less than greater than.sql SELECT e.eventid, e.placeid, –e.siteid, e.familyid, e.ownertype, — 0 = person;…
Is it possible to open the databases as read only? Obviously SQLite is opening the database for edit capability. I am getting the database is locked when I have the database open in sqlite and try to open RootsMagic. I am 95% of the time using sqlite for query only. I rarely do an update…
I am trying to put query together that will get the information for the Date, Place, Place Details, Description, Citation, and media fields on the following screen: Pic 1 The put the following query together to get the above information: select et.ownerid, nt.surname, nt.given, et.eventid, et.eventtype, nt.birthyear, ft.Name, et.placeid, et.siteid, substr(et.date,4,4) as Ev_Date, –(select pt.name…