[rt-users] Creating Ticket Externally in RT2

[David C. Troy]

Yeah, well, pretty directly... Basically I want to create a ticket from an
ASP script talking to MySQL over MyODBC... yeah, I know, the horror.. :)

I kind of want to know from the database what ticket number I get
assigned, etc...  getting perl involved on the Win platform gets way too
silly.  I figured if I could write to the tables directly that would be
easiest.

I'm thinking Tickets and Transactions will work as a minimal, barebones
new ticket -- I control the content and it's just piddly text messages, so
there's not a lot of variability there...  Seem OK?

Dave

=====================================================================
David C. Troy   [dave at toad.net]                   410-544-6193 Sales
ToadNet - Want to go fast?                        410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925  www.toad.net

On Thu, 2 Aug 2001, Jesse wrote:

> How directly do you mean? You really really really want to at least use
> RT's API to do it ($Ticket->Create).
>
> Failing that, you need to insert things into at least most of the following tables:
>
>         Tickets
>         Transactions
>         Attachments
>         Watchers
>         ObjectKeywords
>
>
>
> On Thu, Aug 02, 2001 at 03:59:15AM -0400, David C. Troy wrote:
> >
> > Hey All --
> >
> > We do some wacky things with RT where we'd like to be able to create a
> > ticket directly in the RT2 database, rather than through e-mail, CLI, or
> > web interfaces.
> >
> > Yeah yeah -- I know it's not 'supported' or the 'right way' to do it, and
> > I don't use 'deodorant,' etc....
> >
> > What tables do we need to insert into?  I'm thinking Tickets and
> > Transactions ought to do it;  any others?  Are there any special gotchas
> > on field contents in those tables?
> >
> > Any info appreciated.
> >
> > Dave
> >
> > =====================================================================
> > David C. Troy   [dave at toad.net]                   410-544-6193 Sales
> > ToadNet - Want to go fast?                        410-544-1329 FAX
> > 570 Ritchie Highway, Severna Park, MD 21146-2925  www.toad.net
> >
> >
> > _______________________________________________
> > rt-users mailing list
> > rt-users at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-users
> >
>
> --
> jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com
> 70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
>
> "It's buried in the desert, got sand in it, melts Nazis. You know,
> the Ark of the Covenant"   -- siva
>