Skip to end of metadata
Go to start of metadata
Attendees and/or Technical Stakeholders
Discussion items
- We plan to ask users to include the period-name and year in the titles of the email they use to submit trimestral reports. The periods should be numbered, starting with 01, and email titles should looks as follows period-year-submission. For example: "01-2018-submission." Nifi will ignore everything after the "01-2018" - everything else in the title is optional and exists simply to make them more human readable.
- NiFi will perform data validation on district names. If an Excel file is found to include one which is not recognized, NiFi will email the relevant user with an error. The email will include generic instructions for submitting data to the system as well as a stack trace describing the error which occurred.
- NiFi will treat the period, year, and district-name as a compound primary key (uniquely identifying a row). While processing an email submission, if data for a row (ie: specific period-year-district pair) is found to already exist, NiFi will update its values rather than insert new ones into the database.