Exploit your RootsMagic family tree database with SQLite Tools
Design, definitions, structure, operations…
A singular system table, sqlite_master, resides in a SQLite database. The table in the RootsMagic 5 database essentially defines the RootsMagic 5 database tables, indices, and fields, as below. Differences in structure with RootsMagic 4 include the addition of a new table, ResearchItemTable (and its index), to incorporate the newly-incorporated Research Log feature. In addition,…
I wasn’t sure whether to post this page on the RootsMagic 4 wiki or the RootsMagic 5 wiki, but it really applies to both. I’ve been considering the problem of data loss when using the RM Drag and Drop facility. Behind the scenes, Drag and Drop consists of a GEDCOM export from one RM database…
I have been running into some subtle little problems with queries and sub-queries that suggest to me that I don’t have an adequate understanding of the scope of names within SQL. To that end, I created the following very trivial queries to test against both SQLite and MS Access. — Test query #1 SELECT Z.PersonID…
I followed your instructions and was able to link to my MSAccess database – but all the files are read-only. Any tips on what might be causing that behavior, rather than them being read/write as your instructions note? Do you have details on the way the indices join between the tables? Do you have an…
The following was written in 2011 and RM Inc did rise to the challenge and produced a Backup option that includes media. However, it does two things that some people do not like if they are forced to restore from that backup: Their carefully developed folder structure for media is collapsed into one media folder…
Decodes most of the possible formats found in RM4 Date fields of the form Da+nnnnnnnn.x+nnnnnnnn.x . Does not decode Quaker dates nor will it format in any way other than yyyy-mm-dd. Queries a sample database containing some example dates; this database also contains the query as a VIEW. The query could be adapted to integrate…
RootsMagic 4 Database System Catalog A singular system table, sqlite_master, resides in a SQLite database. The table essentially defines the RootsMagic 4 database tables, indices, and fields as follows: type name tbl_name rootpage sql table AddressLinkTable AddressLinkTable 52 CREATE TABLE AddressLinkTable (LinkID INTEGER PRIMARY KEY, OwnerType INTEGER, AddressID INTEGER, OwnerID INTEGER, AddressNum INTEGER, Details TEXT…
Gedcom 5.5 Gedcom 5.5 Gedcom 5.5 in Windows Help (chm) format
RootsMagic 4 File Types Ext Description More rmgc family tree database SQLite 3-format file readable with SQLiteManagers rmgb family tree database backup ZIP-format file extractable not only within RM, but also by PKZip, WinRAR, et al. st Source Template master file used to create sourcetemplatetable on creation of family tree database Source Templates adl…