Re: [otrs] Close Ticket
Hi Gonzalo, Gonzalo Balatti schrieb: Alex, muchas gracias!! Having used is a escalation with the package AutoIncreasePriority, but gives a mistake of parameter. says something as TimeInternval. Can you help me? examine the source code: $Param{New}->{"TimeInterval"} = $Param{New}->{"TimeInterval"} * 60; Interpret TimeInterval as minutes => so multiply with 60 to get seconds. # find latest auto priority update foreach my $History (@HistoryLines) { if ($History->{Name} =~ /^AutoPriorityIncrease/) { $LatestAutoIncrease = $History->{CreateTime}; } } Finds the last autoincrease-history-entry. if (!$LatestAutoIncrease) { $LatestAutoIncrease = $Ticket{Created}; } If nothing was found, use the ticket-creation-time. if (($Self->{TimeObject}->SystemTime() - $LatestAutoIncrease) > $Param{New}->{"TimeInterval"}) { $Update = 1; } If the last Update is more than TimeInterval ago, increase the priority. So, TimeInterval is a parameter needed by this GenericAgent-module. Saludos, Saludos, Gonzalo Balatti Viera - CSU IBM Uruguay. Plaza Independencia 721. Teléfono 902 36 17 Int 5705. Bye, Alex ___ 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 Support orr consulting for your OTRS system? => http://www.otrs.com/
Re: [otrs] help with Oracle connection
Resolved.Problem was it could not resolve the IP address for 'localhost' Jason Rogers wrote: I am getting a Message: Error while trying to retrieve text for error ORA-12541 (DBD ERROR: OCIServerAttach) error when trying to connect to a Oracle 9 database. Despite the error message, the listener is running, and I can connect to the OTRS user with other third party apps( like TOAD ). I suspect perhaps some kind of environment settings not correct? I need to understand more about how OTRS makes a connection to a Oracle database so I can investigate further. Any pointers? ___ 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 Support orr consulting for your OTRS system? => http://www.otrs.com/ ___ 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 Support orr consulting for your OTRS system? => http://www.otrs.com/
Re: [otrs] Message: Need Search, UserLogin or PostMasterSearch!
Update on this, the error only occurs when the "From:" field is null. If I enter any text into this field, and then click on the customer search button, its ok. Is it possible to get a drop down list of values for customers ? help, I get this message when I click on the search customer button, when entering a phone call / new ticket: Message: Need Search, UserLogin or PostMasterSearch! Traceback (28986): Module: Kernel::System::CustomerUser::DB::CustomerSearch (v1.36) Line: 116 Module: Kernel::System::CustomerUser::CustomerSearch (v1.22) Line: 154 Module: Kernel::Modules::AgentTicketPhone::Run (v1.12) Line: 607 Module: Kernel::System::Web::InterfaceAgent::Run (v1.8) Line: 651 Module: /usr/local/otrs/bin/cgi-bin/index.pl (v1.80) Line: 47 ___ 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 Support orr consulting for your OTRS system? => http://www.otrs.com/ ___ 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 Support orr consulting for your OTRS system? => http://www.otrs.com/
Re: [otrs] Close Ticket
Alex, muchas gracias!! Having used is a escalation with the package AutoIncreasePriority, but gives a mistake of parameter. says something as TimeInternval. Can you help me? Saludos, Saludos, Gonzalo Balatti Viera - CSU IBM Uruguay. Plaza Independencia 721. Teléfono 902 36 17 Int 5705. Alexander Scholler <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/27/2006 01:54 AM Please respond to "User questions and discussions about OTRS.org" To "User questions and discussions about OTRS.org" cc Subject Re: [otrs] Close Ticket Hi Gonzalo, Gonzalo Balatti schrieb: > > I need to disable after closing a ticket the time. The time must stop > with the time of close the ticket. > How to configure this in the otrs??? The ticket age is always calculated as time gap from ticket creation to your actual system time. This is reasonable because tickets could be reopened, so the time between creation and closure can changes after reopening. You can receive the time gap you require through SQL-queries on the ticket-history-table by investigating the state-change-history-entries. Here, you see a query that returns all successive state-changes. You can take it as base for your needed modifications. SELECT (SELECT tn FROM ticket WHERE id = th.ticket_id) AS Ticket, SUBSTRING_INDEX(TRIM(BOTH '%%' FROM th.name), '%%', 1) AS state1, SUBSTRING_INDEX(TRIM(BOTH '%%' FROM th.name), '%%', -1) AS state2, paare.time1 AS time1, th.create_time AS time2, (UNIX_TIMESTAMP(th.create_time)-UNIX_TIMESTAMP(paare.time1))/3600 AS diffhour FROM ( /* History-Paare der aufeinanderfolgenden Statusaenderungen */ SELECT th.id AS id1, th.create_time AS time1, (SELECT MIN(id) FROM ticket_history WHERE ticket_id = th.ticket_id AND history_type_id = 27 AND id > th.id) AS id2 FROM ticket_history th WHERE th.history_type_id = 27 OR th.history_type_id = 1/* nur neue Tickets oder State-Updates */ ) AS paare INNER JOIN ticket_history th ON paare.id2 = th.id ORDER BY th.ticket_id, paare.id2; > > /Thank you very much for you help, > Regard, > / > Gonzalo Balatti Viera - CSU IBM Uruguay. Grettings to Uruguay (what's the temperature, humidity?) Alex > > > > > ___ > 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 > Support orr consulting for your OTRS system? > => http://www.otrs.com/ ___ 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 Support orr consulting for your OTRS system? => http://www.otrs.com/ ___ 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 Support orr consulting for your OTRS system? => http://www.otrs.com/
Re: [otrs] install problems
Hello Try http://localhost/otrs/cgi-bin/installer.pl Guillaume REHM Service Informatique Bibliothèque Nationale et Universitaire de Strasbourg 5 rue du Maréchal Joffre BP 51029 67070 Strasbourg tél: 03 88 25 28 43 fax: 03 88 25 28 03 mail: [EMAIL PROTECTED] web: http://www.bnu.fr [EMAIL PROTECTED] a écrit : Hi, I’ve installed OTRS on a WIN32 system. At the end off the install I have to configure OTRS and come in to the http://localhost/otrs/installer.pl There’s no installer.pl in the OTRS directory? Is there no OTRS-forum, one can read about other problems and solutions? Regards, Skater ___ 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 Support orr consulting for your OTRS system? => http://www.otrs.com/ ___ 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 Support orr consulting for your OTRS system? => http://www.otrs.com/
[otrs] Active directory
One of my customers who joined our organization last week tried to log in yesterday and today, and this is the error that she gets “Login failed! Your username or password was entered incorrectly. “ I have checked on the Customer User Management her details are not there. The system does not pick up changes made on the active directory. Please advice thanks ___ 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 Support orr consulting for your OTRS system? => http://www.otrs.com/