Exploit your RootsMagic family tree database with SQLite Tools
Operations on facts and events
#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…
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…
Lists individuals whose Death Year is missing from RootsMagic Explorer (and other views and reports where just the YEAR is outputted) or mismatches the value that has been stored in the Date field of the Death fact. Adapted from the query Birth Year Mismatch. New: see Rebuild Indexes and Update Birth and Death Years for…
Lists individuals whose Birth Year is missing from the sidebar (and other views and reports where just the YEAR is outputted) or mismatches the value that has been stored in the Date field of the Birth fact. This is less of an issue as of RM 5.0.2.0, which incorporates an update of the BirthYear and…
List non-proven Facts. This SQL query will report non-proven facts. This is useful when going though a non-sourced acquired database so you can go though all of the events and find a source for them. Download: Proven.sql Discussions & comments from Wikispaces site ve3meo Does it depend on LDS support turned on? ve3meo 06 April…
Intro John_James posted these requests for help in a post to the Home page: What I would like to do now is clean some data where indi’s have a death event and the gedcom contributor has used a custom “Cause of Death” event so in other words “Details” from “EventType 1021″ into “EventType 2″ where…
RootsMagic recommends that a Marriage fact be added to all couples if it is believed that they were married, even if there is neither proof nor knowledge of the date and place. It might also be said that the Marriage fact could be used to define all manner of unions. This query simply adds a…
Introduction There has been a longstanding wish that RootsMagic would sort events that have no date or the same date (which might be as coarse as just the year) in an order that was natural or logical, e.g., Birth before Death being the simplest and most obvious example. The problem is that RootsMagic will sort…
Initial SortDate Algorithm The SortDate column in the EventTable contains very large numbers that have defied until now any easy method of decoding. After many experiments with date entry and inspection of the stored values, I now have deduced an algorithm that works fine for encoding single, pure dates and decoding corresponding SortDates. Date modifiers…
RootsMagic 4+ Built-In Roles The built-in roles for RM4 and later can be found in RoleTable with RoleID up through 58. User-defined/custom types are assigned values of 59 and higher by the program when created. Built-in roles and their unedited values within the table are as follows: RoleID RoleName EventType RoleType Sentence 1 Witness 1…