[rt-users] Simple things are not so simple....
I would like to do a apparently very simple thing: - when a user is created (automatically or manually) I would like to: - give him only some rights - or put him in a default group (the purpose is the same) - give him a default dashboard - give him a default language Why I am not able to do this after reading a lot of docs? Can you help me? Thanks in advance, Mario
Re: [rt-users] Migration gone awry
Thanks. rt-validator did indeed balk, but recreating the internal groups didn't solve the problem. Anyway - As a workaround, we just created new tickets and merged the faulty tickets into the newly created one and it appears to work. -- troels On 25 April 2012 15:03, Thomas Sibley t...@bestpractical.com wrote: On 04/25/2012 04:45 AM, Troels Knak-Nielsen wrote: I know I brought this upon myself, but does any one here have any idea about what is wrong? You didn't create the internal groups RT uses for roles on a ticket, including Owner. Running rt-validator may be able to fix this up for you, but it's likely to not be the only thing that's a little odd in your db. Thomas
[rt-users] Cannot add email to user - already in use
Good morning, I try to add a user to RT4.0.5 - works. But if I add an email address to his account I get the message User xyz: Email address in use. But I cannot find this address in the userlist. Any idea ? Cheers - Michael
Re: [rt-users] Cannot add email to user - already in use
On Mon, Apr 30, 2012 at 16:04, Michael Polenske michael.polen...@skm-skyline.de wrote: Good morning, I try to add a user to RT4.0.5 – works. But if I add an email address to his account I get the message “User xyz: Email address in use”. But I cannot find this address in the userlist. Any idea ? User with that email already exist. When you search for user in admin UI use checkbox to include disabled and unprivileged users. Cheers - Michael -- Best regards, Ruslan.
[rt-users] About CMBD and RT
Hi, At my company we would like our system RT was associated with a CMBD (Configuration management database). There is some type a perfect kind of CMBD for RTor there exist a module that do this ? I've been looking but have not found anything ... Thanks! Dani -- ... __ / / Daniel García Mejía C E / S / C A Portals i Repositoris /_/ Centre de Serveis Científics i Acadèmics de Catalunya Gran Capità, 2-4 (Edifici Nexus) · 08034 Barcelona T. NULL · F. 93 205 6979 · dgar...@cesca.cat Facebook (http://on.fb.me/vPv3oN) · Twitter @CE5CA · Linkedin Subscriu-te al butlletí (www.cesca.cat/butlleti) ...
Re: [rt-users] Fwd: Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)]
On Fri, Apr 27, 2012 at 14:09, Alex Rhys-Hurn a...@itworx.co.ke wrote: Dear Benjamin, Thanks for all the hard work. I have in fact played with Jasper and RT before. I gave up as the reports I was trying to generate were to do with time worked. RT seems to have two different places where time is recorded and calculated, and so querying the DB gets complicated. Does your integration of Jasper with RT make this clearer / easier? We have a branch that improves situation with TimeTaken in transactions table. It can be used with RT 4.0. It will be in RT 4.2. or do you have any example SQL queries for reporting on Time worked in RT? Thanks so much, Alex From: Benjamin Boksa mailingli...@boksa.de To: Albert Shih albert.s...@obspm.fr Cc: rt-users@lists.bestpractical.com Sent: Thursday, 26 April, 2012 10:59:37 PM Subject: Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT andJasperReports Server Integration (got it working,anyone interested?)] Hi Albert, you can generate any kind of reports supported by JasperReports Server. RT-Jasper provides the DataSource necessary to query RT for tickets (the ticket's data can be used in the reports). Regarding your questions: 1) See the private mail I sent you. 2) No. If you have further questions just let me know. Greetings from Cologne Benjamin Am 26.04.2012 um 21:28 schrieb Albert Shih: Le 22/04/2012 ? 19:11:23+0200, Benjamin Boksa a écrit Hi. it's done :-) I have setup two GitHub repositories to host everything you need to run you own RT an JasperReports Server integration: RT-REST: http://projects.boksa.de/RT-REST/ RT-REST is a Java class library to interact with RT: Request Tracker's REST Interface. RT-Jasper: http://projects.boksa.de/RT-Jasper/ RT-Jasper is a toolkit to integrate RT: Request Tracker as a queryable data source in JasperServer. Feel free to give the components a try and let me know what you think :-) I have chosen to drop full installation instructions in favor of a demo system (see the RT-Jasper page for more information) and I assume you already have a RT installation to play with. To learn how to install JasperReports Server please refer to http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%204.5.0/JasperReports-Server-CP-Install-Guide.pdf/download . To help you with your questions I'll try to be around in #rt on irc.perl.org . I am really curious to see what you will say about my work and I hope there will be enough users using it to ensure a constant flow of great ideas and improvements. Enjoy the rest of your weekends :-) Big thanks for your works. Two questions before I spend lot of time to understand your works : 1/ What kind of reports can we have (I never heard of jasper, only the city in Canada ...;-) ). I didn't find your demo jasperserver ...:-( 2/ Is they are anything to modify on the RT server ? thanks again. Regards. -- Albert SHIH DIO bâtiment 15 Observatoire de Paris 5 Place Jules Janssen 92195 Meudon Cedex Téléphone : 01 45 07 76 26/06 86 69 95 71 xmpp: j...@obspm.fr Heure local/Local time: jeu 26 avr 2012 21:25:37 CEST -- Best regards, Ruslan.
[rt-users] About CMBD and RT
*configuration management http://en.wikipedia.org/wiki/Configuration_management database * Hi, At my company we would like our system RT was associated with a CMBD (Configuration management database). There is some type a perfect kind of CMBD for RTor there exist a module that do this ? I've been looking but have not found anything ... Thanks! Dani -- ... __ / / Daniel García Mejía C E / S / C A Portals i Repositoris /_/ Centre de Serveis Científics i Acadèmics de Catalunya Gran Capità, 2-4 (Edifici Nexus) · 08034 Barcelona T. NULL · F. 93 205 6979 · dgar...@cesca.cat Facebook (http://on.fb.me/vPv3oN) · Twitter @CE5CA · Linkedin Subscriu-te al butlletí (www.cesca.cat/butlleti) ...
Re: [rt-users] Cannot add email to user - already in use
Args, I forgot the unprivileged. Found and destroyed. Mille gracie ! Cheers - Michael -Original Message- From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of Ruslan Zakirov User with that email already exist. When you search for user in admin UI use checkbox to include disabled and unprivileged users.
Re: [rt-users] Non-Privileged User can create requestors for other users
On Fri, Apr 27, 2012 at 22:38, Lee Wilson leef...@yahoo.co.uk wrote: Good Evening, I was experimenting with RT (4.0.5) last night and found that it was possible for a non-privileged user to create tickets via the web interface for another user regardless of if they exist or not. Once the ticket is created the user gets a no permissions to view this ticket message so some security is going on. Would someone be so kind as to answer a few questions about this: 1) Is what I've said correct and if so is it possible to stop it without custom coding? I'd like to restrict users to only creating tickets for themselves, not anyone else. No problem if I do have to code something but wanted if there was an easier solution. 2) How can I stop random new users being created when they are added as requestors ? I'd prefer if only users I manually create are able to create tickets. There were a few older threads (from 2003 - http://www.gossamer-threads.com/lists/rt/users/17680) that referred to external Auth or removing the create ticket right from both Unprivileged and Everyone but this is already setup by default from what I can tell. If this can't be done I guess an OnCreate scrip that would auto-close the ticket with some kind of message template informing the request why would do the trick. Thanks in advance You can achieve this slight modification to MandatoryRequestor extension[1]. [1] http://search.cpan.org/dist/RT-Extension-MandatoryRequestor/lib/RT/Extension/MandatoryRequestor.pm Lee -- Best regards, Ruslan.
Re: [rt-users] Un deleting tickets
On Thu, Apr 26, 2012 at 20:44, Chris Preston ch...@thetrafalgartravel.com wrote: Hello all, I had set the status to deleted for thousands of records in a particular queue. I have now found out that we still need them. So I went into the tickets table and updated the records that were set to deleted and put them to new. I also changed the date of a tickets and set it to an earlier date. Is this all that I needed to do or what does the system actually do when a record is set to deleted. RT also records Status change in Transactions table. You may want to delete those records. -- Best regards, Ruslan.
[rt-users] Queue-specific message box contents
Hey folks, I found this delightful post suggesting a trivial solution to fill a need I have - pre-filling text areas for comment/reply messages on a queue by queue basis. After following the instructions the template was used to pre-populate the text area exactly as described however any changes made to that text were discarded when the comment was posted leaving me with the contents of the template as the contents of the comment. Any ideas? thanks ram On Wed, Feb 09, 2011 at 08:50:35AM -0500, Brian P. Bilbrey wrote: My goal: I've got a change management queue. When I create a new ticket in the web interface for this queue, I want the MessageBox (comment) field pre-populated with text headers like these: [snip] Does anyone have any guidance for me? We do exactly this, using a callback which I've attached to this message. You should install it in your local mason root as Callbacks/DefaultCreateContent/Ticket/Create.html/Default This is based on http://requesttracker.wikia.com/wiki/CannedReplies but rather simpler. Once you've installed the callback, any queues which has a template called DefaultCreateTemplate will have the content appear in the create ticket form. Hopefully you can get what you want either from this, or from other ideas on the wiki. Cheers, Dominic. -- Dominic Hargreaves, Systems Development and Support Team Computing Services, University of Oxford -- next part -- %# %# During ticket create, if a per-queue template named DefaultCreateTemplate %# exists, the message box will be pre-filled with it. %# %# Dominic Hargreaves 2009, based on ideas from %# http://wiki.bestpractical.com/view/CannedReplies %# %init my $template_name = 'DefaultCreateTemplate'; my $template = RT::Template-new( $session{'CurrentUser'} ); $template-LoadByCol( Name = $template_name, Queue = $QueueObj-id ); if ( $template-id ) { $template-Parse; $$ARGSRef{'Content'} = $template-MIMEObj-stringify; } /%init
Re: [rt-users] Un deleting tickets
Would this be possible?? Do an advanced search for status='deleted', and the date it was deleted on, and do a bulk update on all those tickets to make them another status? Just a thought, but I always tend to favor doing large updates through the tools provided... I just don't know if what I mentioned above is possible... Mike. On Thu, Apr 26, 2012 at 12:44 PM, Chris Preston ch...@thetrafalgartravel.com wrote: Hello all, I had set the status to deleted for thousands of records in a particular queue. I have now found out that we still need them. So I went into the tickets table and updated the records that were set to deleted and put them to new. I also changed the date of a tickets and set it to an earlier date. ** ** Is this all that I needed to do or what does the system actually do when a record is set to deleted. -- Mike Johnson Datatel Programmer/Analyst Northern Ontario School of Medicine 955 Oliver Road Thunder Bay, ON P7B 5E1 Phone: (807) 766-7331 Email: mike.john...@nosm.ca
Re: [rt-users] Un deleting tickets
On Mon, Apr 30, 2012 at 23:48, Mike Johnson mike.john...@nosm.ca wrote: Would this be possible?? Do an advanced search for status='deleted', and the date it was deleted on, and do a bulk update on all those tickets to make them another status? Just a thought, but I always tend to favor doing large updates through the tools provided... I just don't know if what I mentioned above is possible... With a script yes, but not in the UI. RT UI does filter out deleted tickets even if you ask for them on purpose. There is a trick available to do it from a custom code. Mike. On Thu, Apr 26, 2012 at 12:44 PM, Chris Preston ch...@thetrafalgartravel.com wrote: Hello all, I had set the status to deleted for thousands of records in a particular queue. I have now found out that we still need them. So I went into the tickets table and updated the records that were set to deleted and put them to new. I also changed the date of a tickets and set it to an earlier date. Is this all that I needed to do or what does the system actually do when a record is set to deleted. -- Mike Johnson Datatel Programmer/Analyst Northern Ontario School of Medicine 955 Oliver Road Thunder Bay, ON P7B 5E1 Phone: (807) 766-7331 Email: mike.john...@nosm.ca -- Best regards, Ruslan.
[rt-users] rt mail merge?
Is there an extension or some other way to essentially do a mail merge ticket creation in RT? We have about 50 people to email. We'd like to use comma-delimited data, including email address to create a customized ticket/email for each one. Currently our plan is to just use other mail merge software to send the email with the reply-to set to an RT address so that at least when they reply the ticket will be created. Which would be ok. It'd just be very nice to have a ticket # before they reply. thanks, Josh -- Reed College Computer Hardware Services
Re: [rt-users] rt mail merge?
If it were me I would create a bash script that would loop through the list of email addresses and for each one sent an email to the queue with the requestor set to the email address. I have some scripts that send ticket messages that I can grab code for and send it to you if you're interested. Joe Sent from my mobile device. On Apr 30, 2012, at 7:19 PM, Josh Tackitt tacki...@reed.edu wrote: Is there an extension or some other way to essentially do a mail merge ticket creation in RT? We have about 50 people to email. We'd like to use comma-delimited data, including email address to create a customized ticket/email for each one. Currently our plan is to just use other mail merge software to send the email with the reply-to set to an RT address so that at least when they reply the ticket will be created. Which would be ok. It'd just be very nice to have a ticket # before they reply. thanks, Josh -- Reed College Computer Hardware Services
Re: [rt-users] rt mail merge?
On Mon, 30 Apr 2012, Josh Tackitt wrote: Currently our plan is to just use other mail merge software to send the email with the reply-to set to an RT address so that at least when they reply the ticket will be created. Which would be ok. It'd just be very nice to have a ticket # before they reply. Why not turn this around? Create a queue which creates the outgoing mails (to users) as an 'answer' (by template) and start the works by sending mails 'faked from the addresses to send to'. So the 'fakes' create the tickets, the tickets create the mails to the users, and the users reply as usual... Stucki -- Christoph von Stuckrad * * |nickname |Mail stu...@mi.fu-berlin.de \ Freie Universitaet Berlin |/_*|'stucki' |Tel(Mo.,Mi.):+49 30 838-75 459| Mathematik Informatik EDV |\ *|if online| (Di,Do,Fr):+49 30 77 39 6600| Takustr. 9 / 14195 Berlin * * |on IRCnet|Fax(home): +49 30 77 39 6601/