Blog

I am having trouble setting up this query. I want the results of the first query to merge/join/union with the second query where the ownerid from the first query equals the ownerid from the second query. The bold line should ...
Read More

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

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

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

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

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

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:

• RM7_5_WaymarksViews.sql was not reporting ...
  Read More

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

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

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