[rt-users] Creating Ticket Externally in RT2

[David C. Troy]

Yeah, you may be right... possibly an XML realtime interface.  Thanks for
the input.  At least now if I decide to trash the database I know it
wasn't a good idea. :)

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:

> If I were you, I'd have the ASP script do a post to a custom web-create page
> and read back the result.....it's better not to let things other than RT get the db in a possibly inconsitent state.
>
>
> On Thu, Aug 02, 2001 at 04:37:35AM -0400, David C. Troy wrote:
> >
> > 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
> > >
> >
> >
>
> --
> jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com
> 70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
>
> A REAL sysadmin challenge is "resurrect five dead mailserver while so ripped
> to the gills on mdma that you can't focus on any given line of text for more
> than 10 seconds continuously."
> 					-Nathan Mehl
>