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.
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 |…
Post your wishes for utilities that will help you with your RootsMagic projects by posting under Discussion (tiny button up there with two bubbles next to Edit), with a new topic for each unique wish. Someone will summarize them on this page. Group Discussion or Page Status Media Insert Image Metadata into database see Media…
This is an example problem blahblahblah TGC55C.ged Discussions & comments from Wikispaces site mdriscol Exporting SQL results to Excel mdriscol 24 January 2016 23:20:39 I’ve searched the postings here and researched on the internet. I am using SQLite Expert Personal 3 with my RootsMagic 7 database and don’t find anywhere that I can use this…