Data Submission via Email

Usage

Users are expected to attach copies of the below files to regular email sent to dashboard-pav@openlmis.org. The email should be titled YYYY-Period-N-Report, where N is a positive integer between 1 and 4 inclusive intended to identify the relevant period.

Users without access to this wiki page may respectively retrieve the above files from:

https://nexleaf-pav.openlmis.org:4000/red_rec.xlsx
https://nexleaf-pav.openlmis.org:4000/trimestral_reports_ce.xlsx
https://nexleaf-pav.openlmis.org:4000/trimestral_reports_mb.xlsx

Additionally, a file like the one below is expected to convey the information presented in the HSS Funds tab:

Details about HSS Funds include:

• The email subject should be formatted like: "YYYY-MM-Monthly-Report" where YYYY is the year and MM is the month
• The title of the attachment should be "esistafe" (no quotes)
• The attachment should be .xlsx, .csv, or .xls
• The attachment should contain 5 columns that contain the following data (in order from left to right):
  • facility
  • updated_charge
  • execution
  • balances
  • execution_perc
• The backend is not hard coded to expect a specific number of facilities (rows)
• The backend does not calculate the "total value" row
  
  

Monitoring the Inbox

Administrators whom wish to monitor the PAV Dashboard's inbox may add its account to Outlook as follows.

Step 1. Click the "File" tab in the top-left part of the Outlook ribbon.

Step 2. Click "Add Account."

Step 3. Fill in the form shown below. The "Your Name" field can be set t any value you wish. Set the "E-mail Address" to dashboard-pav@openlmis.org and the "Password" to the one provided in the Email section of the Credentials page.

Step 4. Click "Next" on the screen shown above and then, on the one shown below, click "Finish."

Step 5. When prompted, restart Outlook. Observe that the dashboard-pav@openlmis.org inbox then appears within it.

Tech Notes

The email sent to users upon an erroneous data submission is defined within this PutEmail processor:



On the other hand, the email sent upon a successful submission is defined in this PutEmail processor: