Thanks - that is just what I needed.
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
