Jump to content


Photo

Report for events with missing sources


  • Please log in to reply
4 replies to this topic

#1 anzenketh

anzenketh

    Advanced Member

  • Members
  • PipPipPip
  • 197 posts

Posted 26 November 2014 - 08:15 PM

Is there a report for events with missing sources? I can't seem to find it. 



#2 TomH

TomH

    Advanced Member

  • Members
  • PipPipPip
  • 6254 posts

Posted 26 November 2014 - 08:35 PM

Reports > Lists > Fact List

From the dropdown listbox labelled "Create a list of", select "Facts without sources".


Tom user of RM7550 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.


#3 anzenketh

anzenketh

    Advanced Member

  • Members
  • PipPipPip
  • 197 posts

Posted 26 November 2014 - 09:31 PM

Thanks now if only I could figure out a way to ignore the reference number or other sources that are there for more bookkeeping reasons. 



#4 TomH

TomH

    Advanced Member

  • Members
  • PipPipPip
  • 6254 posts

Posted 26 November 2014 - 09:43 PM

I thought there was an easy answer to that:

 

Lists > Fact Type List

-- edit the Reference # fact type to uncheck the box "Include when: Printed lists"

 

However the Fact List report seems to be exempted from this control.

 

Another idea is to use a SQLite query to set all instances of the Ref# fact to Private and uncheck the box "Print private facts" in the report settings. I have not tried it in RM7 though so I cannot vouch that it works.

 

Finally, you can save the Fact List report to a text file, open it with Excel and use sort/filter to view your results. 


Tom user of RM7550 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.


#5 TomH

TomH

    Advanced Member

  • Members
  • PipPipPip
  • 6254 posts

Posted 26 November 2014 - 09:59 PM

Another idea is to use a SQLite query to set all instances of the Ref# fact to Private and uncheck the box "Print private facts" in the report settings. 

This works:

UPDATE EventTable SET IsPrivate = 1 WHERE EventType = 35
;


Tom user of RM7550 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.