On Thu, Mar 05, 2009 at 02:50:09PM -0800, Kenneth Crocker wrote: > To all, > > > We have found that the RT Query tool doesn't allow certain type of > searches we would like to have. SO we created some de-normalized views > that allow us to use SQL Plus or SQL Navigator, etc. as a tool to access > our RT ticket data. We are on Oracle, so I'm not sure if the code to > create these views will be helpful to anyone else, but I'll share them > with anyone interested. Also, I'd like to put them in the wiki for RT, > but I've never been there and would need some instruction on how to do that. > Also, for those who have been looking for ways to convert from one > ticketing system to RT, we have written a program in Perl to do just > that. It uses the API, so that all relevant table records are updated in > RT. Again, we use Oracle, so this may not work for you, but the logic > and process should. All you would have to do is change the syntax and > any environmental setups so the program would work for you and you've > got it. Anyone interested in that? > > > Kenn > LBNL > Yes, please add these to the wiki. We have had similar needs and having some samples to look at can really speed up implementation even on different DB platforms.
Cheers, Ken _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com