- otrs - OTRS mailing lists

how to delete user ?
by Dennis.Buehring＠net-and-works.de 27 Aug '03

27 Aug '03

Hi, how do i delete user ? there is no button / option for that purpose in the admin-area and i did not find anything in the documentation... mfg Dennis B. net&works www.naw.de

2 1

AW: [otrs] how to delete user ?
by Thorsten Philipp 27 Aug '03

27 Aug '03

Hi, To definitely delete him you have to delete him directly in the database. Just disable his Account if you don't want him to login anymore. Warning : I'm a total OTRS newbie. This could be 100% wrong ;) Greets -----Ursprungliche Nachricht----- Von: Dennis.Buehring(a)net-and-works.de [mailto:Dennis.Buehring@net-and-works.de] Gesendet: Mittwoch, 27. August 2003 10:33 An: otrs(a)otrs.org Betreff: [otrs] how to delete user ? Hi, how do i delete user ? there is no button / option for that purpose in the admin-area and i did not find anything in the documentation... mfg Dennis B. net&works www.naw.de _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

1 0

Removing lots of mails from OTRS?
by afreaasdadwewwqwq 27 Aug '03

27 Aug '03

I'm sorry but I'm a newbie. Can anyone tell me how can I run the following PHP Script sent by Florian ? and which db setting do I have to select ? Thanks ========================================== $abfrage = "SELECT ticket_id from article where a_subject = 'Re: Re: My details' OR a_subject = 'Re: Details' OR a_subject = 'Re: Approved' OR a_subject = 'Re: Wicked screensaver' OR a_subject = 'Re: That movie' OR a_body = 'See the attached file for details' "; $ergebnis = mysql_query($abfrage); if(!$ergebnis) echo "Abfrage nicht korrekt: $abfrage<br>\n"; while ( list ( $db_id ) = mysql_fetch_row($ergebnis) ) { $abfrage2 = "update ticket set ticket_state_id = '2' where id = '$db_id'"; $abfrage2 = mysql_query($abfrage2); } ========================================== Luis Vazquez

1 0

Delete specific tickets from a Queue
by Raymond Keckler 26 Aug '03

26 Aug '03

In the GenericsAgent.pm you can delete all tickets from the queue. ------------------------------ 'delete' => { # get all tickets with this properties Queue => 'testgroup', States => ['new'], Locks => ['unlock'], # new ticket properties (no option is required, use just the options # witch should be changed!) New => { # DELETE! Delete => 1, }, }, -------------------------------- I want to only delete a specific from address in the queue Delete all tickets in a queue that comes from mailer-daemon. Does anybody know how to do this. Ray

1 0

Using SQL to Delete Tickets
by Randy Shepherd 26 Aug '03

26 Aug '03

Hey Folks... Just a warning.. prior to this morning I had no idea what CS was using here to track issues. But since the guy who set it up and maintains it is in Seattle today.. I was asked to take a look at an issue. So please forgive my ignorance. My question is pretty basic.. there are a ton of tickets in our OTRS that are mailer-daemon responses. We want to get rid of them. Can I just go into the tickets table of our MySQL DB and do a delete of the records we want gone? Or is that going to mangle relationships and frag the whole thing? I looked through the archives, but was unable to find anything answering this question. Thanks, Randy

1 0

Re: [otrs] Creating new tickets and merging tickets
by gilles.massen＠restena.lu 26 Aug '03

26 Aug '03

Hi Mike, Sorry for the late answer...I only got around to answer this. Actually the subject is a bit confusing. The function I added is only for "creating" tickets, but has nothing to do with the merge. The code for the creation of new tickets has been posted on the mailing list somewhere on July. For the "merge" I'm waiting for an "official" solution. Best, Gilles -- RESTENA - DNS-LU 6, rue Coudenhove-Kalergi L-1359 Luxembourg tel: (+352) 424409 fax: (+352) 422473 Mike Witkowski <witkowsk(a)pop900.gsfc.nasa.gov> Sent by: otrs-admin(a)otrs.org 07/29/2003 13:22 Please respond to otrs To: otrs(a)otrs.org cc: Subject: Re: [otrs] Creating new tickets and merging tickets Gentlemen: I would also be very interested in the ticket merge functionality. If you could point me to your modules I would greatly appreciate it. Michael Witkowski Paul wrote: Hi Gilles, I'd be very interested in seeing the changes you've made. I'm about to embark on adding the same features to our installation and would appreciate any help getting the ball rolling. Best wishes, Paul -----Original Message----- From: otrs-admin(a)otrs.org [mailto:otrs-admin@otrs.org] On Behalf Of Sent: Friday, June 27, 2003 1:56 AM To: otrs(a)otrs.org Cc: brian(a)mylinuxisp.com Subject: Re: [otrs] Creating new tickets and merging tickets Hi Brian, I've finished a quick'n'dirty implementation of that function. Although I doubt that this would be a starting point for actual OTRS code, it works (with some sideeffects due to my lack of understanding of the guts of OTRS). But as a Module it is easy to put in place and there should not be any major issues with updates along the 1.1 path, or the correct working of OTRS in that matter. If there is interest I'll put a small install doc together with the files and post it here... Best, Gilles _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

2 1

Follow up without changing email address
by Duarte Cordeiro 26 Aug '03

26 Aug '03

Hi again, It seems that Martin came back from holidays :), so I'll ask this again, because I need some help modifying otrs. We use the forward facility to send tickets to ppl outside our organization. We would like that every time these external entities contact us regarding a ticket, that they would simply reply to our email, allowing us to "automagically" attach that info to OTRS. That is what otrs does, but with a little "add-on" that really upsets us: "it changes the customer email to the From: from the last received email. To be more clear: If customer(a)a.com creates a ticket, and then I forward it to support(a)provider.com , if I receive a reply from support(a)provider.com, and then (for example) I close the ticket, the "close ticket notification" goes to support(a)provide.com, not to customer(a)a.com. Why is this implemented like this ? (real scenarios that should use this "set the customer to the last from: field received) If it is intended to work like this, is there a quick way to disable it ? (I imagine that it should be something like adding ("high level language") if(!customer_is_already_set) prior to set_customer_email, but I don't know where to look at ! Thanks for your time, Duarte

2 1

AW: [otrs] Follow up without changing email address
by Thorsten Philipp 26 Aug '03

26 Aug '03

I dont't have a solution. But I also could need it ;) -----Ursprungliche Nachricht----- Von: Duarte Cordeiro [mailto:duarte.cordeiro@netcabo.pt] Gesendet: Dienstag, 26. August 2003 10:20 An: otrs(a)otrs.org Betreff: [otrs] Follow up without changing email address Hi again, It seems that Martin came back from holidays :), so I'll ask this again, because I need some help modifying otrs. We use the forward facility to send tickets to ppl outside our organization. We would like that every time these external entities contact us regarding a ticket, that they would simply reply to our email, allowing us to "automagically" attach that info to OTRS. That is what otrs does, but with a little "add-on" that really upsets us: "it changes the customer email to the From: from the last received email. To be more clear: If customer(a)a.com creates a ticket, and then I forward it to support(a)provider.com , if I receive a reply from support(a)provider.com, and then (for example) I close the ticket, the "close ticket notification" goes to support(a)provide.com, not to customer(a)a.com. Why is this implemented like this ? (real scenarios that should use this "set the customer to the last from: field received) If it is intended to work like this, is there a quick way to disable it ? (I imagine that it should be something like adding ("high level language") if(!customer_is_already_set) prior to set_customer_email, but I don't know where to look at ! Thanks for your time, Duarte _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

1 0

RE: [otrs] Adding Fields to Forms
by travis＠cloudmark.com 25 Aug '03

25 Aug '03

We would like to add the Free Fields to the bottom of the Compose Answer for Ticket screen to allow the agent to enter an issue code. This will save the agent a few clicks and increase the likelihood of recording the cause of the issue. Does anyone have experience making changes to these screens or have something like this already completed? Thanks Travis Murdock travis(a)cloudmark.com I've stopped 39,880 spam messages. You can too! One month FREE spam protection at http://www.cloudmark.com/spamnetsig/ -----Original Message----- From: Martin Edenhofer [mailto:martin@edenhofer.de] Sent: Friday, August 01, 2003 3:57 AM To: otrs(a)otrs.org Subject: Re: [otrs] Adding Fields to Forms Hi Paul, On Mon, Jul 28, 2003 at 02:58:31PM +0100, Paul O'Neill wrote: > is it possible to add new fields to forms. In this case I want to add a > Bugzilla ID field to the call forms to record issues logged with the > internal engineering team. I assume I would need to alter some tables to > allow this field to get populated in MySQL, There are two default ticket fields for use (key and value -=> e. g. PC: sun). You can change it if you zoom a ticket and click on "Free Fields". -=> If a free field is used, the you will see it in the queue and zoom view. PS: OTRS 1.2 comes with improvments of "Free Fields" functions. > paul.... Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "Security is a process, not a product." - Bruce Schneier _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

1 0

Notification problem
by sylvain angers 25 Aug '03

25 Aug '03

Hi, I just finish installing otrs on rh8.0 and did create user/group/queue I sent a test ticket and i see it in the interface but I do not receive ticket number and no staff receive notification. Perhaps I can change the ownership and the new owner receive a notification By the way I have copy a lot of thing from default.pm to config.pm and I have popmaster_pop3.pl.cron running as cron job Sorry for my english, I do write better in french Sylvain Sylvain Angers Tel: (514)767-3223 sylvain_angers(a)yahoo.com --------------------------------- Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Testez le nouveau Yahoo! Mail

2 2