Rename RootsMagic Media Files Downloaded from your Ancestry Tree

Step 1: Install RootsMagic and download your Ancestry tree

The free version (RootsMagic Essentials) will complete this task.

There is a step-by-step pictorial guide in this article on using RootsMagic to back up your Ancestry tree.

Alternatively, this video is a step-by-step walkthrough:

YouTube player

Step 2: Copy the RootsMagic media folder

You will rename the media files in a copy of the RootsMagic folder. We don’t change the original folder or the RootsMagic database.

The RootsMagic media folder is in the same directory as the RootsMagic database. The folder has the same name as the database with “_media” appended to the name.

You can also find the location by opening the Media Gallery and selecting any image. The location is shown under the “Edit Media” sidebar on the right.

The full file path is given in the “Filename” details, so you will also see the folder. I’ve highlighted the portion in the image below from my own computer.

Step 3: Install the SQLite Browser on your local machine

You can download the installer from here.

Step 4: Download a copy of our SQL Script

The DataMiningDNA script is a modified version of Tom Holden’s scripts attached to his article here. The original scripts are designed to rename the files in the RootsMagic media folder and update the RootsMagic database accordingly.

Our script does not update the database, which is why we ask you to run the output in a copy of the media folder.

Step 5: Use the SQLite Browser to run our SQL Script

This video shows you how to download the SQLite Browser application.

The video is using an older version of RootsMagic where the database has a .rgmc extension. With version 9, the database has a .rmtree extension. That’s the file that you open with SQLite.

YouTube player

Margaret created a family tree on a genealogy website in 2012. She purchased her first DNA kit in 2017. She created this website to share insights and how-to guides on DNA, genealogy, and family research.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.