2018-06-25 Daily Standup

Attendees and/or Technical Stakeholders

• Craig Appl (Unlicensed)
• Clay Crosby (Unlicensed)
• Antonate Maritim (Unlicensed)
• Wambere (Unlicensed)
• Felimone Amone Junior
• Timoteo Chaluco (Unlicensed)
• Dércio Duvane
• Christine Lenihan

• Ben Leibert

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.
  
  Update: decided to expect eSISTAFE emails to be titled:
           YYYY-MM-Monthly-Report
  and to require trimestral reports to be titled:
           YYYY-Period-N-Report
  where N is a positive integer between 1 and 4 inclusive.
  
  
• 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.