Exploit your RootsMagic family tree database with SQLite Tools
Working out the wrinkles in a new script addressing some TreeShare issues, I was using some other scripts to help me understand what was going on and ran into a couple of issues that I’ve fixed: RM7_5_WaymarksViews.sql was not reporting family events (e.g., Marriage) and that affected other views which relied on the EventWay view. DeletePhantoms3.sql did…
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;…
RootsMagic 7 is very cautious about deleting Places and Place Details, allowing only one at a time and requiring user confirmation of the “Are you sure?” type. This script is the absolute opposite and deletes all unused Places without hesitation. Were you to transfer your database by drag’n’drop or via GEDCOM to a new database,…
The title of this page was really difficult to compose. It has to do with records in a RootsMagic database’s FamilyTable for which each record pairs the record numbers of a ‘husband’ and a ‘wife’, i.e., columns named “HusbandID” and “WifeID”. Set aside questions of gender. When a person is linked to a single parent,…
Rev 2019-02-12 Whether you have deleted or merged within RootsMagic itself or used one of the Delete Many procedures, there remain in various tables residues from the deleted targets that unnecessarily clutter the database and may give rise to phantom appearances related to the deleted targets. For very large databases built from many merges, the…
Orphaned Place Details On integrating these queries into the RMtrix bundled utilities, I found it necessary to revise them extensively, partly because they do not safely or efficiently address those orphaned Place Details that are actually used by a fact/event in the database. Moreover, without the foreknowledge of the names of the Place Details, it…
Tree imported from Ancestry.com via Family Tree Maker 2012 has phantom spouses. “Phantom” in this case defined as being unnamed, not existing in the PersonTable (i.e. PersonID=0) and childless. Yet they count in RootsMagic Find “Number of spouses” criterion and may cause other unwanted behaviour. To find persons having such a phantom spouse: SELECT FamilyID,…
This query deletes from the CitationsTable those records that have no associated record in the SourceTable. These ‘phantom’ sources or ‘orphaned’ citations manifest themselves in the Edit Person screen as citations that return nothing when opened, are counted in the File > Properties report and may have odd effect in other reports. The query is…