Exploit your RootsMagic family tree database with SQLite Tools
While this utility is not a SQLite query and does not operate directly on a RootsMagic database, it is nonetheless valuable to RM users. It uses Visual Basic for Applications in Excel to operate on a GEDCOM exported from a RootsMagic database to compare the list of media files found under a directory against those…
Description One query lists all the media files in the RM4 Media Gallery and the ID of the Person, Family, Event, Source, Citation or Place to which each is linked. Used in conjunction with other queries, one can look up the media item or find the details about the item to which the media are…
Microsoft Excel is a great tool for filtering/sorting/reporting on data in a Grid format. It also provides additional features such as various sorts of in-built graphs based on the data you are using as well as providing, for more advanced users, in-built calculation functions (formulas) that can be used to manipulate the data. Naturally, as…
If you have followed the guides to enable interrogation of the RootsMagic SQLite database via the Microsoft Access engine (MS Access Engine and MS Access Engine – Event Query and MS Access Engine – Using EXCEL) then you will also be able to use the Pivot Table feature of EXCEL to analayse your genealogy data.…
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…