SQLite Tools for RootsMagic

Exploit your RootsMagic family tree database with SQLite Tools

  • Home
  • Blog
  • Forum
  • RM8
  • Finder
    • Advanced Search
    • Tags
    • Content View – Pages
    • Page List
    • SQL Files List
  • Learn
  • About
    • Broken Links
    • History
  • Subscribe(r)
    • User
    • Register
    • Password Reset
    • Login
    • Account
    • Logout
  • RM10 Data Dictionary
  • Tool Requests

Ed Bell

Upload
Change your cover photo
Upload
Apply Cancel
Ed Bell
Ed Bell
This user account status is Approved
About About
Posts Posts
Comments Comments
Perfect! So an Event that is linked to a PlaceDetail (i.e., PlaceType == 2), will have PlaceTable.PlaceID set to the…
On RM9 Data Definitions #datadefinitions
In the EventTable, what are the roles of PlaceID and SiteID? I assume the former relates to the PlaceTable PlaceID,…
On RM9 Database Diagram #rm9 #database
I assume the PlaceID value in the EventTable refer to the PlaceID value in the PlaceTable? What is the SiteID…
On RM9 Data Definitions #datadefinitions
Can this be modified to search for all Places with "Cemetery" and split those?
On Places to Place Details Conversion #places #placedetails #update
Okay, using "SQLite Expert" I was finally able to get this query to run! Thanks! Can I request another query?…
On Places – Delete Unused #places #placedetails #delete #phantom
When I run this in SQLLite3, I get the error "Parse error near line XX: no such collation sequence: RMNOCASE"…
On Places – Delete Unused #places #placedetails #delete #phantom

Categories

Recent Posts

  • RM-LineageLoopDetector.sql: Uncovering Lineage Loops in RootsMagic Databases
  • Unlocking Your RootsMagic 10 Data: A Deep Dive into SQLite Queries (with AI)
  • New Page for Tool Requests
  • Custom functions in SQLiteSpy with sqlean extension are mighty and fast!
  • RM9 (now 10) Data Documentation Initiative

Recent Comments

  • Carolyn Shannon on RMNOCASE – faking it in SQLite Expert, command-line shell et al #rmnocase
  • mooredan on RMNOCASE – faking it in SQLite Expert, command-line shell et al #rmnocase
  • Carolyn Shannon on RMNOCASE – faking it in SQLite Expert, command-line shell et al #rmnocase
  • mooredan on Unlocking Your RootsMagic 10 Data: A Deep Dive into SQLite Queries (with AI)
  • mooredan on Unlocking Your RootsMagic 10 Data: A Deep Dive into SQLite Queries (with AI)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Archives

Tag Cloud

#admin #alternatenames #ancestrycom #application #batch #birth #child #citations #colorcoding #database #datadefinitions #date #DELETE #duplicates #events #facttypes #family #gedcom #geocoding #integrity #media #msaccess #namedgroup #names #person #phantom #placedetails #places #refno #reports #RM7 #rm8 #rm9 #rm10 #rmnocase #search #sharedevent #sortdate #sources #sourcetemplates #spouse #sql #tmg #TreeShare #update
Theme: Scaffold by Danny Cooper.