[[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 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 [browser:dailyreminderscriptfortracscript/trac_reminder_report.py#L141 line 141] when upgrading from Trac 0.11.x to Trac 0.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 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''':
{{{#!sh
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 
[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.

== Installation

General instructions on installing Trac plugins can be found on the [TracPlugins#InstallingaTracplugin TracPlugins] page.

== Recent Changes

[[ChangeLog(dailyreminderscriptfortracscript, 3)]]

== Author/Contributors

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