mooredanChange your cover photoUpload Change your cover photoUpload mooredan Amatuer genealogist since 1977, electrical engineer by trade. Also love the technical side of the hobby, scripting, sorting out DNA data, organizing, ... This user account status is Approved About About Posts Posts Comments Comments Does this mean that my database doesn't have this problem? The script returned nothing. May I suggest some output such… On RM-LineageLoopDetector.sql: Uncovering Lineage Loops in RootsMagic Databases The project now both compiles on a MacBook Pro and cross compiles from my Linux box. Pre-compiled objects are in… On RMNOCASE – faking it in SQLite Expert, command-line shell et al #rmnocase I did borrow my wife's modern MacBook and gave it a go to compile it - i'll have to take… On RMNOCASE – faking it in SQLite Expert, command-line shell et al #rmnocase It's a work in progress and hasn't been tested on Windows yet. Richard Otter has some instructions getting Python running… On Unlocking Your RootsMagic 10 Data: A Deep Dive into SQLite Queries (with AI) My development tree is here: https://github.com/mooredan/rmtree_py ChatGPT authored much of the code. rmutils.py contains some general functions. I program, but… On Unlocking Your RootsMagic 10 Data: A Deep Dive into SQLite Queries (with AI) My current process is reduced the number of PlaceIDs by nearly 2000: # wc (line count) $ wc -l places-before.log… On Unlocking Your RootsMagic 10 Data: A Deep Dive into SQLite Queries (with AI) Coincidently, I have been using ChatGPT to come up with Python functions to help clean up the PlaceTable. My PlaceTable… On Unlocking Your RootsMagic 10 Data: A Deep Dive into SQLite Queries (with AI) It can be found here: https://github.com/mooredan/unifuzz/tree/master/release (unifuzz.so) Once I get a Macbook running again, I'll release the unifuzz.dylib after compiling… On TreeShare – Rename Cryptic Filenames for Citation Media #TreeShare #media #citations #batch I thought of that too, but not necessary for my use case. I was just opening up the database in… On RM9 (now 10) Data Documentation Initiative Sorry that I didn't see this reply until after I saw this from Richard Otter: https://github.com/RichardOtter/Genealogy-scripts/blob/main/RM/Run%20SQL/ReadMe.txt Yes, doing a "REINDEX… On TreeShare – Rename Cryptic Filenames for Citation Media #TreeShare #media #citations #batch load more comments