Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Usage

Users are expected to email attached attach copies of the below files to 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.

View file
namered_rec.xlsx
height150
View file
nametrimestral_reports_ce.xlsx
height150
View file
nametrimestral_reports_mb.xlsx
height150


Users without access to this wiki page may respectively retrieved 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:

...

  • 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.
Image Added


Step 2. Click "Add Account."

Image Added


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.

Image Added


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

Image Added

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

Image Added


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:

...