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.
Wednesday, November 26, 2014
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:
Wednesday, November 12, 2014
South African genealogists and local historians will be sorry to learn of the death of Dr Keith Tankard, who has done much research into the German settlers in the Eastern Cape and East London Local history.
Dr Keith Tankard, historian with a wicked sense of humour, has passed away in East London today. Many of you have benefited from his enormous research into the History of East London and especially the German Settlers to the Eastern Cape (his webpage can be viewed here: http://www.eastlondon-labyrinth.com/germans/index.jsp) I worked very closely with Dr T on his book “Broken Promises” and got to know him very well – even though we never met in person. He will be sorely missed. Condolences to his wife Rosann and son Graeme (posted in the South African Genealogy Group on Facebook by Nolene Lossau Sproat)One does not know how long his web site will remain after his death, so if you are interested in the topics, it would be best to visit it sooner rather than later.