SQLite Tools for RootsMagic

Exploit your RootsMagic family tree database with SQLite Tools

Blog

Privatise Extra BMD Events #events #reports

Problem Many persons in my database have multiple Birth events created from different sources; likewise for other vital facts. Even though I may have marked one as Primary, the others still clutter reports: narratives look like repetitious gobbledygook; calendars have ...
Read More

New RootsMagic-Users Mailing List/Forum

RootsWeb is deactivating its Mailing List service on March 2, 2020, but leaving the archive of each List online, for now. A successor has been set up on Groups.io, operated by users. The old and the new list appeal to ...
Read More

Trying to find duplicate spouses

I am trying to find duplicate spousess. I created the following query: select fatherid, (select n1.surname || ", " || n1.given from nametable n1 where fatherid = ownerid) as fathername, motherid, (select n2.surname || ", " || n2.given from nametable ...
Read More

Backup database open in both SQLite and RootsMagic #backup

Problem Neither the RootsMagic File>Backup nor File>Copy can proceed because the database file "is being used by another process" (RootsMagic's own or your SQLite manager or other outboard SQLite connection). And if you've chosen Backup, RM gracelessly blocks you from ...
Read More

Media Duplicates – Reports and Remedies

Problem TreeShare update operations that add images from Ancestry to the RootsMagic database can result in successive downloads of the same image file saved to a revised name, each added to the Media Gallery and independently tagged to their respective ...
Read More

Updates responding to TreeShare

Working out the wrinkles in a new script addressing some TreeShare issues, I was using some other scripts to help me understand what was going on and ran into a couple of issues that I've fixed:

Events – Add to all Children a Parent event shared with parents #facttypes #sharedevent #relationships

This is a query I wrote just for myself and I didn't feel as if it were of sufficiently general interest to post here. Also, it is not as polished as I like queries to be that I share publicly ...
Read More

DAT File Question #ancestrycom #treeshare #database

I found some discrepancies in RootsMagic and posted a question. This was in an answer: C:UsersTomAppDataRoamingRootsMagicAMT (change the "Tom " to the Windows username. In this folder is a .DAT file for each connected Ancestry Member Tree (AMT). This file ...
Read More

GEDCOM & DnD transfer losses #gedcom

Background RootsMagic Drag'n'Drop between the windows of two databases is a background GEDCOM export-import process. Both Drag'n'Drop and the explicit File>Export and Import process fail to fully transfer everything from one database to another. Drag'n'Drop and GEDCOM are governed by ...
Read More

RMNOCASE – faking it in SQLite Expert, command-line shell et al #rmnocase

SQLite Expert now takes the lead as the most compatible with the RootsMagic RMNOCASE collation, thanks to the C extension unifuzz.dll authored or revised by Jean-Christophe Deschamps. Unifuzz can be used with other SQLite managers that support extensions, including the ...
Read More