DBeaver Heredis 2023 and RootsMagic 9
They say a picture is worth a thousand words. This page compares pictures of the #RM9 and Heredis 2023 databases (both SQLite 3) as automatically created by the same tool. Entity Relationship Diagrams An Entity-relationship Diagram (ERD) says a lot ...
RM9 Database Diagram #rm9 #database
Database Diagram for RootsMagic version 9 – there are probably more table relationships to be added. RM9Database Diagram to Download ...
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 ...
