|
|
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:
- 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
- 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:
- The plot is searched by using the specified attributes (at least Section and plot number)
- 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 |
|
|
