Daily email to remind owners of open tickets
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 ptyhon script The underlying database connection relies on python's db capabilities, so probably you will have to install the appropriate db connector module(s) for your db. (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 on a Gentoo box. (I didn't test it on other platforms, but it isn't used to be very hard to adopt this tiny script to suit your needs... - like me: I have copied TicketReminder script, and just customized it ;) )
I know it could be written more efficient, and a nicer code. For now it is enough :)
Feel free to adopt it to your needs, please test it, use it!
UPDATE: One should change line 103 if upgrading from Trac 11.x to Trac 12.x due to database changes:
detail = detail + " created at " + str(time.strftime('%Y. %B %d. (%A) %H:%M:%S',time.gmtime(int(tkt/1000000))))
Please take care of indentation! (the 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)
If you have any issues, create a new ticket.
Download the zipped source from here.
One should put in a cronjob, ie:
0 0 * * mon-fri root /path/to/this/script/trac_reminder_report.py
(don't forget to put a MAILTO=your.address@… into the cron file, the script prints out the recipients names where the mails had been sent)