wiki:DailyReminderScriptForTracScript

Version 15 (modified by figaro, 2 years ago) (diff)

Cosmetic changes

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

8683 by rjollos on 2010-09-08 08:04:47
Importing attachment from project's wiki page.
7854 by ethanole on 2010-04-16 15:17:46
New hack DailyReminderScriptForTracScript, created by ethanole
(more)

Author/Contributors

Author: ethanole
Maintainer: none (needsadoption)
Contributors: