Adding new actions to RT database directly

RT Users
1

Hi everyone,

I posted recently about my desire to have two additional actions available
for building custom scrips. I would like “Notify AdminCcs and Ccs” and
"Notify Ccs". Is there a particular reason that those are not in the
standard configuration?

Someone suggested to me recently that they added a “Notify Ccs” action
directly to the RT database using the following steps:

mysql -p
(enter password)
use rt3;
insert into ScripActions set Name = ‘Notify Ccs’, Description = ‘Send mail
only to the Ccs’, ExecModule = ‘Notify’, Argument = ‘Cc’, Creator = 1,
Created = now(), LastUpdatedBy = 1, LastUpdated = now();

Is this sort of mucking around in the database innards “kosher”? It was my
impression that changing the database directly was to be avoided. I’d be
curious to know under what circumstances it’s considered OK to do.

-Tim

Timothy Wilson
Technology Integration Specialist
Hopkins ISD #270, Hopkins, MN, USA
ph: 952.988.4103 fax: 952.988.4311 AIM: tis270

2

Adding actions is not a bad thing. Mucking around with the existing ones is
probably not the best idea…-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Tim Wilson
Sent: Monday, January 12, 2004 12:41 PM
To: rt-users@lists.fsck.com
Subject: [rt-users] Adding new actions to RT database directly

Hi everyone,

I posted recently about my desire to have two additional actions available
for building custom scrips. I would like “Notify AdminCcs and Ccs” and
“Notify Ccs”. Is there a particular reason that those are not in the
standard configuration?

Someone suggested to me recently that they added a “Notify Ccs” action
directly to the RT database using the following steps:

mysql -p
(enter password)
use rt3;
insert into ScripActions set Name = ‘Notify Ccs’, Description = ‘Send mail
only to the Ccs’, ExecModule = ‘Notify’, Argument = ‘Cc’, Creator = 1,
Created = now(), LastUpdatedBy = 1, LastUpdated = now();

Is this sort of mucking around in the database innards “kosher”? It was my
impression that changing the database directly was to be avoided. I’d be
curious to know under what circumstances it’s considered OK to do.

-Tim

Timothy Wilson
Technology Integration Specialist
Hopkins ISD #270, Hopkins, MN, USA
ph: 952.988.4103 fax: 952.988.4311 AIM: tis270

rt-users mailing list
rt-users@lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

3

mysql -p
(enter password)
use rt3;
insert into ScripActions set Name = ‘Notify Ccs’, Description = ‘Send mail
only to the Ccs’, ExecModule = ‘Notify’, Argument = ‘Cc’, Creator = 1,
Created = now(), LastUpdatedBy = 1, LastUpdated = now();

Is there an equivalent to “use rt3;” in the PostgreSQL world? I’m trying to
translate this for use with my Postgres-backed RT instance.

-Tim

Timothy Wilson
Technology Integration Specialist
Hopkins ISD #270, Hopkins, MN, USA
ph: 952.988.4103 fax: 952.988.4311 AIM: tis270