Exploit your RootsMagic family tree database with SQLite Tools
Introduction Conversion from #RM9 to #RM8 is pretty trivial with little loss except for RM9’s new features. From RM8 to #RM7 is much more complex given the significant structural changes between the two. To convert from RM9 to RM7 is simply a two-stage process with a RM8 compatible file as an intermediary. It’s possible to…
Issue As of writing, still no Book Publisher feature in RM8 and along with other persistent issues, some users wish to return to the RM7.5 database from which they had ‘upgraded’. However, the only ways back using the RM user interface are lossy: A more complete conversion is wanted. 2023-05-04: Update re #RM9: despite the…
Issue As for earlier versions, the order in which Citations for a given fact are presented in RM8 is the order in which they were added. Some users wish for them to be sorted alphabetically by name. Solution A brute force method was described for earlier versions at Source Citation Sort . In that case,…
This is an ‘upgrade’ from RMGC_Properties – Query #database for pre-RM8 databases. It provides an expansion over the information provided on the RM8 Home – File Properties screen. With a SQLite manager that supports runtime variables, a summary report can be given (just those variables with no leading hyphen). It ATTACHes a reference empty, unused…
WARNING 2022-06-18: This script has been found defective in the handling of reused citations – see Comments at the bottom. UPDATE 2022-06-12: a version of the script now imports the RM8 ConfigTable to RM7 as it appears to be compatible with RM7, so far. Because the RM8 import or conversion of a RM7 files seems…
WARNING 2022-06-18: This script has been found defective in the handling of reused citations – see Comments at the bottom of Direct Import of RM8 database into RM7 – Part 2. Issue As described in Returning to RM7.5 custom reports, groups and Publisher from RM8 via GEDCOM, there are reasons some users of RM8 would like…
UPDATE 2022-05-14: better than GEDCOM is to convert directly from RM8 to RM7 for which there are a couple of possibilities: RM8’s File > Export Data > DropBox creates a copy of the active .RMTREE file to a RM7 compatible .RMGC file intended for use with the RootsMagic Mobile app (now retired for Android). It…
RM9 Color Picker Changed & Color Coding Sets Added Versions prior to RM9 have but one set of color codes; RM9 added 9 more sets for a total of 10, any one of which can be active. Each color in each set and each set can be uniquely labelled to make it easier to understand…
In RM8, citations are re-useable and have a name which is made by concatenating the contents of the citation fields.
So I run this script on my RM version 7 database so that it is ready for importing into RM version 8.
RootsMagic 8 introduced indirection between citation data (text fields) and the fact to which a citation is attached, In RM7, the citation data and linkage was combined in the CitationTable. To use the same citation data for more than one fact meant that it had to be replicated in another record, making revisions to the…