Contents
Daily email to remind owners of open tickets
Notice: This plugin is unmaintained and available for adoption.
Description
This is a script for sending daily reminder emails of tickets owned, like one's notice scripts, or todo scripts.
The script searches the ticket status, and if one's status is not closed, it collects by owner and sends each of them a html mail.
This is a Python script. The underlying database connection relies on Python's database capabilities, so probably you will have to install the appropriate database connector module(s) for your database:
- MySQL: mysql-python
- PostgreSQL: psycopg2
- SQLite: sqlite2 or sqlite3
And of course you'll need Python 2.6 as well.
It is tested on Trac 0.11 and 0.12 with PostgreSQL 3.10 and Python 2.6 running Linux Gentoo.
Feel free to adopt it to your needs, please test it, use it!
Note: Change line 141 when upgrading from Trac 0.11.x to Trac 0.12.x due to database changes:
detail = detail + " created at " + str(time.strftime('%Y. %B %d. (%A) %H:%M:%S', time.gmtime(int(tkt[0]/1000000))))
Please note the indentation! The Trac 0.12.x database converts every timestamp to a more accurate timestamp format, so a timestamp field must be divided by a million to work properly.
Example
Place the following in a cronjob /etc/cron.d/trac_remind.cron:
0 0 * * mon-fri root /path/to/this/script/trac_reminder_report.py
Place a MAILTO=your.address@your.domain.tld into the cron file, the script prints out the recipient names where the mails had been sent to.
Bugs/Feature Requests
Existing bugs and feature requests for DailyReminderScriptForTracScript are here.
If you have any issues, create a new ticket.
| defect |
0 / 1 |
|
|---|---|---|
| enhancement |
0 / 1 |
|
| task |
0 / 1 |
Download
Download the zipped source from here.
Source
You can check out DailyReminderScriptForTracScript from here using Subversion, or browse the source with Trac.
Installation
General instructions on installing Trac plugins can be found on the TracPlugins page.
Recent Changes
Author/Contributors
Author: ethanole
Maintainer: none (needsadoption)
Contributors:
