Jump to content


Places - batch streamlining in narrative reports

places reports narrative sqlite

  • Please log in to reply
1 reply to this topic

#1 TomH


    Advanced Member

  • Members
  • PipPipPip
  • 6435 posts

Posted 30 March 2013 - 09:04 PM

Without much customisation of event sentences, the default sentences for events and roles result in RootsMagic-generated narrative reports having overbearing repetition of full place names of the form city, county|shire, province|state, country. Ultimately, intense customisation must be done to give more variety and colour to narrative reports thus reducing the appearance of rote computer generation. For some, however, a utility I have developed may satisfy a basic need. It revises the database in a blink (or two) of the eye to use just the first name of the Place (i.e., city from the aforementioned full Place name) for all sentences for a person's events in a place save for the earliest occurrence which gets the full place name. The full description, an example, and the downloadable SQLite script are at Places - first name exploit for improved narratives.

Tom user of RM7630 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com
SQLite_Tools_For_Roots_Magic_in_PR_Celti wiki, exploiting the database in special ways >>> RMtrix-tiny.png app, a bundle of RootsMagic utilities.

#2 Vyger


    Advanced Member

  • Members
  • PipPipPip
  • 3504 posts

Posted 31 March 2013 - 04:20 AM

Thank you TomH for continuing to provide such useful help utilities, these save so much time and effort.

Whilst some of these might highlight shortcomings within Rootsmagic there will always be a need for such utilities which will never be part of the program, IMHO.

Keep em coming

Customers should never be frustrated by things they cannot do - demand better


User of Family Historian 6.2.7, Rootsmagic 7.6.3, Family Tree Maker 2014 & Legacy 7.5


Excel to Gedcom conversion - simple getting started tutorials here



Also tagged with one or more of these keywords: places, reports, narrative, sqlite