[rt-users] Creating Ticket Externally in RT2

Jesse jesse at fsck.com
Thu Aug 2 04:40:24 EDT 2001


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




More information about the rt-users mailing list