Scheduled report by mail to specific users

[dmusil@…]

It would be good to have possibility to schedule a report for example as a job of the Windows or Linux server, which will be sent to specific list of people - for example Project Manager will be informed weekly about numbers of defects.

[Emmanuel Blot]

I think this is a similar feature to #1962, although the criteria differ.

I think both enhancements could be merged.

[anonymous]

Replying to eblot:

I think both enhancements could be merged.

Agree with that, both touches the reporting system and some connection to scheduled job on the win/linux server. Actually, for ticket #1962

• There could be a report (easy SQL) with due_Date≥today sent to the Project manager. But this is not solution for ticket owner, which should be notified. For this should be established a new procedure, which walks trough the tickets and send each ticket which is overdue.
• Advantage is, that implementation of running a report scheduled by system task is probably very easy and can calm down the "heat from management". In this case, use of due_date as a Trac custom field is possible.
  

So, there are few things to solve:

• Running a report from a system job
• Output channel as email, not a browser.
• Configuration of reporting system
  • It could be in trac.ini file, front-end could be added later
  • Parameters should be: which report (report number), how often (daily/weekly:number_each_x_weeks/monthly/exact date, time), report receivers (list of emails or Trac users)

[sid]

I think it's an interesting idea, and we could find a use for it at our company. Yes, similar to #1962, but that is a specific pinch point for a lot of people, so I'll leave it up to someone else to try to merge the tickets. I could see this fitting into the improved notification for 0.12, so slotting it there for the moment.

[hyuga <hyugaricdeau@…>]

Why does this functionality need to be built into Trac? IMO "schedule report of foo to such and such people" is too specialized, and can easily be implemented as a cron job or otherwise where needed.

[asloan7@…]

I would like this as well, maybe it is a plugin instead.

[Remy Blank]

Borders on "tobedoneinaplugin".

[figaro]

Plugins that could be of use here:

• ​th:TracCronPlugin
• ​th:TracSchedulerPlugin
• ​th:JobControlPlugin

possibly even ​th:DailyReminderScriptForTracScript