Showing posts with label Report_Cemetery. Show all posts
Showing posts with label Report_Cemetery. Show all posts

Monday, May 22, 2017

Cemetery Report using the Historic Place Name feature

Going to take a "road trip" to Pennsylvania to visit cemeteries where I know to have people buried there. How do I create a List of Cemeteries and who is buried in each?

The trick starts with the use of the Historic Place Name feature [ Place detail (historical name, address church, cemetery, etc): ] in the Resolve Place Name screen.

Here is the Cemetery Name: 

Birmingham-Lafayette Friends Meeting, West Chester, Chester County, Pennsylvania, USA

This is the entry in the People Workspace, Person View




The Place Name is entered as listed above. In the Right Panel, with that Burial Fact Selected the Pencil "edit" ICON appears. That is to Resolve the Place Name.



Clicking on that brings up the Resolve Place Name Edit screen



Using the up pointing arrow, on the Left, the information to the first Comma, is moved to the upper field, "Place Detail", and the City, County, State, and Country are searched for and selected. 

This process takes full advantage of the Map feature. It shows where the cemetery is and who is buried there. But, I am going to the State, not just this cemetery, so I need a report.




Go to the Publish Workspace, Person Collection, Custom Report. Individuals to Include (on the right) and this pop up window appears. In the Find Individuals screen, FILTER IN => select ALL Facts and scroll down to Burial.



Now, in the field below Burial, select ANY DATA



and the default "Equals"  changed to Exists. That mean anyone who had information in the Burial Fact will be in the list. 



In my case, there are 642 entries. 



I don't want everyone, I only want those in Pennsylvania. 



I select the <= Filter Out, burial fact, select Place, Does not Contain Pennsylvania.




That gets me down to 246 people, buried in Pennsylvania.

Still in the Publish Workspace, Select the Items to Include ICON>



which will open the items to include in the Report. I removed the Birth, Marriage, and Death Facts  (the Red X) and added (Green +) Burial. The only information I want to Include only preferred Facts. I then selected the Burial FACT and only have a check mark in the Place and again the Include only preferred Facts




I want the report to be sorted by Cemetery. At the bottom of that panel is where the 1st Sort is by Burial Place then by name.

Where is a sample of what that report would look like.




_______________________________________________________________
Copyright © 2017 by H R Worthington

Thursday, June 21, 2012

FTM2012: Filter Out Media - a learning

In this blog post: List of Burials with Headstone Images I learned that the Filter Out of Media files did not work as I had seen in my file BEFORE I posted the message. What I learned was that only the Media Files, linked to a PERSON will be excluded. That means, that if there is a Media file, a family portrait for example, that Person would be excluded from that report. Not the desired result.

This step should NOT be used in the blog post mentioned above.


The blog post has been updated to reflect that this step should now be used.
_______________________________________________________________



Copyright © 2012 by H R Worthington

Wednesday, June 20, 2012

List of Burials without Headstone Images - revised

Question: "Does anyone know of a way to create a report that shows all burial data and then filter out the ones that have media attached to them? I want to get a list of open cemeteries that I need to get pictures of gravestones. I tried the custom reports with the filter in all burials with data in the description(that works!!) and then filter out the ones that have media data attached.....that does not work??"

The question is Timely as I have been working on my file, on this same topic.

I'll start by creating a report of everyone,  who has a Burial FACT, what includes a Media File. (Image of a headstone)

Go to the Publish Workspace, Person Collection and Custom Report.

For this report, since the question was "cemeteries that I need to get pictures of gravestones", that suggests the Report would be BY Cemetery, the Person in the Cemetery.

First I named the report "Headstone Media Report", then selected the "Items to Include" ICON.




The report I am generating, is based on the fact that I have a number of towns, or places, where there are multiple cemeteries where I have ancestors. To do that, the Items I want to include are: Burial, Name, and PersonID. That is the Burial Fact, the Name of the Person, and the Person ID. Reason: I may have, and do, have multiple people, with the same name buried in the same cemetery and the PersonID will show the specific person I am looking for. The order of the list of Facts are important, for grouping by Place and Cemetery.

NOTE: I record the Place Name, and the Cemetery Name is in the Description Field.

The Sort order is by Burial Fact PLACE, then Burial Fact DESCRIPTION.



And example of the Report is below:


So each PLACE, which can be filtered later one, is grouped together, then within that PLACE would be the multiple Cemeteries within that PLACE. Then the Name of the Person, and the PersonID.

Now to reduce the number of people in the report. Select "Selected Individuals" and a new window will appear. This is where you "Filter" people in or out, so select Filter In >





The first will be do Filter In EVERYONE who has information, any information, in the Burial Fact. Burial is in the All Facts selection, Burial from the pull down menu of Facts, and "Any Data" from the second pull down menu, and select EXISTS.



This will move everyone with a Burial Fact into the Right Window. Too many, 429.



EDIT: After further testing, the information below, does not work in this specific case.

We now will Filter OUT, everyone who already has a Media File associated with the Burial Fact. (That is where I put headstone pictures)

Selecting "Other", the Media, and Exits, will < Filter OUT anyone with a Media file, from the Right window, reducing the number of people in the report.


NOTE: This Filter WILL Filter OUT every one with a Media File. So, it may remove too may people. I'll post a follow up post with the ability to Identify those you were removed, in error.

Still too many, 479 to 372.



I only want people who are buried in Pennsylvania.  So, we'll  < Filter OUT burial Facts that are NOT in Pennsylvania, or Any Fact Places, that Does Not Contain Pennsylvania.


This gets the number down to 74


 Here is the final report.


 This example has two cemeteries grouped and listed.
_______________________________________________________________

Copyright © 2012 by H R Worthington

Print Friendly