Exploit your RootsMagic family tree database with SQLite Tools
2022-03-24 test with #RM8 successful. RootsMagic has no Merge Source Templates function and it really needs one. When you copy multiple times from one database to another and there are citations involved that use the same custom source template, each time that source template is brought over it is treated as a new source template…
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…
Introduction This query introduces a radical variation on RootsMagic’s system of Source Templates. It combines Source Templates and Free Form properties into Versatile Free Form Hybrid Source Templates incorporating the best of both worlds. Sources built on older source templates will now have free form fields that can be used to create alternative sentences that…
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…
Why? This page is in response to the request from RootsMagic Forums member JoopvB: Repositories from TMG. He asked: Anybody an idea how to kind of copy the Repository (Info) from the address table to wherever it needs to be to be used in the source sentence? I guess I would need to create the…
I probably should post this more as a question than as a new wiki page, but here goes anyway. I’m continuing apace with my project to convert all my sources into extremely split sources. As such, I ran into an interesting situation. I now have several dozen obituaries that have been entered as extremely split…
This script deprecated in favour of Database – Copy Master Lists to Shell (2014-10-13). Makes an empty Master from current database, preserving custom fact types and source templates, Places, Master Sources and associated Repositories and Addresses, and Place/Source Media. Written for RM4 with instructions to edit for RM5. CustomDatabaseShell.sql There are two ways to do…
This page collects info and queries about Source Templates. A Trio of Templates Framing Citations of the 1930 US Census with RootsMagic 5 Free Form, Standard and Custom Source Templates. This is a 15 page study of the usage and results of three very different templates, coming to the conclusion that RootsMagic 5’s Source Template…
In RootsMagic 4 (and maybe still in RM6), merging databases having common people with identical citations has resulted in duplicate citations for the merged person or couple and their events. These are counted in RM’s database properties report but not flagged as a problem and may not be detected until running a report or editing…
Why? The RootsMagic Source List window has an AutoMerge function that can merge Master Sources that are identical in every respect, including the pointer to the Source Template and the name of the Master Source. Thus it fails to merge sources that are practically identical and that we would wish were merged. Source Templates –…