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
>
> [EMAIL PROTECTED]
>
> _______________________________________________
> 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 [EMAIL PROTECTED] or call us at +1 617 812 0745.
>
>
> Community help: http://wiki.bestpractical.com
> Commercial support: [EMAIL PROTECTED]
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.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 [EMAIL PROTECTED] or call us at +1 617 812 0745.
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
