Digital Cemetery

   The software for the Cemetery Management with mapping support

Map Drawing 

Excel

The fastest way to import existing information into the software, after having created the map, is an Excel file.
In this file you can put the informationa about burial plots, deceased, owners and purchase agreement.

The Import Procedure is a 2-steps task:
  1. The data from the Excel file are checked for right value depending by the field ("File Analysis"):
    Date values in yyyy or yyyy/MM/dd format
    Numeric values in a numeric format
    The Section values and if present the Series values are checked with the ones in the database: they must match.
    Each difference is signaled as a Warning and must be corrected before proceeding with the final import.
    After the first step the content of the Excel file is saved into a temporary table, no data are saved into the final tables (deceased, owners, purchase agreements).
    Before the analysis of the file the temporary table is cleared, so you can execute this step any time during the preparation of the Excel file, to check and correct any errors

  2. The data from the temporary table are saved into the relative final tables: deceased, owners, purchase agreements.
    In this step each record found in the temporary table is added to the final table if not found, or updated if found.
The deceased import is a critical operation because it depends by the exact search of the burial plot:
  1. The plot is searched by using the specified attributes (at least Section and plot number)
  2. The deceased is added and linked to the plot found
The Excel file must have a well define column list, with the following fields:

CEMETERY
SECTION_TYPE
SERIES_TYPE
LEVEL_TYPE
ROW_TYPE
PLOT_NUMBER
VOTIVE
LONGITUDE
LATITUDE
URL
PLOT_NOTE

DECEASED_SURNAME
DECEASED_NAME
DECEASED_TAXCODE
DECEASED_BIRTH_DATE
DECEASED_BIRTH_TOWN
DECEASED_RESIDENCE_TOWN
DECEASED_ADDRESS
STATUS
INTERMENT
DECEASED_DEAD_DATE
DECEASED_DEAD_TOWN
DECEASED_PROFESSION
DECEASED_MARITAL_STATUS
DECEASED_NOTE

OWNER_SURNAME
OWNER_NAME
OWNER_ADDRESS
OWNER_RESIDENCE_TOWN
OWNER_BIRTH_DATE
OWNER_BIRTH_TOWN
OWNER_TAXCODE
OWNER_PROFESSION
TELEPHONE
MOBILE
OWNER_NOTE

CONTRACT_ID
CONTRACT_DATE
CONTRACT_OBJECT
CONTRACT_STATUS
CONTRACT_DURATION
PLOT_SIZE
RELATION
PREPAYMENT_AMOUNT
PREPAYMENT_NUMBER
PREPAYMENT_DATE
CONTRACT_NOTE
 
Copyright © 2016 Digital Project
Digital Cemetery
Last update: July 2016
For information