Re: [rt-users] De-normalized RT Views
Hi Kenn, We have Remedy Helpdesk and I would be interested in your Perl program to test conversion to RT. Regards, Jason On 5 Mar 2009, at 22:50, Kenneth Crocker wrote: 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? ___ 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
Re: [rt-users] De-normalized RT Views
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
[rt-users] De-normalized RT Views
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 ___ 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