Jump to content


Member Since 26 Apr 2008
Offline Last Active Today, 05:36 AM

Posts I've Made

In Topic: Cleaning up FS data

Yesterday, 07:07 AM

I agree that you can safely delete those records from LinkTable that have no match in PersonTable.PersonID or in NameTable.OwnerID. The same would be true for AncestryLinkTable.

When I get unstalled with the SQLiteTools migration, I will update the script. Of course, it's possible RM8 will overtake that process and many other changes will be needed.

In Topic: Clearing Family Search Download from Data

14 October 2018 - 10:15 PM

I don't think there is a way within RM to delete records downloaded from FS other than one at a time. Not at PC so not sure if you can even find or group people that have a FSID. Your best bet may be to revert to the backup you made before you did the download.

There might be a way through a SQLite script but that's mere speculation for now.

In Topic: A beginner setting up a new file

13 October 2018 - 03:46 PM

If you can follow the discipline of pausing sync on whichever computer you are using your RootsMagic database and syncing it after closing the file, that would be the easiest way to share your database among multiple computers. Media files are a challenge because RM stores the file path, not the file data. If the paths are different on the synced computers, then RM will show broken links. You can try using virtual drives or mount points to arrive at a file path common to all your machines.

In Topic: Embarassingly basic sentence question

12 October 2018 - 09:36 PM

There is no SQLite query that can list all fact sentence variables. They are defined in program code. You have to trust the documentation to be complete and accurate.

In Topic: Changing Media File Names

07 October 2018 - 02:28 PM

SQLiteSpy needs the RMNOCASE extension loaded. See https://sqlite4roots... SQLiteSpy.html