Changes between Initial Version and Version 1 of DailyReminderScriptForTracScript

Timestamp:

Apr 16, 2010, 3:17:47 PM (14 years ago)

Author:

ethanole

Comment:

New hack DailyReminderScriptForTracScript, created by ethanole

DailyReminderScriptForTracScript

@@ +1 @@
+[[PageOutline(2-5,Contents,pullout)]]
+
+= A daily reminder script for Trac =
+
+== 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 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 with PostgreSQL 3.10 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 [http://trac-hacks.org/wiki/TicketRemindScript 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!
+
+== Bugs/Feature Requests == 
+
+Existing bugs and feature requests for DailyReminderScriptForTracScript are 
+[report:9?COMPONENT=DailyReminderScriptForTracScript here].
+
+If you have any issues, create a 
+[http://trac-hacks.org/newticket?component=DailyReminderScriptForTracScript&owner=ethanole new ticket].
+
+== Download ==
+
+Download the zipped source from [download:dailyreminderscriptfortracscript here].
+
+== Source ==
+
+You can check out DailyReminderScriptForTracScript from [http://trac-hacks.org/svn/dailyreminderscriptfortracscript here] using Subversion, or [source:dailyreminderscriptfortracscript browse the source] with Trac.
+
+== Example ==
+
+One should put in a cronjob, ie: 
+{{{
+'''/etc/cron.d/trac_remind.cron'''
+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 recipients names where the mails had been sent)
+
+== Recent Changes ==
+
+[[ChangeLog(dailyreminderscriptfortracscript, 3)]]
+
+== Author/Contributors ==
+
+'''Author:''' [wiki:ethanole] [[BR]]
+'''Maintainer:''' [wiki:ethanole] [[BR]]
+'''Contributors:'''