Remove Duplicate Merged Notes
Introduction This script was prompted by a discussion in the RootsMagic Community on Feb 10 '23: Notes are duplicated. The duplicate begins with MERGED NOTE. It is not uncommon, viz this Google search for the MERGED NOTE flag generated by ...
Using ChatGPT AI to get help on querying the RM database
Introduction With all the excitement surrounding how well Artificial Intelligence is doing to write papers that can fool teachers and having seen someone post a message about using it to generate some software coding, I was curious to see what ...
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 ...
