Exploit your RootsMagic family tree database with SQLite Tools
Operations on named groups
As executed and displayed in SQLiteSpy. This small query returns a list of named groups with the total number of people in each group. It also includes the GroupID number which may be useful for inspecting the GroupTable. It creates a temporary View which is dropped when the SQLite manager closes the database. It requires…
RootsMagic GEDCOM and Drag’n’Drop transfer capabilities and performance leave some things to be desired. Its own File Compare tool shows that differences crop up from the loss of trailing blanks from Notes. Other things are not transferred at all, such as custom default sentences for built-in fact types and roles. The introduction of Ancestry TreeShare…
This page presents a family of scripts that: Creates a SQLite View of Standardized Place names in reverse order N.B.: The Standardized Place field name is [Normalized] and the value is empty unless the Place has been successfully geocoded or the field manually entered. To view the values of the Place [Name] field in reverse order,…
Creates a Named Group in the open database with the name “SQL: Duplicate Events” if one does not already exist Deletes 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 of calendar years (ignoring month…
This query creates or updates a named group of descendants of a given person. This new query is unlimited in the number of generations as it is based on Recursive Queries – Ancestors and Descendants which exploit capability introduced to SQLite in Feb 2014. When run, you will be prompted for the Record Number (RIN)…
This query supersedes Ancestors Named Group which was limited to 12 generations due to its dependence on the non-recursive Ancestors Query. This new query is unlimited as it is based on Recursive Queries – Ancestors and Descendants which exploit capability introduced to SQLite in Feb 2014. When run, you will be prompted for the Record…
Intro RootsMagic 4 users have been seeking an improvement to Named Groups, namely "dynamic refresh" or, at least, a manual refresh button. The idea is that a group’s membership should be updated on demand following the rules that set it up in the first place. Currently, a group is static, requiring the user to edit…
Problem I have some experience with SQL but would like to create a query that would create a named group of Orphans that would contain the people in the file that have no parents, spouses, or children. These people are most likely remnants from deleting trees in my old program that I used. Another reason…
It is daunting to work through the Place List, finding Places and Place Details (sites) that need to be geo-coded (i.e., have latitude and longitude values entered) so that they can be readily mapped and their events included in the Place List report option “Print events near a place”. The larger the database of persons…
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…