[rt-users] Scripting Ticket Creation

Paulo Matos pjsm at fct.unl.pt
Wed Apr 28 14:06:25 EDT 2004

On Wed, 28 Apr 2004, Damian Burke wrote:

> Just learning RT, so if this question is answered elsewhere,
> please point me to it.
> I am writing a way to enter recurring tickets into RT.
> Like "Clean the printer" every week.   I run a cron job
> that pulls out info from a DB about the tickets that
> need to be created that day.
> I started out simply inserting a row into Tickets.
> I hardcoded EffectiveId to be the same as Id, which
> I hope is right.  I then saw I needed to add a row to
> Transactions for the create.  When I do this, I can
> see the new ticket from the RT interface, But the
> Requestor info is not there.  Looking at the DB,
> I see Groups. GroupMembers, Principals, and
> CachedGroupMembers as likely suspects
> for a new row, but I don't see the relationships
> between these tables.

Wouldn't bin/rt (the command-line tool) do the trick? Take a look.

> So, can anybody tell me what exactly I need to do
> to create a new table programatically?  Or point
> me to an API for this?

Can someone answer to this?
Serching wiki.bestpractical.com I only came up with this:

	Paulo Matos
 ----------------------------------- ----------------------------------
|Sys & Net Admin                    | Serviço de Informática           |
|Faculdade de Ciências e Tecnologia | Tel: +351-21-2948596             |
|Universidade Nova de Lisboa        | Fax: +351-21-2948548             |
|P-2829-516 Caparica                | e-Mail: pjsm at fct.unl.pt          |
 ----------------------------------- ----------------------------------

More information about the rt-users mailing list