Cemetery Entries program Main Help

(Click the Image for a slightly larger/clearer version – opens in another tab/page)

The Cemetery Entries program has these objectives:

  1. To slightly ease the input of thousands of details from photographs taken
  2. To ensure the CSV data is in the correct format for transfer to Find A Grave
  3. To utilise that F.A.G. formatted data to create a Wiki table for a WikiTree Cemetery Space.
  4. (At a future date) to utilise that F.A.G. formatted data to create a GEDCOM file for upload to WikiTree or any other genealogy site or program that can accept gedcom files.

You can download a pre-release version of the program here.

The program is for Windows Vista SP2, 7 SP1, 8, 8.1 and 10 operating systems and requires .Net Framework 4.5 which is NOT compatible with Windows 98 or XP.

For information about .NET Framework system requirements please visit this Microsoft page.

Please note that the exact detail of screens may change slightly from time to time as the program is developed.

Topics

  1. The Main Input tab
  2. The Output tab
  3. The Options & Settings tab
  4. The CSV to Wiki tab
  5. The Help tab

The Main Input Tab

(Click the Image for a slightly larger/clearer version – opens in another tab/page)
There are numerous fields in the Find A Grave CSV file format and this program only utilises some of them. These are the fields:

Prefix,First Name,Middle Name,Last Name,Suffix,Maiden Name,Day of Birth,Month of Birth,Year of Birth,Day of Death,Month of Death,Year of Death,Plot,Inscription,Gravesite Details,Nickname,Latitude,Longitude

All that is used in the WikiTable is:

First Name + Last Name,Maiden Name,Year of Birth,Year of Death,Plot,Nickname

This brings up an important point. If you do NOT need the output for import to Find A Grave you can use speed mode which prevents you entering data for any fields other than:

First Name + Last Name,Maiden Name,Year of Birth,Year of Death,Plot

Nickname is not included for the sake of speed, but if that is a problem it can be changed. These are the basic fields needed for the GEDCOM file.

Actually before you start you have to set up the details of the graveyard which is on the Output tab but bear with me for the time being and assume that has been done. We will come to the output tab in the next section.

Cemetery Entries Detail Input #1a(Click the Image for a slightly larger/clearer version – opens in another tab/page)

When the program loads it tries to return you to where you left off the last time. The image area will be blank however until you click either Next or the First image button below Previous. (Tip: First image always loads the start of the series)

As you can see on the top screenshot there appears to be clouds. This is because as the second screenshot indicates the images are always displayed 100% of size. The sliders are used to change the viewed portion of the image so you can read the details to be entered. On occasions, often when a close-up of a headstone is viewed, it is not so ease to view the detail without scrolling around a lot. You RIGHT click the image and it will then be displayed outside the program in your default image display program.

There are 8 ‘person’ tabs and so far this has proved to be the maximum on any single headstone. Should there be more you will need to make a copy of the image and continue. Making the copy has to be done outside the program.

Cemetery Entries Detail Input #1b(Click the Image for a slightly larger/clearer version – opens in another tab/page)
Cemetery Entries Detail Input #1c

The detail of the texts is:

  • Null (enclosed in chevrons)
  • Plot # is temporary image number
  • Plot # temporary until site is mapped
  • Face of memorial is worn / indistinct. Dates and name are believed to be correct.
  • Face of memorial is very badly worn / very indistinct. Dates and name are believed to be correct.
  • Information from the memorial face is believed to be correct but has been determined by photographic manipulation as the face is very worn.
  • The face of the memorial is undergoing restoration.
  • Memorial is damaged.
  • Memorial is damaged and parts are unreadable.
  • Memorial is damaged and parts are extremely worn and unreadable.
  • The headstone may not be located at the site of the grave.

Null (enclosed in chevrons) just leaves the entry blank. It does not enter the word Null.

At some stage in the future this will be made a user determined list.

Cemetery Entries Detail Input #2a(Click the Image for a slightly larger/clearer version – opens in another tab/page)

Cemetery Entries Detail Input #3(Click the Image for a slightly larger/clearer version – opens in another tab/page)

Inputting text and a note about Year Of Birth and manipulating images follows.

All text entered is checked to format it suitably for HTML:

  • Single quotes remain as they are
  • a comma ( , ) is replaced with the HTML for a comma
  • Chr(34) quotation marks are replaced with the HTML for a double quote mark
  • Carriage return and line feed are replace with a break
  • The day of birth or death must fall between 1 and 31 or it is set to blank
  • The month of birth or death must fall between 1 and 12 or contain the first three letters of the month i.e. Jan, Feb etc or it is set to blank. Case is ignored. i.e. jan instead of Jan is acceptable.
  • The year of birth or death must fall between 1 and the current year or it is set to blank
  • The age must fall between 0 and 125 or it is set to blank

Cemetery Entries Detail Input #4(Click the Image for a slightly larger/clearer version – opens in another tab/page)

So, what is manipulating images? Because the next image you will want to see is the next gravestone and not another shot of the current one a method has to be provided to ‘move on’ to the next gravestone. This is done using manipulate images.

Where you know there are two or more images of the current grave you must click the Manipulate Images check box. You can then assign a numeric or alpha suffix to the images.

Cemetery Entries Detail Input #5

Up to 6 images can be assigned using this method which is actually one more than the permitted number to upload to Find A Grave. In the example shown the images will be renamed McGettrick_Ballymote_CNanty_3850(a) and McGettrick_Ballymote_CNanty_3850(b).

The image number of the first image is retained for all subsequent images. If, for example that was a grave in Carrownanty with a plot number of Section D Plot 5 then the images would be named, depending on the values of the plot number and section fields, McGettrick_Ballymote_CNanty_D-5(a) and McGettrick_Ballymote_CNanty_D-5(b).

This ensures the photograph always has the plot reference aiding upload at a later time. It is not recommended that plot numbers be left blank as this can make later upload and assignment an onerous task.

Before committing the images you will be asked to ensure that the first image in the series is the one showing in the image area. If you have moved off the first image you will probably get an additional reminder.

Cemetery Entries Detail Input #6

If you forget to turn manipulate images on, or assign the wrong number of images you will have to save your work and then stop the program and sort it out manually.

You can go back to any ‘Person’ tab and change the details there at any time. In order to add another person you should use the button ‘Copy selected items to next tab’ which is above the big ‘Save This Persons Details’ button or it may be indicating how many people are to be saved such as ‘Save these 5 peoples details’.

You can simply click on the next tab but doing so will not update the number of people indicator. The first Surname cannot be blank and if you click in the surname or last name field on the first person tab you cannot proceed without entering some text. Additionally ensure that all surnames where there is other data have been entered. A blank surname will prevent the data being stored for that tab. Also please note that whilst you can leave an intermediate tab blank it is not a good idea! Yes you can enter data in only Tab #1 and Tab #8 but why would you?

You may also note on the image below that the plot number is 3851 whereas the start number of the images in 3850. This is because ‘Next’ has been clicked. The Plot reverts to the previous, in this case 3850, number when ‘Previous’ is clicked ONLY if the system is set to use image numbers as plot numbers.

Cemetery Entries Detail Input #7

Finally in this section there are the image control buttons at the bottom of the input section.

Image Buttons(Click the Image for a slightly larger/clearer version – opens in another tab/page)

REVIST moves the image into the REVIST folder below the current cemetery images. If there is more than one of the grave you will have to click REVIST for each one. The image is moved into the folder without changing its name.

SKIP moves the image into the SKIPPED folder.

‘Mark the current image(s) As Existing’ is a different kettle of fish. In effect this acts as if the data input had been completed in full. This requires that the main surname is entered on tab 1 and any other surnames from tab 2 onwards – one for each tab. This option is really only suitable for Find A Grave users where you know the memorial already exists but has no photo. The image (or multiple images – rules apply) are moved into the COMPLETED folder.

Please note that the folders COMPLETED, REVIST, SKIPPED and ARCHIVE are permanently sited below the current image folder. All these folders including ‘Lists and Layouts’ are created if they do not exist below the image folder upon selection.

  1. The Main Input tab
  2. The Output tab (Next)
  3. The Options & Settings tab
  4. The CSV to Wiki tab
  5. The Help tab

The Output Control Tab

Cemetery Entries-Output Control( 2019-02-10)(Click the Image for a slightly larger/clearer version – opens in another tab/page)

The Output Control tab is where you set the name for the cemetery, various screen control settings and where you output your work to file or clipboard

The name for the cemetery is used in the renaming of images. In the screenshot above you can see the Cemetery is given the name ‘Ballymote_CNanty’ which is short for Ballymote Carrownanty. When an image is renamed into the COMPLETED folder the name is changed thus:

Any surnames are prefixed to the cemetery name, the plot or image number is a suffix to the cemetery name and any sequence suffix is added after that.

Surname1-Surname2_CemeteryShortCode_PlotorImagenumber(sequence number).JPG

McGettrick_Ballymote_CNanty_3850(a) and McGettrick_Ballymote_CNanty_3850(b) or just McGettrick_Ballymote_CNanty_3850 if there is only the one image.

The list of cemetery shortnames is provided simply so that once you have input one name it can be selected again from the list allowing for consistent naming.

Cemetery Entries-Output Control( 2019-02-10)a(Click the Image for a slightly larger/clearer version – opens in another tab/page)

The destination of the image or images when the person’s details, or people’s details, are saved depends on the settings below:

Cemetery Entries-Output Control( 2019-02-10)b(Click the Image for a slightly larger/clearer version – opens in another tab/page)

The default is for the images to be renamed into the COMPLETED folder below the current image folder. When they are renamed they carry the surnames and plot number as a part of the file name making it easy to find them when uploading to a site.

They can however be moved unchanged into the COMPLETED folder if that is what you prefer, but it is infinitely more difficult to quickly find a name and is not a recommended option.

In addition when the ARCHIVE box is ticked an unaltered copy of the image can also be copied into the ARCHIVE folder.

You can amend the text in the data area however it is NOT RECOMMENDED. Read the details about this on the image below.

Cemetery Entries-Output Control( 2019-02-10)c(Click the Image for a slightly larger/clearer version – opens in another tab/page)

The final step is to output the data you have created to clipboard or to file.

Cemetery Entries Output lines(Click the Image for a slightly larger/clearer version – opens in another tab/page)

This is done using the buttons top right on the output tab

Cemetery Entries-Output Control( 2019-02-10)d(Click the Image for a slightly larger/clearer version – opens in another tab/page)

You can output the data to the clipboard but make sure you paste it BEFORE answering the dialog box that follows when you click the button. Once you answer yes the screen and buffers are cleared and the data is gone.

You can alternatively create or add to a csv format file for upload to Find A Grave and additional add to a file, in the same format, for use with the CSV to WikiTable function.

The csv file can be overwritten once loaded to Find A Grave but once created the _Listing file is only added to. The naming of the files is as follows:

CemeteryShortName-find-a-grave-transfer.csv
CemeteryShortName_Listing.txt

Late breaking news: The option to output both types of file or one or the other has been incorporated.

File options

  1. The Main Input tab
  2. The Output tab
  3. The Options & Settings tab
  4. The CSV to Wiki tab
  5. The Help tab

The Options & Settings Tab

Cemetery Entries - Options screen(Click the Image for a slightly larger/clearer version – opens in another tab/page)

Notes about these options can be viewed in the screenshot overlay below.

Cemetery Entries - Options screen-a(Click the Image for a slightly larger/clearer version – opens in another tab/page)

  1. The Main Input tab
  2. The Output tab
  3. The Options & Settings tab
  4. The CSV to Wiki tab
  5. The Help tab

The CSV to Wiki Tab

(Click the Image for a slightly larger/clearer version – opens in another tab/page)

The CSV to WikiTree table takes a cemeteryshortname_Listing.txt file and turns it into a table for adding to a WikiTree cemetery space page. It can also take ANY csv file and use the custom settings to produce the desired results. A custom CSV file can have been produced by any software but must satisfy the following criteria:

  • The CSV file should preferably have a header line. (Not absolutely essential if you use ordinal fields numbers)
  • The following fields must be present in the file
    • Plot Number (Can be ommitted)
    • First Name (Can be blank)
    • Last Name (REQUIRED)
    • Year of Birth OR Age at death Can be omitted or blank)
    • Year of Death (REQUIRED)
  • If you wish to group grave occupants by plot number the CSV file MUST be in plot number/name order.

Important things to remember:

  • If any field name evaluates to a numeric value ALL fields MUST have a numeric value and there must be no header line.
  • If a Year of Birth value is provided it takes precedence over the Age at Death field.
  • If ANY of the plot numbers are missing you must set the plot numbers selector (see below) Plot numbers refers to either numeric or text values

Cemetery entries plot selection

If ‘Has Some or No Plot Numbers’ is selected the output will consist of a single line per person and the plot number will become a numeric incrementing value. ONLY select ‘Has Complete Plot Numbers’ if this is the case. It does not matter if the plot number is an image number or an actual plot number but all must be present or the results may not be what was intended. If you can remember at the time, and you wish to group the occupants, and there is no plot number for a particular grave then enter something for the plot number. So if the last was ‘Section C Plot 234’ make the next ‘Section C Plot 234a’ (Which reminds me commas cannot be used in any field in the main input except the inscription field and gravesite condition fields.)

…..work in progress

The Help Tab

(Click the Image for a slightly larger/clearer version – opens in another tab/page)

  1. The Main Input tab
  2. The Output tab
  3. The Options & Settings tab
  4. The CSV to Wiki tab
  5. The Help tab
Advertisements