Exploit your RootsMagic family tree database with SQLite Tools
bearing on GEDCOM and direct interchange with other systems and with other RootsMagic databases, e.g., via drag’n’drop…
This page provides some guidance to émigrés from Family Tree Maker to most completely and successful migrate their data to RootsMagic. It includes some operations in FTM itself in preparation for exporting data, the export itself, operations on the GEDCOM file before importing into RM, and then operations in RootsMagic and with SQLite that complete…
This page complements the thread in the RootsMagic Forums titled GEDCOM & DnD Event Description Length Anomalies & Bugs. (2024-01-04 URL updated to The Wayback Machine) It reports issues that arise when the values entered in the Description fields are too long. On this page are links to the backup file of the test database…
Facebook Discussion Forums Discussion EXPERIMENTAL When a TreeShare linked Ancestry Source is Memorised and Pasted through RootsMagic Citation Manager, the pasted source loses its TreeShare link. The TreeShare update to the Ancestry Tree creates a new Other Source rather than linking to the Ancestry Source. This script creates a TreeShare link for such pasted Ancestry…
My RootsMagic file has over 8,500 people in it, 23,000 events, 3,000 families, 3,000 citations, and 3,600 multimedia links I have a query that takes a bit to run. I am using sqlite expert Personal 5.2. I am trying to export the results of the query to a spreadsheet. So far I have not found…
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…
To “Unreverse” something is to restore it from a reversed state. Names inadvertently entered into a name type field in a templated source in “reverse” order, i.e., surname, given are not properly handled by RootsMagic 7 and earlier. The resulting sentences for the Footnote, Short Footnote and Bibliography are screwed up. RootsMagic wants entries for…
Intro WebTags, introduced in RootsMagic 6, are not successfully exported to 3rd party software. One wish is for an export option that would append WebTags to the Note or Comment for the related entity which are supported by GEDCOM 5.5. Until that happens, this special SQLite3 query offers a potential workaround and a possible model…
RootsMagic 7 direct import from Family Tree Maker (not GEDCOM) as of March 2016 imports event descriptions into two different places, depending on the fact type: to the RM event description or to the Place Detail for that event. Some users disagree with that decision and want the FTM event descriptions to remain event descriptions…
With the flurry of users of Family Tree Maker looking to migrate their database to RootsMagic, an outcry has gained volume because of the disappearance of some citations. This problem was described here in 2012 in Citations Invisible Revealed which offered two scripts, both of which are available in the RMtrix utility, one to find…
Problems with GEDCOM In my experience, building an evidence-driven Family Tree on Ancestry.com from evidence found in its databases is faster and easier than extracting the evidence from Ancestry.com and building the documented tree in RootsMagic. But my RootsMagic database remains superior in other respects and is my master database for reporting. So I have…