Changes between Initial Version and Version 1 of DailyReminderScriptForTracScript


Ignore:
Timestamp:
Apr 16, 2010, 3:17:47 PM (12 years ago)
Author:
ethanole
Comment:

New hack DailyReminderScriptForTracScript, created by ethanole

Legend:

Unmodified
Added
Removed
Modified
  • DailyReminderScriptForTracScript

    v1 v1  
     1[[PageOutline(2-5,Contents,pullout)]]
     2
     3= A daily reminder script for Trac =
     4
     5== Description ==
     6
     7This is a script for sending daily reminder emails of tickets owned (like one's notice scripts, or todo scripts).
     8
     9The 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.
     10
     11This 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...
     12
     13It is tested on Trac 0.11 with PostgreSQL 3.10 on a Gentoo box.
     14(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 [http://trac-hacks.org/wiki/TicketRemindScript TicketReminder] script, and just customized it ;) )
     15
     16I know it could be written more efficient, and a nicer code. For now it is enough :)
     17
     18Feel free to adopt it to your needs, please test it, use it!
     19
     20== Bugs/Feature Requests ==
     21
     22Existing bugs and feature requests for DailyReminderScriptForTracScript are
     23[report:9?COMPONENT=DailyReminderScriptForTracScript here].
     24
     25If you have any issues, create a
     26[http://trac-hacks.org/newticket?component=DailyReminderScriptForTracScript&owner=ethanole new ticket].
     27
     28== Download ==
     29
     30Download the zipped source from [download:dailyreminderscriptfortracscript here].
     31
     32== Source ==
     33
     34You can check out DailyReminderScriptForTracScript from [http://trac-hacks.org/svn/dailyreminderscriptfortracscript here] using Subversion, or [source:dailyreminderscriptfortracscript browse the source] with Trac.
     35
     36== Example ==
     37
     38One should put in a cronjob, ie:
     39{{{
     40'''/etc/cron.d/trac_remind.cron'''
     410 0 * * mon-fri root /path/to/this/script/trac_reminder_report.py
     42}}}
     43(don't forget to put a MAILTO=your.address@your.domain.tld into the cron file, the script prints out the recipients names where the mails had been sent)
     44
     45== Recent Changes ==
     46
     47[[ChangeLog(dailyreminderscriptfortracscript, 3)]]
     48
     49== Author/Contributors ==
     50
     51'''Author:''' [wiki:ethanole] [[BR]]
     52'''Maintainer:''' [wiki:ethanole] [[BR]]
     53'''Contributors:'''