Re: [rt-users] time worked report

2012-09-21 Thread Paul Muther
Thank you Kenneth. That does help. The one thing I'm struggling with is the Time Worked. I only want to see the Time Worked for that week. For example if I have a ticket that has 40 hours of work over two weeks, I only want Time Worked to reflect the time put in during the week the report

Re: [rt-users] time worked report

2012-09-20 Thread Kenneth Crocker
Paul, Like Thomas said, build the query you want and add the Timeworked column. However, to make this a weekly report, you need to put it in a dashboard set to run weekly. That would do it. Hope this helps. Kenn On Wed, Sep 19, 2012 at 3:41 PM, Paul Muther dalam...@gmail.com wrote: Is there

Re: [rt-users] time worked report

2012-09-20 Thread FUNDING SOLUTION
pl remove us from yr mailing list - Original Message - From: Thomas Sibley t...@bestpractical.com To: rt-users@lists.bestpractical.com Sent: Thursday, September 20, 2012 03:50 Subject: Re: [rt-users] time worked report On 09/19/2012 02:48 PM, Frankie Gibbs wrote: I currently use

Re: [rt-users] time worked report

2012-09-20 Thread FUNDING SOLUTION
pl remove us from yr mailing list - Original Message - From: Frankie Gibbs To: rt-us...@bestpractical.com Sent: Thursday, September 20, 2012 03:22 Subject: [rt-users] time worked report I currently use the RT 3.8.7 and I need to automatically calculate the time worked

[rt-users] time worked report

2012-09-19 Thread Frankie Gibbs
I currently use the RT 3.8.7 and I need to automatically calculate the time worked on each ticket, is this possible?. how I can do to get that report? thanks -- Final RT training for 2012 in Atlanta, GA - October 23 24

[rt-users] time worked report

2012-09-19 Thread Frankie Gibbs
I currently use the RT 3.8.7 and I need to automatically calculate the time worked on each ticket, is this possible?. how I can do to get that report? thanks -- Final RT training for 2012 in Atlanta, GA - October 23 24

Re: [rt-users] time worked report

2012-09-19 Thread Thomas Sibley
On 09/19/2012 02:48 PM, Frankie Gibbs wrote: I currently use the RT 3.8.7 and I need to automatically calculate the time worked on each ticket, is this possible?. how I can do to get that report? Construct the search for the tickets you want using the Query Builder and then add the TimeWorked

Re: [rt-users] time worked report

2012-09-19 Thread Paul Muther
Is there a way to do this easily to show time worked for a range of dates? For example if I submit time for techs on a weekly basis showing the effort put into each ticket? Currently I'm using a rather unreliable method of table joins and a back end SQL query. In almost all implementations

Re: [rt-users] Time Worked Report showing error - Reg

2012-02-10 Thread Kevin Falcone
On Fri, Feb 10, 2012 at 10:25:51AM +0530, Pattabi Prasanna wrote: Hi I have installed RT 3.8.9 and when installing Time Worked Report it is showing this error. Kindly let me know how to solve this error. Error during compilation of /opt/rt3/local/html/Elements/SelectMultiQueue:

[rt-users] Time Worked Report showing error - Reg

2012-02-09 Thread Pattabi Prasanna
Hi I have installed RT 3.8.9 and when installing Time Worked Report it is showing this error. Kindly let me know how to solve this error. Error during compilation of /opt/rt3/local/html/Elements/SelectMultiQueue: Global symbol $d requires explicit package name at

Re: [rt-users] Time Worked Report

2011-04-26 Thread Walid Haider
-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kenneth Crocker Sent: quinta-feira, 31 de Março de 2011 18:35 To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Time Worked Report Walid, In step 4, you don't mention editing the Tabs

Re: [rt-users] Time Worked Report

2011-04-26 Thread Kenneth Crocker
@lists.bestpractical.com *Subject:* Re: [rt-users] Time Worked Report Walid, In step 4, you don't mention editing the Tabs file with the changes specified in the instructions. In steps 5 6, those files should have been moved to usr/share/rt3/local/html/Tools/*Reports*. 1) The Tabs

Re: [rt-users] Time Worked Report

2011-03-31 Thread Kenneth Crocker
...@lists.bestpractical.com] *On Behalf Of *Kenneth Crocker *Sent:* terça-feira, 29 de Março de 2011 16:42 *To:* rt-users@lists.bestpractical.com *Subject:* Re: [rt-users] Time Worked Report Opps, that was supposed to be /local/html/Tools/Report. Sorry. Kenn On Tue, Mar 29, 2011 at 8:39

Re: [rt-users] Time Worked Report

2011-03-29 Thread Walid Haider
/share/rt3. Thanks, Walid From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kenneth Crocker Sent: segunda-feira, 28 de Março de 2011 17:33 To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Time Worked Report Walid, What I

Re: [rt-users] Time Worked Report

2011-03-29 Thread Johan Sjöberg
Do you have a /usr/local/rt3? /Johan From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Walid Haider Sent: den 29 mars 2011 15:20 To: Kenneth Crocker; rt-users@lists.bestpractical.com Subject: Re: [rt-users] Time Worked Report Kenn

Re: [rt-users] Time Worked Report

2011-03-29 Thread Walid Haider
@lists.bestpractical.com Subject: Re: [rt-users] Time Worked Report Do you have a /usr/local/rt3? /Johan From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Walid Haider Sent: den 29 mars 2011 15:20 To: Kenneth Crocker; rt-users

Re: [rt-users] Time Worked Report

2011-03-29 Thread Kenneth Crocker
: [rt-users] Time Worked Report Kenn, Again, thanks for the reply. As I ran a packaged install of RT 3.8.4, my $home is /usr/share/rt3. My folder structure is different compared to what you mention below, as I do not have a share directory within my RT $home. Please advise if I should

Re: [rt-users] Time Worked Report

2011-03-29 Thread Kenneth Crocker
:56 *To:* rt-users@lists.bestpractical.com *Subject:* Re: [rt-users] Time Worked Report Do you have a /usr/local/rt3? /Johan *From:* rt-users-boun...@lists.bestpractical.com [mailto: rt-users-boun...@lists.bestpractical.com] *On Behalf Of *Walid Haider *Sent:* den 29 mars 2011 15:20

Re: [rt-users] Time Worked Report

2011-03-29 Thread Kenneth Crocker
...@lists.bestpractical.com [mailto: rt-users-boun...@lists.bestpractical.com] *On Behalf Of *Johan Sjöberg *Sent:* terça-feira, 29 de Março de 2011 14:56 *To:* rt-users@lists.bestpractical.com *Subject:* Re: [rt-users] Time Worked Report Do you have a /usr/local/rt3? /Johan *From

[rt-users] Time Worked Report

2011-03-24 Thread Walid Haider
Hi, I am a bit of a newbie with RT, and was wondering if you could help me. After following the installation your instructions at http://requesttracker.wikia.com/wiki/TimeWorkedReport, I get the following errors when clicking on the Time Worked Report link in RT: Error during compilation of

Re: [rt-users] Time Worked Report

2011-03-24 Thread Kenneth Crocker
Walid, Did you copy the /share/... directories/files to .../local/. directories/files and make your modifications there? That a WAY safer way to make modifications. You may have forgotten one and that is the problem? Kenn LBNL On Thu, Mar 24, 2011 at 9:51 AM, Walid Haider

Re: [rt-users] Time Worked Report

2011-03-24 Thread Kevin Falcone
On Thu, Mar 24, 2011 at 04:51:28PM +, Walid Haider wrote: This implies that you have a syntax error in your copy and paste Error during compilation of /usr/share/rt3/html/Elements/SelectMultiQueue: Global symbol $d requires explicit package name at

[rt-users] Time Worked Report

2011-02-03 Thread Alexander Köhler
Hi all, i installed the Time Worked Report (http://requesttracker.wikia.com/wiki/TimeWorkedReport) on our RT 3.8.7 and got Errors by opening the TimeWorkedReport.html from my RT: Error during compilation of /usr/share/request-tracker3.8/html/Elements/SelectMultiQueue: Global symbol $d

Re: [rt-users] Time Worked Report

2009-08-14 Thread Joel Hartshorn
To: Joel Hartshorn; rt-users@lists.bestpractical.com Subject: Re: [rt-users] Time Worked Report Fran Fabrizio and I whipped up a script that can take a date range, either local time or UTC, and output a report on the command line. It's trivial to wrap that to output html to a location in your local

Re: [rt-users] Time Worked Report

2009-08-13 Thread Drew Barnes
Fran Fabrizio and I whipped up a script that can take a date range, either local time or UTC, and output a report on the command line. It¹s trivial to wrap that to output html to a location in your local tree and have a daily report with cron. I believe I put it on the wiki, but will have to

[rt-users] Time Worked Report

2009-08-12 Thread Joel Hartshorn
Did the thread on the Time Worked Report ever get resolved? This is the thread started by Stephen Cochran. back in 3/09 or so'ish... Joel Hartshorn Internet Engineer/New Media The Seattle Times Company 206 464 2323 nwsource.com | seattletimes.com smime.p7s Description: S/MIME cryptographic

Re: [rt-users] Time Worked Report

2009-03-03 Thread Alex Young
...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Stephen Cochran Sent: 03 March 2009 05:01 To: rt Users Subject: [rt-users] Time Worked Report I've written a sql query to pull out the time worked for all tickets resolved in the last week among other things. The problem

Re: [rt-users] Time Worked Report

2009-03-03 Thread Alex Young
[mailto:stephen.a.cochran.li...@cahir.net] Sent: 03 March 2009 14:27 To: Alex Young Subject: Re: [rt-users] Time Worked Report Thinking through this, the only way to be completely accurate list of time spend in some given time_window would be the following (in psudo sql): # total time worked

Re: [rt-users] Time Worked Report

2009-03-03 Thread Alex Young
time. Same for adding time. Stephen, dont forget to reply to all if you want the list to see your replies. (Which I think you do) From: Stephen Cochran [mailto:stephen.a.cochran.li...@cahir.net] Sent: 03 March 2009 15:33 To: Alex Young Subject: Re: [rt-users] Time Worked Report You

Re: [rt-users] Time Worked Report

2009-03-03 Thread Stephen Cochran
...@cahir.net] *Sent:* 03 March 2009 14:27 *To:* Alex Young *Subject:* Re: [rt-users] Time Worked Report Thinking through this, the only way to be completely accurate list of time spend in some given time_window would be the following (in psudo sql): # total time worked in time_window from

Re: [rt-users] Time Worked Report

2009-03-03 Thread Kenneth Crocker
of the code and info must already be available in RT to do this. *From:* Stephen Cochran [mailto:stephen.a.cochran.li...@cahir.net] *Sent:* 03 March 2009 14:27 *To:* Alex Young *Subject:* Re: [rt-users] Time Worked Report Thinking through this, the only way to be completely

Re: [rt-users] Time Worked Report

2009-03-03 Thread Stephen Cochran
, dont forget to *reply to all* if you want the list to see your replies. (Which I think you do) *From:* Stephen Cochran [mailto:stephen.a.cochran.li...@cahir.net] *Sent:* 03 March 2009 15:33 *To:* Alex Young *Subject:* Re: [rt-users] Time Worked Report You could use the same logic

[rt-users] Time Worked Report

2009-03-02 Thread Stephen Cochran
I've written a sql query to pull out the time worked for all tickets resolved in the last week among other things. The problem with this is that it doesn't give a complete picture of time worked for any given week since a ticket could have had time worked put in as part of a transaction but the