[rt-users] Table links

[Jesse Vincent]

On Mon, Jan 07, 2008 at 08:52:36AM -0700, Jason Manley wrote:
> We just recently setup RT for my IT group here and I am wondering how
> the attachment table and the ticket table are linked.  I see no shared
> values between the two tables.  I need this information to build a DTS
> package that pulls from our SQL database and will throw bug tickets in
> automatically into the RT database on mySQL.  Already have the ODBC
> driver and plan just need to figure out how the two tables are mapped so
> I can create the same link when the DTS package dumps its data in.
 
They're linked via the Transactions table. 

HOWEVER, we strongly recommend you use the RT API rather than write to
the SQL database directly. (If you do and don't get everything exactly
right, including groups, custom fields, ACLs and so forth, it's going to
be hard for anyone to help you fix things up later)


> 
> Thanks
> 
> Jason
> 
> Boulder Medical Center
> 
> Jmanley at bouldermedicalcenter.com 
> 

> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
> 
> If you sign up for a new RT support contract before December 31, we'll take
> up to 20 percent off the price. This sale won't last long, so get in touch today. 
>     Email us at sales at bestpractical.com or call us at +1 617 812 0745.
> 
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com

--