Weekly digest Email with opened calls

Dear RT Users,

I’ve a working RT system 3.2.2 on FC3. I would like to add a functionality
that will send a message
Once a week to all the users that own an open ticket.
This message should have a digest form meaning that, he/she should be able
to see all the opened calls that he/she owns in a single mail and optionnaly
for how long they have been opened.
I tried to play a little bit with the scripts but couldn’t figure out how to
trigger a script on a specific date. Is there a method of doing so or is an
external script, one that will query the DB, necessary?

Thanks,
LoPo

Paulo Ribeiro wrote:

Dear RT Users,

I’ve a working RT system 3.2.2 on FC3. I would like to add a
functionality that will send a message
Once a week to all the users that own an open ticket.
This message should have a digest form meaning that, he/she should be
able to see all the opened calls that he/she owns in a single mail and
optionnaly for how long they have been opened.
I tried to play a little bit with the scripts but couldn’t figure out
I think you mean scrip(without “t”), do you?

how to trigger a script on a specific date. Is there a method of doing
Scrips is event driven action. And trigger only on events(transactions).

You can start from rt-crontool, rt-remind scrips.
External utils on http://wiki.bestpractical.com/?Contributions can help
you too.

so or is an external script, one that will query the DB, necessary?
I didn’t dig&hack rt-crontool a lot so don’t know how power it’s, but
think that it’s easier to write command line script(use examples above).

Ah, forgot about
http://wiki.bestpractical.com/index.cgi?Documentation
Service tasks section

Paulo Ribeiro wrote: