Versions Compared

Key

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

...

It sends an automated mail reminder to data contributors if the update frequency time window for any of their datasets is missed by a certain amount. We would provide the link to the dataset that needs updating and emails to the same individual for multiple datasets are batched into one so they are not bombarded. When a dataset becomes delinquent then HDX administrators are sent an email so that they can follow up. The flow is as shown below:

Drawio
baseUrlhttps://humanitarian.atlassian.net/wiki
diagramNameEmails and Alerts
width502
pageId20742158
height932
revision3

29/11/2017 (60 days of runs since overdue emails sent)
SELECT DISTINCT a.id, c.title FROM dbdatasets a, dbdatasets b, dbinfodatasets c where a.id = b.id AND a.run_number > b.run_number and b.run_number > 149 AND a.fresh = 0 and b.fresh = 2 AND a.id = c.id;

...