You could simply use the SQLite database to extract the open tickets and send an email accordingly.
A very basic shell script like this one: for t in `echo "select owner,id from ticket where status!='closed';" | sqlite3 trac.db`; do r=`echo $t | cut -d'|' -f1` i=`echo $t | cut -d'|' -f2` echo "." | mail -s "Please check ticket #$i" $r done would do the job (this is a very quick and dirty script). You could replace the status!='closed' with status='assigned', for example. HTH, Manu On 12/21/05, Nigel Jewell <[EMAIL PROTECTED]> wrote: > Hi all, > > I want to write a shell script or two that can run periodically and send > emails to users about their active tickets. > > Are there any examples of such scripts floating around? > > I'm not a python programmer ... so any suggestions on where to start > would be appreciated. > > -- > Nige. > > PixExcel Limited > URL: http://www.pixexcel.co.uk > MSN: [EMAIL PROTECTED] > > > _______________________________________________ > Trac mailing list > [email protected] > http://lists.edgewall.com/mailman/listinfo/trac > -- Manu _______________________________________________ Trac mailing list [email protected] http://lists.edgewall.com/mailman/listinfo/trac
