Exploit your RootsMagic family tree database with SQLite Tools
2023-02-19 Version for #RM8 added. Creates a Named Group in the open database with the name “SQL: Duplicate Events” if one does not already exist Removes all members from that named group Populates that named group with persons having “duplicate” events Duplication is declared if a pair of events: (have dates for which the span…
Creates a Named Group in the open database with the name “SQL: Text Dates” if one does not already exist Deletes all members from that named group Populates that named group with persons having an event date that is backgrounded in yellow on the Edit Person screen, i.e., an invalid date format interpreted by RootsMagic…
As of 5.0.4.2, RootsMagic does not provide a comprehensive report on how each entry in the Address List is used – is it merely a Contact or is it the address of a Person or Family (couple) in the tree database? This query provides a list which helps answer that need. RM does provide a…
Rev 2023-02-23 added versions for #RM8 Getting at a WebTag for a Citation from the Edit Person screen takes many clicks and loses the big picture. If Citation WebTags were also accessible from the WebTags button on the Edit Person screen (and, hopefully, we will soon see this button also on the TimeLine View and…
Update 2021-03-11: compatible with RM4 to #RM8 When I ran the RootsMagic 4 Statistics List report on my database, I was startled by the stat for Maximum marriages per person – 7 for one or more males! That did not seem right for my genealogy – maybe it was a merging artifact. What if there…
Description Sharing of facts was a new feature added with RootsMagic 4. A Person or Family in the database (a Principal) is now able to share a fact with others either in a tree in the database file by linking to them or with those not in a tree in the file by indicating name…
Description Sharing of facts was a new feature added with RootsMagic 4. A Person or Family in the database (a Principal) is now able to share a fact with others either in a tree in the database file by linking to them or with those not in a tree in the file by indicating name…
Users can mistakenly add image files to the Media Gallery with the wrong MediaType which prevents the images from being used in reports. MediaType is normally set by user selection in the Add Media Item dialog and cannot be changed from within RootsMagic 6.0.0.2 and earlier. Within RM the only option is to add the…
2021-10-28: The following queries are compatible with #RM8 but, while included in , the app itself is not. If a user has set certain Fact Types to be excluded from GEDCOM export, those fact types are also not transferred to another database via Drag and Drop (DnD). This setting is controlled in the Edit Fact…
#RM8 compatible RootsMagic 4 & 5 fail to clean up all the tables after some entities are merged or deleted. The new Database Tools don’t either. Apart from wasted disk space, there are other more concerning consequences. One is what has been called “Headless Witnesses” – these are RINs found in the WitnessTable for whom…