Exploit your RootsMagic family tree database with SQLite Tools
Open Office has a database program (Open Office Base) and a spreadsheet program (Open Office Calc). Base can be connected via ODBC to a SQLite database in much the same way as has been described for Microsoft Access, using the same SQLite ODBC driver (See Part One of MS Access Engine). A .odb file is…
I wanted to be able to create my own reports from the RM database and the custom report facility in RM has a number of shortcomings: it is not very sophisticated and even quite apparenly simple reports are impossible to achieve (eg show me which census records are missing for an individual) I am not…