Exploit your RootsMagic family tree database with SQLite Tools
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”…
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…
The birth of a child is a major life event for a person so I thought it would be worth adding to the stream of events query for a person. This query is designed to be pasted into the AllFacts4Person5.sql file – it follows the same columnar format – or it can be run on…