Wednesday, November 26, 2014

SQLite Tools for RootsMagic

One of the things I'm always on the lookout for is things that save having to re-type stuff. Once I've entered my genealogy information on my computer, I don't want to have to re-type it, but would like to use it in various ways, some of which are beyond the capabilities of the program in which I originally entered it. That is why I keep my lineage-linked genealogy in 3-4 different programs, each of which has capabilities that the others lack, and transfer from one tyo the other by GEDCOM. But it seems that it is possible to do far more than that, and this site gives some ideas abour what is possible. I'd love to hear of other suites like that that can extend the capabilities of other genealogy programs. SQLite Tools for RootsMagic - home:
This wiki style site is intended to enhance our use of RootsMagic 4 and above with queries and reports not provided from within the program. RootsMagic 4, 5 and 6 use SQLite 3 as their database engine so the .rmgc database files each creates are readable using third party SQLite management and development tools. We explore collaboratively the RootsMagic 4 databases with some of these SQLite managers and develop SQL queries that attempt to answer questions that cannot be answered or are difficult to answer using the RM application.

RootsMagic SQL Queries:

  • How to Query RootsMagic
  • Problem Queries - Post your problem for discussion.
  • SQLite Managers - Choose from one of these tools to run your queries.
  • MS Access - Or connect to your database with Access and Excel for great looking reports.
  • Open Office - Use the same ODBC driver as described for MS Access to connect OpenOffice to a RM database.

No comments: