SQLite Tools for RootsMagic

Exploit your RootsMagic family tree database with SQLite Tools

Blog

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

Facts – Change Fact Type #facttypes #events

A script that converts all events of one fact type to another in a fraction of a second. Enter the name of the current event as you see it in the Edit Person screen or as you see it in ...
Read More

TreeShare – Rename Cryptic Filenames for Citation Media #TreeShare #media #citations #batch

TreeShare downloads Ancestry media for citations with cryptic file names that mean nothing to humans. This set of scripts and batch or command-line operations prepends to the media filenames the name of one of the persons to whom the citation ...
Read More