Re: [otrs] Time Accounting leave hours
Hi Paolo: Well for each day you can specify also if you want to mark it as Vacation, sick or overtime leave, mass entry is if you want to do it for more than 1 day. A limitation of TimeAccounting in its current state is that it marks the complete day to leave, there is currently no possibility to leave for some hours/minutes per day. -- Carlos Fernando Rodríguez Hdz. Investigación Desarrollo OTRS S.A. de C.V. Av. Insurgentes Sur #863, Piso 7 Col. Nápoles México D.F., C.P. 03810 T: +52 55 11689664 I: http://www.otrs.com/ http://www.otrs.com/ Domicilio social: Bad Homburg, Juzgado Municipal: Bad Homburg, Registro Mercantil de Alemania 10751, NIF: DE256610065 Presidente del consejo de administración: Burchard Steinbild, Junta directiva: André Mindermann (director ejecutivo), Christopher Kuhn, Sabine Riedel ¡Más plano y rápido que nunca - OTRS 4! Y para todos los que quieren MÁS: ¡Descubra la OTRS Business Solution™ ahora - con más funciones de negocios! https://www.otrs.com/otrs-business-solution-para-un-mejor-servicio-de-atencion-al-cliente/?lang=es On Jan 3, 2015, at 9:04 AM, Paolo Mosconi paolo.mosc...@actvalue.com wrote: Hi all, I am configuring TimeAccounting package ver. 4.0.1 and I don’t know how to report vacation / leave hours in any given day. The only thing I found is Mass entry that enables to report leave for a whole day while what I’m looking for is the ability to enter a 2 hours sick or vacation leave. Thanks in advance paolo Paolo Mosconi image003.png ActValue Consulting and Solutions Via A. De Gasperi, 126 - 20017 RHO (Milano) – ITALY T +39 02 934642 27 M +39 335 8107163 Skype: pmosconi paolo.mosc...@actvalue.com mailto:paolo.mosc...@actvalue.com www.actvalue.com http://www.actvalue.com/ www.my-ecommerce.it http://www.my-ecommerce.it/ www.virtualrecruiter.it http://www.virtualrecruiter.it/ www.wiffi.it http://www.wiffi.it/ - OTRS mailing list: otrs - Webpage: http://otrs.org/ http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs http://lists.otrs.org/cgi-bin/listinfo/otrs signature.asc Description: Message signed with OpenPGP using GPGMail - 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
Re: [otrs] Time Accounting Module
Hi Winter, The Time Accounting module can be used to keep track of how many hours an agent worked. This is NOT integrated with OTRS tickets. HTH, -- Michiel Beijen Senior Consultant OTRS BV Schipholweg 103 2316 XC Leiden The Netherlands T: +31 71 8200 255 F: +31 71 8200 254 I: http://www.otrs.com OTRS brings true mobility to the Help Desk: The OTRS iPhone App free download http://www.otrs.com/en/products/iphone-app/ On Wed, Aug 25, 2010 at 11:32 PM, Silver springs win...@gmail.com wrote: Hi Could somebody let me know if there is a way to link the projects in Time Accounting module to tickets ? I tried to open a phone ticket and at the bottom of the ticket, there is a field called Time Units. Entered a couple of hours but it did not reflect in the time accounting page. Winter. - 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 - 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
Re: [otrs] Time Accounting Package - Reporting
Hi Esteban, The reporting section of this module,does not alow to get any customized report of the information loaded trought this module. Is there any way to get de information trought the Stats module of the OTRS?? Can anybody help me? Currently there is no time accounting reporting available. You could write your own report module for the stats area or submit a feature request or (if you require urgent assistance) ask for commercial OTRS support - e.g. at the companies maintaining the TimeAccounting package. regards, Torsten Thau -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de signature.asc Description: OpenPGP digital signature - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] Time Accounting Package - Reporting
Hi Torsten, thanks a lot for your clarification. It seems that i wil have to learn pearl...jeje Best regards. Esteban, 2010/7/29, Torsten Thau torsten.t...@cape-it.de: Hi Esteban, The reporting section of this module,does not alow to get any customized report of the information loaded trought this module. Is there any way to get de information trought the Stats module of the OTRS?? Can anybody help me? Currently there is no time accounting reporting available. You could write your own report module for the stats area or submit a feature request or (if you require urgent assistance) ask for commercial OTRS support - e.g. at the companies maintaining the TimeAccounting package. regards, Torsten Thau -- Torsten Thau, Dipl. Inform. c.a.p.e. IT Labs GbR - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 fax: +49 371 5347 625 http://www.cape-it.de -- Enviado desde mi dispositivo móvil Atte. Esteban Abete - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] Time accounting module
Hi, I can tell you that we have used for a while this module that is very interesting but unfortunally is not directly related to agent and ticket. Let me try to eplain this. After installation you are able to define projects and agent assigned to those with total hour per week/month (I don't remember well because then we have removed having not satisfied our manager that prefere to use an excel to trace this information), hour of holiday and so on. Than you could let mandatory compilation of time accounting to agent that they have to insert, at your decided time fragmentation, what they have done. At the end you can have a report by agent or by project. Hope it was a shorten full description. MV On Tue, Sep 15, 2009 at 5:49 PM, Jon Williams jon.william...@gmail.comwrote: I'm playing around with the new version of OTRS and just stumbled across the time accounting module / feature. Is this fully functional yet? I looked through the manual and didn't see any mention of how to use it. Is there any documentation that references this? This is something we are very interested in. With our current version of OTRS we are manually tabulating time per ticket for each technician. - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] Time accounting module
Roman Haag schrieb: is there no other approach? I mean this is somewhat ugly, because worked hours, vacancies etc. are not correct then. Is it possible to add another flag (like ill, vacancy) for absent, part-time?? so no ours are calculated... thanks for any hints! Hi, thanks Frans for that hint - that's sure a workaroud to handle the situation. Better then nothing! I share Romans point of view that (for the future) another solution to clearly handle these things. As I told I work with time accounting V.1.2.1 and with OTRS V. 2.3.2. There is a update for the time occounting module V.1.3.1, but OTRS 2.3.4 is needed, so some work to get the latest version running. Maybe the latest version solves this problem?! Regards, Ivan Am 10.06.2009 um 15:13 schrieb Frans Stekelenburg: Exactly. (looks like : image001.png) Kind regards, Frans Stekelenburg NetDialog Service Center +31 30 789 3636 www.netdialog.eu http://www.netdialog.eu Hi Frans, so if I get you right, you defined a project for absence and people working only 3 days feed the system with absence hours/days for the rest of the week on that project? Regards, Ivan - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ - professional services for the open source eLearning system OLAT hosting - operating - support - java development - consulting - frentix GmbH Roman Haag, Entwickler Zähringerstrasse 26 CH-8001 Zürich, Switzerland tel://+41-43-544-0949 http://www.frentix.com skype://thetoaster4001 - - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] Time accounting module
Ivan, As for your second problem, 3 4 day working weeks are pretty common in the Netherlands :-) We have created a project code 'Internal n.w. - Parttime Absence' (n.w.=Non Working). (We had a manager who always liked to have everybody end up with 40 hours a week on the sheets so he could tell the real exceptions). This way you can also tell when the PT is used. For your first question, I have not gone that far into it yet. Sorry. gr, Frans -Original Message- From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Ivan De Masi Sent: woensdag 10 juni 2009 09:33 To: User questions and discussions about OTRS. Subject: [otrs] Time accounting module Hi, is anybody here who has expience with the time accounting module? I'm testing the time accounting module (V.1.2.1) with OTRS V. 2.3.2 and I want to change the period the module calculates/reports the worked hours in a month. A regulary working month starts on the first an ends at the 30./31. - right? ;-) We have a different period calculation starting the 15th of every month until the 14th of the next month. Is there a way to tell the module to disply the reports this way? I also have problems to tell the system to handle part-time jobs. When sombody is not working a day or two (because he has only to work 3 or 4 days a week), the system always asks for the missing times for that days. The same for holidays. The only way ist to set the one ill for that day - but this is no good solution. Any ideas? Thanks! Regards, Ivan - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] Time accounting module
Frans Stekelenburg schrieb: Ivan, As for your second problem, 3 4 day working weeks are pretty common in the Netherlands :-) We have created a project code 'Internal n.w. - Parttime Absence' (n.w.=Non Working). (We had a manager who always liked to have everybody end up with 40 hours a week on the sheets so he could tell the real exceptions). This way you can also tell when the PT is used. For your first question, I have not gone that far into it yet. Sorry. gr, Frans Hi Frans, so if I get you right, you defined a project for absence and people working only 3 days feed the system with absence hours/days for the rest of the week on that project? Regards, Ivan -Original Message- From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Ivan De Masi Sent: woensdag 10 juni 2009 09:33 To: User questions and discussions about OTRS. Subject: [otrs] Time accounting module Hi, is anybody here who has expience with the time accounting module? I'm testing the time accounting module (V.1.2.1) with OTRS V. 2.3.2 and I want to change the period the module calculates/reports the worked hours in a month. A regulary working month starts on the first an ends at the 30./31. - right? ;-) We have a different period calculation starting the 15th of every month until the 14th of the next month. Is there a way to tell the module to disply the reports this way? I also have problems to tell the system to handle part-time jobs. When sombody is not working a day or two (because he has only to work 3 or 4 days a week), the system always asks for the missing times for that days. The same for holidays. The only way ist to set the one ill for that day - but this is no good solution. Any ideas? Thanks! Regards, Ivan - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] Time accounting module
Exactly. (looks like : ) Kind regards, Frans Stekelenburg NetDialog Service Center +31 30 789 3636 www.netdialog.eu Hi Frans, so if I get you right, you defined a project for absence and people working only 3 days feed the system with absence hours/days for the rest of the week on that project? Regards, Ivan image001.png- 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] Time accounting module
is there no other approach? I mean this is somewhat ugly, because worked hours, vacancies etc. are not correct then. Is it possible to add another flag (like ill, vacancy) for absent, part-time?? so no ours are calculated... thanks for any hints! Am 10.06.2009 um 15:13 schrieb Frans Stekelenburg: Exactly. (looks like : image001.png) Kind regards, Frans Stekelenburg NetDialog Service Center +31 30 789 3636 www.netdialog.eu Hi Frans, so if I get you right, you defined a project for absence and people working only 3 days feed the system with absence hours/days for the rest of the week on that project? Regards, Ivan - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ - professional services for the open source eLearning system OLAT hosting - operating - support - java development - consulting - frentix GmbH Roman Haag, Entwickler Zähringerstrasse 26 CH-8001 Zürich, Switzerland tel://+41-43-544-0949 http://www.frentix.com skype://thetoaster4001 - - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] Time Accounting
On 17 May 2008, Jay Holler wrote: On Thu, May 15, James Taylor wrote: On 15 May 2008, Jay Holler wrote: I am implementing an OTRS server in my organization and I am looking for a way to identify the number of hours reported in the Time units (work units): field by an agent when closing a ticket on a monthly basis by client. I have searched the list and website but have been unable to find a way to do this. We need exactly the same thing and have been equally surprised not to be able to find such a basic report in OTRS already. I have been using a complex SQL query in the MySQL shell to extract a monthly table of time used by ticket for each customer, and I can show you the SQL for this if you'd like to try doing the same. It's a rather manual process though. :-( That would be great if you could share your solution. Right now it appears to be the only way to do it. Rather unfortunate as the rest of the OTRS system handles our needs quite nicely. Oops, I've not been checking this list for a while, sorry. Log into your OTRS box and use the mysql shell to talk SQL to the database directly like so: mysql -D otrs -u otrs -p Enter password: The -D option specifies the name of the database, the -u is the name of the user, and -p means to prompt for the password. The correct values for all these can be found in the /opt/otrs/Kernel/Config.pm file if you've forgotten them. Then at the mysql prompt enter the SQL query. I suggest you cut'n'paste my example below into a text editor and tidy it up for your own purposes, then paste the result into the mysql shell. Now, in our case, we decided to charge customers each month by how much agent time they used in that month, *regardless* of whether the ticket was opened or closed in the current month. This seemed altogether more manageable than trying to keep track of whether tickets were closed, and also avoids the issue of having to wait for a long-running issue/ticket to be closed before getting any money for (especially when customers can reopen a ticket simply by sending another email and could keep that going month after month if it were a regular request). This first SQL query simply lists how much time each customer (that used *any* time) has used in the specified time period in a simple two column table: select case when company.name is null then ticket.customer_id else company.name end company, sum(time.time_unit) mins from time_accounting time left join ticket on time.ticket_id = ticket.id left join customer_user cust on ticket.customer_user_id = cust.login left join customer_company company on cust.customer_id = company.customer_id where (company.name is null or company.name != 'Intern') and time.create_time = '2008-04' and time.create_time '2008-05' group by company order by company; Each month we've been running that same query for the month just ended by changing the start and end dates (2008-04 and 2008-05 in this case, ie. all of April). You may be able to tidy it up, for instance Intern was a dummy company we set up for internal testing, and companies with null names probably ought not to exist but in our first fumblings this was unfortunately common. This second query is the main one for listing time spent handling each ticket, and it requires more explanation (see below): select case when cust.first_name is null then '' else cust.first_name end first_name, case when cust.last_name is null then '' else cust.last_name end last_name, case when company.name is null then ticket.customer_id else company.name end company, ticket.tn ticket, left(ticket.title,60) ticket_title, time.time_unit mins from time_accounting time left join ticket on time.ticket_id = ticket.id left join customer_user cust on ticket.customer_user_id = cust.login left join customer_company company on cust.customer_id = company.customer_id where (company.name is null or company.name != 'Intern') and time.create_time = '2008-04' and time.create_time '2008-05' group by ticket.tn order by company, time.create_time; This produces a six column table that's 144 chars wide in my terminal window, although yours may differ depending on your data. Fortunately, my terminal emulator allows me to reduce the font size until this becomes readable. (I did tell you this was a nasty hack didn't I?) The number 60 in left(ticket.title,60) truncates the ticket title to a maximum length of 60 characters because people do silly things like pasting long URLs into email subject lines. You could reduce this number to make the table less wide. The mins column is the total number of minutes spent on each ticket during the period specified (in this case the month of April). If a ticket spans across multiple months, only the time from this period is included in the table, which is what we wanted for billing. I hope that suffices for your purposes until someone comes up with a better way.
Re: [otrs] Time Accounting
James, That would be great if you could share your solution. Right now it appears to be the only way to do it. Rather unfortunate as the rest of the OTRS system handles our needs quite nicely. Thanks, Jay On Thu, May 15, 2008 at 12:14 AM, James Taylor [EMAIL PROTECTED] wrote: On 15 May 2008, at 06:20, Jay Holler wrote: I am implementing an OTRS server in my organization and I am looking for a way to identify the number of hours reported in the Time units (work units): field by an agent when closing a ticket on a monthly basis by client. I have searched the list and website but have been unable to find a way to do this. We need exactly the same thing and have been equally surprised not to be able to find such a basic report in OTRS already. I have been using a complex SQL query in the MySQL shell to extract a monthly table of time used by ticket for each customer, and I can show you the SQL for this if you'd like to try doing the same. It's a rather manual process though. :-( I keep thinking there must be a way to do this within OTRS. Surely there are many people using OTRS who need to bill their customers for the time they used. The existence of the Time Accounting module suggests that the developers recognise this. I do not have any familiarity with Perl so coding my own solution is not an option for me. Can anyone provide any further information regarding time accounting? Well, I am comfortable using Perl (it was one of the things that attracted us to OTRS) but we've only recently started using OTRS and there's a lot to learn about the way it is internally structured before writing our own extensions will become feasible. This is eventually what we will have to do, of course, if there really is no existing way to get the monthly time reports out. Please let me know if you find an answer. -- James Taylor ___ 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 or 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 or consulting for your OTRS system? = http://www.otrs.com/
H�zon k�v�li automatikus v�lasz/Out of office autoreply / Re: [otrs] Time Accounting
Május 15-én házon kívül tartózkodom. Technikai segítségkérési ügyekben kollégáim a [EMAIL PROTECTED] e-mail címen érhetõk el. -- I'm out of office on 15th of May. In case of any technical support request you can reach my collegues at [EMAIL PROTECTED] e-mail address. ___ 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 or consulting for your OTRS system? = http://www.otrs.com/
Re: [otrs] Time Accounting: How to make months start on 15th day instead of 1st Day?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Daniel, Daniel Stonegate Fischer schrieb: How is it possible to make the module reset all times on 15th of each month instead of 1st Day of a month? There's no config option or something like that. This is not possible without modifying the code. So you probably need a custom made timeaccounting package. regards, Torsten Thau - -- Torsten Thau, Dipl. Inform. c.a.p.e. IT GmbH - Annaberger Str. 240 - D-09125 Chemnitz phone: +49 371 5347 623 cell: +49 176 66 680 680 personal pgp-key: 0x93E0A174 company pgp-key: 0x292F987D fax: +49 371 5347 625 http://www.cape-it.de AG Chemnitz - HRB 23192 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHjJkFvXo8m5PgoXQRAmAjAJ0Yj/drXDXt/brCto4NXC5lst1GjwCffS8Y nEXB2+Us6e6UlIq4XshNUCU= =ww1C -END PGP SIGNATURE- ___ 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 or consulting for your OTRS system? = http://www.otrs.com/
Re: [otrs] Time-Accounting
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Agim Cami! On Wed, 28 Nov 2007, Agim Cami wrote: In Time-Acounting menu, under Acction Settings the required field is Action. What to put in this field? You may put in this field all project-related activities. You can configure this settings via time accounting-configuration. Regards und HTH, Rico - -- Dipl.-Math. Rico Barth, Geschäftsführer/Projektleiter c.a.p.e. IT GmbH Annaberger Straße 240 , 09125 Chemnitz phone/fax: +49 371 5347-621 / -625 mobile:+49 176 66680786 mailto:[EMAIL PROTECTED] , PGP-Key: 0x874C8377 internet: www.cape-it.de Geschäftsführung Rico Barth, Thomas Maier AG Chemnitz, HRB 23192 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFHTqqvmy4UBYdMg3cRAsDyAJ0RtbNSwX8eDl1PkgwhITpfxpvzrACdErZE A6Ti3O1O1adZmY8F1BZjK+I= =+j9G -END PGP SIGNATURE- ___ 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 or consulting for your OTRS system? = http://www.otrs.com/
RE: [otrs] Time Accounting report
I think this will do: SELECT t.create_by, u.first_name, u.last_name, Sum(t.time_unit) FROM time_accounting AS t Left Join system_user AS u ON t.create_by = u.id WHERE year(t.create_time) = '2006' GROUP BY t.create_by It will give you userid, firtstname, lastname, total work-units In 2006 Custom the query yourself or mail me if you need any more help regards, Peter -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Atanas Karashenski Verzonden: maandag 22 januari 2007 15:43 Aan: otrs@otrs.org Onderwerp: [otrs] Time Accounting report Hello, I use OTRS 2.1.4 on SuSE 10.2 and I want to create a report which calculates work units spent by agents working on tickets with particular customerID during given month. Is it possible to create such report using report creation wizard or I have to do additional coding? In case I have to do some coding what is the way to integrate it with OTRS - I checked developer documentation, but it seems that there are some differences between 2.0 and 2.1 versions (Only 2.0 is available on the web site). Thank you very much Atanas Karashenski ___ 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] Time Accounting per agent
I have loaded the beta on a test system , however I do not see the Agent restriction or option in any of the Steps , will it be incorporated in the final release? Also , will there be an option to specify your own valid criteria , by this I basically mean a GUI for using SQL queries :) It looks great so far !! keep it up guys!! Andy Lubel wrote: Thanks, I have the beta, need to brush up on my german! I like where you are going with this feature by the way! On 8/18/06 5:03 AM, Christian Schoepplein [EMAIL PROTECTED] wrote: Hi Andy, On Thu, Aug 17, 2006 at 04:10:19PM -0400, Andy Lubel wrote: In Stats, OTRS has a great Time Accounting selection that details the amount of time spent to handle each customer. This is good but we also need the accumulated time actually spent on any given ticket (i.e., by owner). I have tried to develop a SQL statement to do this using the time_accounting table but the time units used in this table do not match what you see if you pull up a ticket, zoom it and look under Accounted Time in the right hand column. Essentially a SQL statement that shows: How much time does it take person 'x' to work each ticket? Have you tested the new stats module in the upcomming OTRS 2.1? The first beta of OTRS 2.1 is out, maybe you want to give it a try and test, if the stat module fits your needs. If not, we ofcourse can create a stats module that is specific for your needs Just drop us a message to [EMAIL PROTECTED] to define the details. Andy Lubel Regards, Christian ___ 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] Time Accounting per agent
Thanks, I have the beta, need to brush up on my german! I like where you are going with this feature by the way! On 8/18/06 5:03 AM, Christian Schoepplein [EMAIL PROTECTED] wrote: Hi Andy, On Thu, Aug 17, 2006 at 04:10:19PM -0400, Andy Lubel wrote: In Stats, OTRS has a great Time Accounting selection that details the amount of time spent to handle each customer. This is good but we also need the accumulated time actually spent on any given ticket (i.e., by owner). I have tried to develop a SQL statement to do this using the time_accounting table but the time units used in this table do not match what you see if you pull up a ticket, zoom it and look under Accounted Time in the right hand column. Essentially a SQL statement that shows: How much time does it take person 'x' to work each ticket? Have you tested the new stats module in the upcomming OTRS 2.1? The first beta of OTRS 2.1 is out, maybe you want to give it a try and test, if the stat module fits your needs. If not, we ofcourse can create a stats module that is specific for your needs Just drop us a message to [EMAIL PROTECTED] to define the details. Andy Lubel Regards, Christian -- ___ 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] Time Accounting per agent
[code] select sum(a.time_unit), b.tn, b.title, c.login from time_accounting a, ticket b, system_user c where a.ticket_id=b.id and a.create_by=c.id group by a.ticket_id [/code] I know its really simple, but im not an analyst! Thanks for input, Andy On 8/18/06 12:45 AM, Alexander Scholler [EMAIL PROTECTED] wrote: Hi Andy, Andy Lubel schrieb: In Stats, OTRS has a great Time Accounting selection that details the amount of time spent to handle each customer. This is good but we also need the accumulated time actually spent on any given ticket (i.e., by owner). I have tried to develop a SQL statement to do this using the time_accounting table but the time units used in this table do not match what you see if you pull up a ticket, zoom it and look under Accounted Time in the right hand column. I think there is something wrong with your SQL-query. Post it here. 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/ -- ___ 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] time accounting otrs 2.0.4
Hi Johan, On Wed, May 24, 2006 at 09:05:31AM +0200, Johan Bijlsma wrote: When I use time accounting i get after some minutes a Internal Server Error. This problem occurs from month 3. Month 1 en 2 generates reports without a problem. Sounds like a timeout problem or to much data are transmitted. How many ickets are stored in your DB? On which hardware is OTRS running? What database is in use? Johan Bijlsma. Best regards, Christian -- ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 1862 760 :: Fax: +49 (0) 9421 1862 769 http://www.otrs.com/ :: Communication with success! signature.asc Description: Digital signature ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
RE: [otrs] Time Accounting
Does anyone know how to fill the time_unit text entry field with a default value? I'll be setting the field to be mandatory soon and it would be a real pain in the neck if you had to click in the field every time (even if closing a ticket just after you replied or the like). I'd just like it to default to zero and the agent can change it if it's a billable action (closing a ticket in and of itself doesn't really take up enough time to count as a billable item) Any help would be great! Thanks! Love OTRS! - Pete McDonnell ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
RE: [otrs] Time Accounting
Does anyone know how to fill the time_unit text entry field
with a default value? I'll be setting the field to be mandatory soon and
it would be a real pain in the neck if you had to click in the field every time
(even if closing a ticket just after you replied or the
like).
I'd just like it to default to zero and the agent can
change it if it's a billable action (closing a ticket in and of itself doesn't
really take up enough time to count as a billable item)
Any help would be great! Thanks! Love
OTRS!
- Pete
McDonnell
From: Pete McDonnell Sent: Friday,
February 04, 2005 10:53 AMTo: User questions and discussions about
OTRS.Subject: RE: [otrs] Time Accounting
Is anyone using time accounting in the real world?
Someone must... Are you using minutes or hours as the time
unit?
Any reports or queries that anyone can share for
reporting using this data?
- Pete McDonnell
Manager, Technical
Services
Hip
Interactive
From: Pete McDonnell Sent:
Thursday, February 03, 2005 10:51 AMTo: User questions and
discussions about OTRS.Subject: RE: [otrs] Time
Accounting
Correction, both systems are not displaying the same
behaviour. No fraction of a whole time unit is being stored. The
decimal places are just zeroes.
- Pete
McDonnell
Manager, Technical
Services
Hip
Interactive
From: Pete McDonnell Sent:
Thursday, February 03, 2005 10:44 AMTo: User questions and
discussions about OTRS.Subject: RE: [otrs] Time
Accounting
So I changed the time_accounting.time_unit field to
decimal(4,2) and added the following to
Kernel/Config.pm:
$Self-{FrontendNeedAccountedTime} =
1;$Self-{TimeUnits} = ' (hours)';
The time is only getting recorded as an integer still
though. IE if I enter 0.25 for the time unit field on a reply 0.00
gets stored in the DB. If I enter 1.25 1.00 gets stored in the
DB.
What else do I need to change? On my live 1.3.1
I only changed the time_accounting.time_unit field to decimal(4,2) and it
stores the time properly. I did not modify the Config.pm with the
above two lines on the production server.
- Pete
McDonnell
Manager, Technical
Services
Hip
Interactive
From: Pete McDonnell Sent:
Tuesday, February 01, 2005 4:13 PMTo: User questions and
discussions about OTRS.Subject: [otrs] Time
Accounting
I dug up the
following from an old 2003 post on this list. Just wondering if
it'll still work the same on version 1.3.1 and newer versions?
Still haven't upgraded the production server to
1.3.2.
__SNIP__
You can set a
config option to force time accounting
("$Self-{FrontendNeedAccountedTime} = 1;") and a option to
defined the time format name (" $Self-{TimeUnits} = ' (work
units)';") -= e. g."$Self-{TimeUnits} = '
(hours)';".
__SNIP__
-
Pete McDonnell Manager, Technical
Services Hip
Interactive Phone: (519) 272-0234
x228
"What the
large print giveth, the small print taketh away. -
Anonymous
___
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 oder Consulting für Ihr OTRS System?
= http://www.otrs.de/
RE: [otrs] Time Accounting
Is anyone using time accounting in the real world?
Someone must... Are you using minutes or hours as the time
unit?
Any reports or queries that anyone can share for reporting
using this data?
- Pete McDonnell
Manager, Technical
Services
Hip
Interactive
From: Pete McDonnell Sent:
Thursday, February 03, 2005 10:51 AMTo: User questions and
discussions about OTRS.Subject: RE: [otrs] Time
Accounting
Correction, both systems are not displaying the same
behaviour. No fraction of a whole time unit is being stored. The
decimal places are just zeroes.
- Pete McDonnell
Manager, Technical
Services
Hip
Interactive
From: Pete McDonnell Sent:
Thursday, February 03, 2005 10:44 AMTo: User questions and
discussions about OTRS.Subject: RE: [otrs] Time
Accounting
So I changed the time_accounting.time_unit field to
decimal(4,2) and added the following to
Kernel/Config.pm:
$Self-{FrontendNeedAccountedTime} =
1;$Self-{TimeUnits} = ' (hours)';
The time is only getting recorded as an integer still
though. IE if I enter 0.25 for the time unit field on a reply 0.00
gets stored in the DB. If I enter 1.25 1.00 gets stored in the
DB.
What else do I need to change? On my live 1.3.1 I
only changed the time_accounting.time_unit field to decimal(4,2) and it
stores the time properly. I did not modify the Config.pm with the
above two lines on the production server.
- Pete
McDonnell
Manager, Technical
Services
Hip
Interactive
From: Pete McDonnell Sent:
Tuesday, February 01, 2005 4:13 PMTo: User questions and
discussions about OTRS.Subject: [otrs] Time
Accounting
I dug up the
following from an old 2003 post on this list. Just wondering if
it'll still work the same on version 1.3.1 and newer versions? Still
haven't upgraded the production server to 1.3.2.
__SNIP__
You can set a config
option to force time accounting
("$Self-{FrontendNeedAccountedTime} = 1;") and a option to defined
the time format name (" $Self-{TimeUnits} = ' (work units)';")
-= e. g."$Self-{TimeUnits} = '
(hours)';".
__SNIP__
-
Pete McDonnell Manager, Technical
Services Hip
Interactive Phone: (519) 272-0234
x228
"What the large
print giveth, the small print taketh away. - Anonymous
___
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 oder Consulting für Ihr OTRS System?
= http://www.otrs.de/
Re: [otrs] Time Accounting
I am using this. We are using minutes. But you can use whatever you
like. Our time registration package uses 15 minutes as the smallest
resolution, so you could use that as your work unit. I am using the time
accounting to fill in the time registration at the end of the week. I
use this query on the database for that.
select
s.login,date_format(t.create_time,'%v-%x'),date_format(t.create_time,'%a
%d %b %y'), ti.customer_user_id, a.a_subject, t.time_unit, ti.tn,
a.a_body from system_user s, time_accounting t, article a, ticket ti
where t.create_by=s.id and t.article_id=a.id and t.ticket_id=ti.id and
date_format(t.create_time,'%v-%x')='02-2005'
ORDER BY s.login, t.create_time
I have not figured out how to build this query into the stats interface
so that I can select the week I want to see the time for.
Kind regards,
Harald Paterek
Pete McDonnell wrote:
Is anyone using time accounting in the real world? Someone must... Are
you using minutes or hours as the time unit?
Any reports or queries that anyone can share for reporting using this
data?
- Pete McDonnell
Manager, Technical Services
Hip Interactive
*From:* Pete McDonnell
*Sent:* Thursday, February 03, 2005 10:51 AM
*To:* User questions and discussions about OTRS.
*Subject:* RE: [otrs] Time Accounting
Correction, both systems are not displaying the same behaviour. No
fraction of a whole time unit is being stored. The decimal places
are just zeroes.
- Pete McDonnell
Manager, Technical Services
Hip Interactive
*From:* Pete McDonnell
*Sent:* Thursday, February 03, 2005 10:44 AM
*To:* User questions and discussions about OTRS.
*Subject:* RE: [otrs] Time Accounting
So I changed the time_accounting.time_unit field to
decimal(4,2) and added the following to Kernel/Config.pm:
$Self-{FrontendNeedAccountedTime} = 1;
$Self-{TimeUnits} = ' (hours)';
The time is only getting recorded as an integer still though.
IE if I enter 0.25 for the time unit field on a reply 0.00
gets stored in the DB. If I enter 1.25 1.00 gets stored in the DB.
What else do I need to change? On my live 1.3.1 I only changed
the time_accounting.time_unit field to decimal(4,2) and it
stores the time properly. I did not modify the Config.pm with
the above two lines on the production server.
- Pete McDonnell
Manager, Technical Services
Hip Interactive
*From:* Pete McDonnell
*Sent:* Tuesday, February 01, 2005 4:13 PM
*To:* User questions and discussions about OTRS.
*Subject:* [otrs] Time Accounting
I dug up the following from an old 2003 post on this list.
Just wondering if it'll still work the same on version
1.3.1 and newer versions? Still haven't upgraded the
production server to 1.3.2.
__SNIP__
/You can set a config option to force time accounting
($Self-{FrontendNeedAccountedTime} = 1;) and a option
to defined the time
format name ( $Self-{TimeUnits} = ' (work units)';) -=
e. g.
$Self-{TimeUnits} = ' (hours)';./
__SNIP__
- Pete McDonnell
Manager, Technical Services
Hip Interactive
Phone: (519) 272-0234 x228
/What the large print giveth, the small print taketh
away. - Anonymous/
___
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 oder Consulting fr Ihr OTRS System?
= http://www.otrs.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
Support oder Consulting fr Ihr OTRS System?
= http://www.otrs.de/
RE: [otrs] Time Accounting
Thanks Harald! As mentioned before, I'd prefer to store the units as hours,
and have changed the time_unit field in the time_accounting table to
fload(4,2) as per the note in the TODO file. But alas the fractional time
unit entered in the interface winds up getting stored as an integer. I
think there must be a variable in the code somewhere declared as an integer
which is killing the decimal places before they reach the database. I'm
having trouble locating it as I'm not a programmer and completely foreign to
perl.
- Pete McDonnell
Manager, Technical Services
Hip Interactive
-Original Message-
From: Harald Paterek [mailto:[EMAIL PROTECTED]
Sent: Friday, February 04, 2005 11:00 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Time Accounting
I am using this. We are using minutes. But you can use
whatever you like. Our time registration package uses 15
minutes as the smallest resolution, so you could use that as
your work unit. I am using the time accounting to fill in the
time registration at the end of the week. I use this query on
the database for that.
select
s.login,date_format(t.create_time,'%v-%x'),date_format(t.creat
e_time,'%a
%d %b %y'), ti.customer_user_id, a.a_subject, t.time_unit,
ti.tn, a.a_body from system_user s, time_accounting t,
article a, ticket ti where t.create_by=s.id and
t.article_id=a.id and t.ticket_id=ti.id and
date_format(t.create_time,'%v-%x')='02-2005'
ORDER BY s.login, t.create_time
I have not figured out how to build this query into the stats
interface so that I can select the week I want to see the time for.
Kind regards,
Harald Paterek
Pete McDonnell wrote:
Is anyone using time accounting in the real world? Someone
must... Are
you using minutes or hours as the time unit?
Any reports or queries that anyone can share for reporting
using this
data?
- Pete McDonnell
Manager, Technical Services
Hip Interactive
--
--
*From:* Pete McDonnell
*Sent:* Thursday, February 03, 2005 10:51 AM
*To:* User questions and discussions about OTRS.
*Subject:* RE: [otrs] Time Accounting
Correction, both systems are not displaying the same
behaviour. No
fraction of a whole time unit is being stored. The
decimal places
are just zeroes.
- Pete McDonnell
Manager, Technical Services
Hip Interactive
--
--
*From:* Pete McDonnell
*Sent:* Thursday, February 03, 2005 10:44 AM
*To:* User questions and discussions about OTRS.
*Subject:* RE: [otrs] Time Accounting
So I changed the time_accounting.time_unit field to
decimal(4,2) and added the following to Kernel/Config.pm:
$Self-{FrontendNeedAccountedTime} = 1;
$Self-{TimeUnits} = ' (hours)';
The time is only getting recorded as an integer
still though.
IE if I enter 0.25 for the time unit field on a reply 0.00
gets stored in the DB. If I enter 1.25 1.00 gets
stored in the DB.
What else do I need to change? On my live 1.3.1 I
only changed
the time_accounting.time_unit field to decimal(4,2) and it
stores the time properly. I did not modify the
Config.pm with
the above two lines on the production server.
- Pete McDonnell
Manager, Technical Services
Hip Interactive
--
--
*From:* Pete McDonnell
*Sent:* Tuesday, February 01, 2005 4:13 PM
*To:* User questions and discussions about OTRS.
*Subject:* [otrs] Time Accounting
I dug up the following from an old 2003 post on
this list.
Just wondering if it'll still work the same on version
1.3.1 and newer versions? Still haven't upgraded the
production server to 1.3.2.
__SNIP__
/You can set a config option to force time accounting
($Self-{FrontendNeedAccountedTime} = 1;) and a option
to defined the time
format name ( $Self-{TimeUnits} = ' (work
units)';) -=
e. g.
$Self-{TimeUnits} = ' (hours)';./
__SNIP__
- Pete McDonnell
Manager, Technical Services
Hip Interactive
Phone: (519) 272-0234 x228
/What the large print giveth, the small print taketh
away. - Anonymous/
-
--
-
___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http
RE: [otrs] Time Accounting
It seems as though if I comment out the following line (3209) in
/opt/otrs/Kernel/System/Ticket.pm that the full value of the ticket gets
stored. I'll have to do some testing to see what happens if I enter a value
with too many decimal places etc.
The line commented out is:
#$TimeUnit = int{$TimeUnit};
Might this break something else that I might not be aware of?
- Pete McDonnell
Manager, Technical Services
Hip Interactive
-Original Message-
From: Gerold Gruber [mailto:[EMAIL PROTECTED]
Sent: Friday, February 04, 2005 11:11 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Time Accounting
In the installation I'm involved in we also use minutes
(integer) as time units.
At the end of the month a aggregate my units per ticket into
a list and add this as appendix to my invoice, 'cause I get
paid for handling tickets in this case.
So I'm also 'raw' on the database:
select tn, customer_id, sum (time_unit) from time_accounting
ta , ticket t where ta.ticket_id = t.id and ta.create_by = 5
and (ta.create_time =
'2005-01-01 00:00:00') and (ta.create_time '2005-02-01
00:00:00') group by tn, customer_id order by tn;
5 is just my user id
Hth
Gerold
___
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 oder Consulting für Ihr OTRS System?
= http://www.otrs.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
Support oder Consulting für Ihr OTRS System?
= http://www.otrs.de/
RE: [otrs] Time Accounting
Correction, both systems are not displaying the same
behaviour. No fraction of a whole time unit is being stored. The
decimal places are just zeroes.
- Pete McDonnell
Manager, Technical
Services
Hip
Interactive
From: Pete McDonnell Sent:
Thursday, February 03, 2005 10:44 AMTo: User questions and
discussions about OTRS.Subject: RE: [otrs] Time
Accounting
So I changed the time_accounting.time_unit field to
decimal(4,2) and added the following to Kernel/Config.pm:
$Self-{FrontendNeedAccountedTime} =
1;$Self-{TimeUnits} = ' (hours)';
The time is only getting recorded as an integer still
though. IE if I enter 0.25 for the time unit field on a reply 0.00 gets
stored in the DB. If I enter 1.25 1.00 gets stored in the
DB.
What else do I need to change? On my live 1.3.1 I
only changed the time_accounting.time_unit field to decimal(4,2) and it stores
the time properly. I did not modify the Config.pm with the above two
lines on the production server.
- Pete McDonnell
Manager, Technical
Services
Hip
Interactive
From: Pete McDonnell Sent:
Tuesday, February 01, 2005 4:13 PMTo: User questions and
discussions about OTRS.Subject: [otrs] Time
Accounting
I dug up the
following from an old 2003 post on this list. Just wondering if it'll
still work the same on version 1.3.1 and newer versions? Still haven't
upgraded the production server to 1.3.2.
__SNIP__
You can set a config
option to force time accounting ("$Self-{FrontendNeedAccountedTime}
= 1;") and a option to defined the time format name ("
$Self-{TimeUnits} = ' (work units)';") -= e.
g."$Self-{TimeUnits} = ' (hours)';".
__SNIP__
- Pete
McDonnell
Manager, Technical Services Hip
Interactive Phone: (519) 272-0234
x228
"What the large
print giveth, the small print taketh away. - Anonymous
___
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 oder Consulting für Ihr OTRS System?
= http://www.otrs.de/
Re: [otrs] Time accounting
On Thursday, July 01, 2004 11:07 AM Christian Schaller [EMAIL PROTECTED] wrote: Is there an easy way to find out how many time units have been spent during a period (e.g. last month) for a certain queue? Not atm, sorry. We're developing a stats module that may later do the job. Check out the CVS head for a preview. Robert Kehl -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388 ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
Re: [otrs] Time accounting
Hi Jake, On Thu, Jul 24, 2003 at 02:26:45PM -0400, Covert, Jake wrote: It appears that OTRS 1.1.2 will only account time in integers (1 hour only, 15 minutes, etc). Do you think we could get otrs to support .25 hours, or .75 hours, etc? It's on the todo list for OTRS 1.2. .-) * Jake Covert Infrastructure Analyst Electronic Data Systems Martin -- Martin Edenhofer - martin at edenhofer.de - http://martin.edenhofer.de/ -- Noch 46 Tage bis zum Gäubodenvolksfest! ;-) ___ 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
