Exploit your RootsMagic family tree database with SQLite Tools
Issues This project arose from a request Fix & Merge Hundreds of Newspapers.com Sources in the Forum. The poster is a heavy consumer of the Newspapers.com sources through RM’s TreeShare with Ancestry.com and had issues with: Solution Because the sources were imported via TreeShare, they are Ancestry Record type, i.e., they are created using the…
RootsMagic 6.3.3.2 imports TMG Citation Detail memo field into CitationTable.Fields as the field [CD] defined in the SourceTemplateTable.Fields regardless of TMG memo splitter “||”. An issue which I’m sure many will detect is that sentences for sources with split Citation Detail (CD1, CD2,..) do not contain any of the Citation Detail. The full value is…
Prior to RootsMagic 7’s new Import Lists feature, there was no way from within the program to import custom Source Templates from one database to another except through a laborious, one-at-a-time export to a .rmst file which you would then import, one-at-a-time. Or, alternatively, you would create a source against each custom template for a…
This page brings to bear some SQLite tools in support of Jerry Bryan’s discussion in the RootsMagic forums titled Adventures in Extreme Splitting. In summary, the concept is that every unique citation is a Master Source, i.e., all data fields are to be found in the Master Source, none under Source Details. Jerry’s observations are…
Description Here are the most advanced and useful SQLite queries for reviewing citations in your RootsMagic 4-8 database. They provide some of the same info that you would get in the RootsMagic Source List report and then some you don’t… You have the advantage of sorting and filtering results in ways you cannot within RM…
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…
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…
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…