Changes between Version 12 and Version 13 of AgiloTicketReportPlugin


Ignore:
Timestamp:
Jun 3, 2015, 8:57:06 AM (9 years ago)
Author:
figaro
Comment:

Cosmetic changes

Legend:

Unmodified
Added
Removed
Modified

  • AgiloTicketReportPlugin

    v12 v13  
    11[[PageOutline(2-5,Contents,pullout)]]
    2 = Agilo Ticket Report Plugin =
    32
    4 == Description ==
     3= Agilo Ticket Report Plugin
    54
    6 Agilo (http://agile42.com/cms/pages/) is nice scrum process tools base on trac.  Every task ticket has an estimation time(hours), the team manager want to know exactly real working time comparing with estimated time. That's maybe metric of team member's working efficiency., so I developed this plugin for agilo. Thanks to agilo developers' sharing this tool, I just contribute something to open source community.
    7 == Solution ==
     5== Description
     6
     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.
     8
     9Thanks to the Agilo developers for sharing this tool.
     10
     11== Solution
     12
    813There is table named "ticket_change" in database make records of every ticket changes. So we can do data mining in current Trac Database.
    9 ==== Real working hours = ticket closed time - ticket accept time - None working time ====
    10 ==== Working time = from 9:00 am to 6:00 pm (exactly 9 hour including 1 hour lunch time) from Monday to Friday ====
    11 ==== None working time =  from 18 pm to next day 9 am of working days, Sta, Sun, Holidays(Manual configure) ====
    12 == Ticket Work Flow ==
     14 * '''Real working hours''' = ticket closed time - ticket accept time - none working time
     15 * '''Working time''' = from 9:00 to 18:00 (exactly 9 hour including 1 hour lunch time) from Monday to Friday
     16 * '''None working time''' = from 18:00 to next day 09:00 of working days, Sat, Sun, Holidays (manually configurable)
    1317
    14 Add "pending" status for ticket, if you do not want to add "pending" status, it also works[[BR]]
     18== Ticket Work Flow
    1519
    16 Why add “pending” status ?[[BR]]
     20Add "pending" status for ticket, if you do not want to add "pending" status, it also works.
    1721
    18 Sometime, we may accepted several tickets at one time in a sprint, we could not resolve tickets at same time, or some tickets may block by our customers.
    19   So, if we want to calculate the exactly working time, we must add the "pending" status.
     22Why add "pending" status ?
     23
     24Sometime, 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:
    2025
    2126[[Image(ticket_flow_chart2.PNG)]]
    2227
    23 Although standard process is O-->As-->A-->C-->R-->A-->C, but there are still some tickets do not follow the rule.
     28Although standard process is `O --> As --> A --> C --> R --> A --> C`, but there are still some tickets do not follow the rule.
    2429
    25 line1 = t1[[BR]]
     30 * line1 = t1
     31 * line2 = t2
     32 * line3 = t3 + t4 + t5
     33 * line4 = t3 + t4 + t6
     34 * line5 = t3 + t4 + t7
    2635
    27 line2 = t2[[BR]]
    28 
    29 line3 = t3 + t4 + t5[[BR]]
    30 
    31 line4 = t3 + t4 + t6[[BR]]
    32 
    33 line5 = t3 + t4 + t7
    34 
    35 == Bugs/Feature Requests ==
     36== Bugs/Feature Requests
    3637
    3738Existing bugs and feature requests for AgiloTicketReportPlugin are
    … …  
    3940
    4041If you have any issues, create a
    41 [http://trac-hacks.org/newticket?component=AgiloTicketReportPlugin&owner=todjiang new ticket].
     42[/newticket?component=AgiloTicketReportPlugin new ticket].
    4243
    43 == Download ==
     44[[TicketQuery(component=AgiloTicketReportPlugin&group=type,format=progress)]]
     45
     46== Download
    4447
    4548Download the zipped source from [download:agiloticketreportplugin here].
    4649
    47 == Source ==
     50== Source
    4851
    4952You can check out AgiloTicketReportPlugin from [http://trac-hacks.org/svn/agiloticketreportplugin here] using Subversion, or [source:agiloticketreportplugin browse the source] with Trac.
    5053
     54== Installation
    5155
    52 == Install ==
    53 
    54 {{{
    55 1. Download latest pyExcelerator lib and install it.
    56      --- pyExcelerator is open source python excel library
    57 http://sourceforge.net/projects/pyexcelerator/
     561. Download latest [http://sourceforge.net/projects/pyexcelerator/ pyExcelerator library] and install it. pyExcelerator is an open source Python excel library.
    5857
    59582. Configure
    … …  
    7069  PROJECT_NAME_PREFIX = "projects"
    7170
    72 3. working time time set up (optional)
     713. Working time time set up (optional)
    7372TicketReport\AgiloTicketReport\gethours.py
    7473line 12
    7574start time and end time of working day, and holiday configuration
    76 }}}
    77 trac.ini
     75trac.ini:
    7876
    79 {{{
    80 #!ini
     77{{{#!ini
    8178[ticket-workflow]
    8279+ pending = new,assigned,accepted,reopened -> pending
    … …  
    8885}}}
    8986
     87== Example
    9088
    91 == Example ==
    92 
    93 '''Web UI''' [[BR]]
     89'''Web UI''':
    9490
    9591[[Image(ticket_report.PNG)]]
    9692
    97 '''Generated Excel Report''' [[BR]]
     93'''Generated Excel Report''':
    9894
    9995[[Image(ticket_report_r16_01.PNG)]]
    10096
    101 == Recent Changes ==
     97== Recent Changes
    10298
    10399[[ChangeLog(agiloticketreportplugin, 3)]]
    104100
    105 == Author/Contributors ==
     101== Author/Contributors
    106102
    107103'''Author:''' [wiki:todjiang] [[BR]]