[[PageOutline(2-5,Contents,pullout)]]

= Daily email to remind owners of open tickets

== 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 db capabilities, so probably you will have to install the appropriate db 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 on a Gentoo box.

Feel free to adopt it to your needs, please test it, use it!

'''Note:''' Change line 103 when upgrading from Trac 11.x to Trac 12.x due to database changes:
{{{#!python
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 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.

See also: TracReminderScript, TicketRemindScript

== Bugs/Feature Requests

Existing bugs and feature requests for DailyReminderScriptForTracScript are 
[report:9?COMPONENT=DailyReminderScriptForTracScript here].

If you have any issues, create a 
[/newticket?component=DailyReminderScriptForTracScript new ticket].

[[TicketQuery(component=DailyReminderScriptForTracScript&group=type,format=progress)]]

== Download

Download the zipped source from [export:dailyreminderscriptfortracscript here].

== Source

You can check out DailyReminderScriptForTracScript from [/svn/dailyreminderscriptfortracscript here] using Subversion, or [source:dailyreminderscriptfortracscript browse the source] with Trac.

== Example

One should put in a cronjob '''/etc/cron.d/trac_remind.cron''':
{{{#!sh
0 0 * * mon-fri root /path/to/this/script/trac_reminder_report.py
}}}

Don't forget to put 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.

== Recent Changes

[[ChangeLog(dailyreminderscriptfortracscript, 3)]]

== Author/Contributors

'''Author:''' [wiki:ethanole] [[BR]]
'''Maintainer:''' [[Maintainer]] [[BR]]
'''Contributors:'''