Exploit your RootsMagic family tree database with SQLite Tools
A category for pages that don’t fit any other category.
Does not include any pages that have yet to be categorised.
Home A Migration Test Page A Proposal for a Named Group and Color Manager A Query for a To Do List in a Grid Format A Sample Query Created with Views Adding Virtual Columns to an RM4 Table Addresses – How Used Ahnentafel 64 generations All Citations & Dupes Count – Query All Citations –…
You are probably aware that Wikispaces has announced a phased shutdown of its services with that for SQLite Tools for RootsMagic terminating on 30th Sep 2018. After much gnashing of teeth, I have started investigating alternatives to which the wiki might migrate. I would welcome your help in the process, especially if you are knowledgeable…
I have been using this query for a quite a while now: — Alternate Name Typos Select f.FamilyID, — 1 — Column B Gets the surname, given name and fathered for the fatherid from the famillytable for the fathers primary record. This is the husband. (select n1.surname || “, ” || n1.given || ” ”…
Problem Queries Create a New Page for your problem by editing this page, inserting a link from the Editor menu which will permit you to insert the text for the hyperlink and name your new page. After saving this revised page, click on your new link to create and edit your new problem page. On…
Posted to Facebook by Art Dembinski 11 May 2016: I have a long list of “To Do”s of various kinds that I will probably not live long enough to accomplish. I travel a fair amount, and usually with very little advance notice. The locations for doing these are scattered all over the USA and Canada.…
Pages since RootsMagic 7 released 2018-07-31 Events – Add to all Children a Parent event shared with parents added 2018-07-22 GEDCOM & DnD transfer losses added 2018-07-13 File Question added (re: .DAT files in C:\Users\username\AppData\Roaming\RootsMagicAMT) 2018-03-19 Migrating from Wikispaces added 2018-01-28 TreeShare – Link Pasted Ancestry Sources added 2017-12-27 AllCitations.sql Error added 2017-12-16 Possible Orphaned Records in…
Here’s a pretty dumb question. Why will the following extremely simple query not return the desired results? I’m trying to see the sentence templates just for the birth, death, marriage, and burial facts. SELECT FT.FactTypeID, FT.Name, FT.Sentence FROM FactTypeTable AS FT WHERE FT.Name IN (‘Birth’,’Death’,’Marriage’,’Burial’); To get the desired results, I instead do something like…
Wikispaces terminated free subscriptions for non-education wikis on Oct 15, 2014. SQliteToolsforRootsMagic would have ended 30 days later unless we started paying Wikispaces $5/30days or $50/yr or migrate it to some other free hosting service. I could not imagine the work involved in transferring, unable to find any equivalent, free host. I asked if you…
As of 5.0.4.2, RootsMagic does not provide a comprehensive report on how each entry in the Address List is used – is it merely a Contact or is it the address of a Person or Family (couple) in the tree database? This query provides a list which helps answer that need. RM does provide a…
Wikispaces lacked the Category feature of WordPress. This was an attempt, not updated since 2012, to provide a categorised list of pages and scripts and was the basis for the menu structure in RMtrix and the Categories used on this WordPress site. (Tom Holden 2019-01-26) Addresses | Correspondence | Database | Edit | Facts |…