Exploit your RootsMagic family tree database with SQLite Tools
Introduction There has been a longstanding wish that RootsMagic would sort events that have no date or the same date (which might be as coarse as just the year) in an order that was natural or logical, e.g., Birth before Death being the simplest and most obvious example. The problem is that RootsMagic will sort…
Initial SortDate Algorithm The SortDate column in the EventTable contains very large numbers that have defied until now any easy method of decoding. After many experiments with date entry and inspection of the stored values, I now have deduced an algorithm that works fine for encoding single, pure dates and decoding corresponding SortDates. Date modifiers…
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…
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…