<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Re: [rt-users] Time Worked Report</TITLE>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18783"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=136183019-14082009><FONT color=#0000ff
size=2 face=Arial>yes,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=136183019-14082009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=136183019-14082009><FONT color=#0000ff
size=2 face=Arial>i believe i have seen that. however, the main issue that
didn't appear to be resolved is that of not all "TimeWorked" transactions being
saved as rows in the Transactions table. EX: A comment shows as a
comment transaction with TimeTaken potentially recorded. However, there is
no transaction recorded w/in this table for the TimeWorked field being
changed.</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><FONT color=#000080 size=2 face=Arial>Joel
Hartshorn</FONT><BR><FONT color=#000080 size=2 face=Arial>Internet Engineer/New
Media</FONT><BR><FONT color=#000080 size=2 face=Arial>The Seattle Times
Company</FONT><BR><FONT color=#000080 size=2 face=Arial>206 464
2323</FONT><BR><FONT color=#000080 size=2 face=Arial>nwsource.com |
seattletimes.com</FONT><FONT color=#000080 face="Times New Roman"></FONT>
</SPAN></P>
<DIV> </DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> Drew Barnes
[mailto:barnesaw@ucrwcu.rwc.uc.edu] <BR><B>Sent:</B> Thursday, August 13, 2009
7:41 AM<BR><B>To:</B> Joel Hartshorn;
rt-users@lists.bestpractical.com<BR><B>Subject:</B> Re: [rt-users] Time Worked
Report<BR></FONT><BR></DIV>
<DIV></DIV><FONT size=4><FONT face="Calibri, Verdana, Helvetica, Arial"><SPAN
style="FONT-SIZE: 11pt">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.<BR><BR>I believe I put it on the wiki, but
will have to look at it.<BR><BR><BR>On 8/12/09 5:21 PM, "Joel Hartshorn"
<jhartshorn@seattletimes.com> wrote:<BR><BR></SPAN></FONT></FONT>
<BLOCKQUOTE><FONT size=4><SPAN style="FONT-SIZE: 11pt"><FONT face=Arial>Did
the thread on the Time Worked Report ever get resolved?</FONT><FONT
face="Calibri, Verdana, Helvetica, Arial"> <BR><BR></FONT><FONT
face=Arial>This is the thread started by Stephen Cochran… back in 3/09 or
so'ish...</FONT><FONT face="Calibri, Verdana, Helvetica, Arial">
<BR><BR></FONT><FONT color=#000080><FONT face=Arial>Joel Hartshorn<BR>Internet
Engineer/New Media<BR>The Seattle Times Company<BR>206 464
2323<BR>nwsource.com | seattletimes.com</FONT></FONT><FONT
face="Calibri, Verdana, Helvetica, Arial"> <BR><BR><BR>
<HR align=center SIZE=3 width="95%">
</FONT></SPAN><FONT face="Consolas, Courier New, Courier"><SPAN
style="FONT-SIZE: 10pt">_______________________________________________<BR><A
href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR><BR>Community
help: <A
href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A><BR>Commercial
support: sales@bestpractical.com<BR><BR><BR>Discover RT's hidden secrets with
RT Essentials from O'Reilly Media. <BR>Buy a copy at <A
href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A><BR></SPAN></FONT></FONT></BLOCKQUOTE><FONT
size=4><FONT face="Consolas, Courier New, Courier"><SPAN
style="FONT-SIZE: 10pt"><BR></SPAN></FONT><FONT
face="Calibri, Verdana, Helvetica, Arial"><SPAN style="FONT-SIZE: 11pt">--
<BR>Drew Barnes<BR>Applications Analyst<BR>Network Resources Dept.<BR>Raymond
Walters College<BR></SPAN></FONT></FONT></BODY></HTML>