Blog

Surname ALL-CAPS to Propercase #names

Introduction This procedure responds to a call for help from a RootsMagic user who had received a 40,000 person GEDCOM file in which all the surnames were in capital letters and which he wanted to integrate with a database in ...

SQLite Error 26 – A Surprising Cause

User could not open their ".rmgc" file, getting this message. A user with this problem could not open their RM7 database file, contacted Tech Support which could not help and was referred by the agent to me. I warned them ...

In Praise of SQLite

Just learned of some interesting things about SQLite in this article that popped up in my Google News feed: In Praise of SQLite by Nikos Vaggalis, dated 28 July 2022. The latest version of SQLite is 3.39.2. I don't monitor ...

New App Aids RM Media Management

TestExternalFiles by Richard J. Otter is a new Windows utility that helps identify these issues:
  • A file on disk may get renamed, or moved, breaking the link
    from the database.
  • A file may be added to the media folder on disk but ...

Convert RM8 Database to RM7 #rm8 #rm7

Issue As of writing, still no Book Publisher feature in RM8 and along with other persistent issues, some users wish to return to the RM7.5 database from which they had ‘upgraded’. However, the only ways back using the RM user ...

Source Citation Sort RM8 #sources #citations

Issue As for earlier versions, the order in which Citations for a given fact are presented in RM8 is the order in which they were added. Some users wish for them to be sorted alphabetically by name. Solution A brute ...

RMTREE Properties Query for RM8

This is an 'upgrade' from RMGC_Properties – Query #database for pre-RM8 databases. It provides an expansion over the information provided on the RM8 Home - File Properties screen. With a SQLite manager that supports runtime variables, a summary report can ...

Site Maintenance & Updates

Yeah, really interesting... but you may notice some things are better than they have been:
  • the Forum pages update from your post much more quickly
  • images that previously were illegible and would not open to full size now do
Forum It's ...

Direct Import of RM8 database into RM7 – Part 2

WARNING 2022-06-18: This script has been found defective in the handling of reused citations - see Comments at the bottom. UPDATE 2022-06-12: a version of the script now imports the RM8 ConfigTable to RM7 as it appears to be compatible ...

Direct Import of RM8 database into RM7 – Part 1

WARNING 2022-06-18: This script has been found defective in the handling of reused citations - see Comments at the bottom of Direct Import of RM8 database into RM7 - Part 2. Issue As described in Returning to RM7.5 custom reports, groups ...