Changes between Version 13 and Version 14 of AgiloTicketReportPlugin


Ignore:
Timestamp:
Nov 12, 2015, 4:48:47 PM (8 years ago)
Author:
figaro
Comment:

Cosmetic changes

Legend:

Unmodified
Added
Removed
Modified
  • AgiloTicketReportPlugin

    v13 v14  
    55== Description
    66
    7 [http://agile42.com/cms/pages/ Agilo] is a nice scrum process tools base on Trac. Every task ticket has an estimation time(hours), the team manager wants to know exactly the real working time compared with estimated time. That is a metric of team member's working efficiency, so I developed this plugin for Agilo.
     7[http://agile42.com/cms/pages/ Agilo] is a Scrum process tool based on Trac. Every task ticket has an estimation time (measured in hours) and in a typical use case the team manager wants to know the actual working time compared with the estimated working time. That would be a metric of team member's working efficiency, so I developed this plugin for Agilo.
    88
    99Thanks to the Agilo developers for sharing this tool.
    1010
    11 == Solution
     11=== Solution
    1212
    13 There is table named "ticket_change" in database make records of every ticket changes. So we can do data mining in current Trac Database.
     13There is a table named "ticket_change" in the database that records every ticket change. So we can perform data mining in the Trac Database:
    1414 * '''Real working hours''' = ticket closed time - ticket accept time - none working time
    1515 * '''Working time''' = from 9:00 to 18:00 (exactly 9 hour including 1 hour lunch time) from Monday to Friday
    1616 * '''None working time''' = from 18:00 to next day 09:00 of working days, Sat, Sun, Holidays (manually configurable)
    1717
    18 == Ticket Work Flow
     18=== Ticket Work Flow
    1919
    20 Add "pending" status for ticket, if you do not want to add "pending" status, it also works.
     20Add a "pending" status for tickets. If you do not want to add "pending" status, it works equally well.
    2121
    22 Why add "pending" status ?
    23 
    24 Sometime, we may accept several tickets at one time in a sprint, we could not resolve tickets at same time, or some tickets may block by our customers. So, if we want to calculate the exactly working time, we must add the "pending" status:
     22Why add "pending" status? Sometime, we may either accept several tickets at one time in a sprint, or we could not resolve tickets at same time, or some tickets may be blocked by our customers. In that case, if we want to calculate the exact working time, we must add the "pending" status:
    2523
    2624[[Image(ticket_flow_chart2.PNG)]]
    2725
    28 Although standard process is `O --> As --> A --> C --> R --> A --> C`, but there are still some tickets do not follow the rule.
     26Although the standard process is `O --> As --> A --> C --> R --> A --> C`, there are still some tickets that do not follow the rule.
    2927
    3028 * line1 = t1
     
    4644== Download
    4745
    48 Download the zipped source from [download:agiloticketreportplugin here].
     46Download the zipped source from [export:agiloticketreportplugin here].
    4947
    5048== Source
    5149
    52 You can check out AgiloTicketReportPlugin from [http://trac-hacks.org/svn/agiloticketreportplugin here] using Subversion, or [source:agiloticketreportplugin browse the source] with Trac.
     50You can check out AgiloTicketReportPlugin from [/svn/agiloticketreportplugin here] using Subversion, or [source:agiloticketreportplugin browse the source] with Trac.
    5351
    5452== Installation
    5553
    56 1. Download latest [http://sourceforge.net/projects/pyexcelerator/ pyExcelerator library] and install it. pyExcelerator is an open source Python excel library.
     541. Download the latest [http://sourceforge.net/projects/pyexcelerator/ pyExcelerator library] and install it. pyExcelerator is an open source Python Excel library.
    5755
    58562. Configure
     
    6159line 35
    6260
    63 if you use single project
    64 # just left PROJECT_NAME_PREFIX empty
     61if you use single project:
     62# just leave PROJECT_NAME_PREFIX empty
    6563  PROJECT_NAME_PREFIX = ""
    6664else # use multiple projects
     
    6967  PROJECT_NAME_PREFIX = "projects"
    7068
    71 3. Working time time set up (optional)
     693. Working time time set up (optional):
    7270TicketReport\AgiloTicketReport\gethours.py
    7371line 12
     
    102100
    103101'''Author:''' [wiki:todjiang] [[BR]]
    104 '''Maintainer:''' ''none'' [[BR]]
     102'''Maintainer:''' [[Maintainer]] [[BR]]
    105103'''Contributors:'''