[rt-users] Simple things are not so simple....

2012-04-30 Thread Mario
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

2012-04-30 Thread Troels Knak-Nielsen
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

2012-04-30 Thread Michael Polenske
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

2012-04-30 Thread Ruslan Zakirov
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

2012-04-30 Thread Daniel Garcia Mejia

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?)]

2012-04-30 Thread Ruslan Zakirov
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

2012-04-30 Thread Daniel Garcia Mejia
*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

2012-04-30 Thread Michael Polenske
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

2012-04-30 Thread Ruslan Zakirov
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

2012-04-30 Thread Ruslan Zakirov
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

2012-04-30 Thread Ram
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

2012-04-30 Thread Mike Johnson
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

2012-04-30 Thread Ruslan Zakirov
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?

2012-04-30 Thread Josh Tackitt
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?

2012-04-30 Thread Joe Harris
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?

2012-04-30 Thread Christoph (Stucki) von Stuckrad
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/