GitHub-Time-Tracking

Ruby app that analyzes GitHub Issue Comments, Milestones, and Code Commit Messages for Time Tracking and Budget Tracking information.

GitHub-Time-Tracking is designed to offer maximum flexibility in the way you use GitHub to track your time and budgets, but provide a time and budget syntax that is intuitive to use and read. Any emoji that is used was specifically chosen to be intuitive to its purpose. Of course you can choose your own set of Emoji if you do not like the predefined ones.

If you like GitHub-Time-Tracking, be sure to check out GitHub-Analytics: https://github.com/StephenOTT/GitHub-Analytics

News

March 1, 2014 Sinatra support has been added and mongo aggregation queries have started to be produced for MVP development. Time Tracker will be turned into a gem and some code will be refactored to better support the gem. The Sinatra App is currently part of this repo, but will be pushed into a separate repo sometime in the future. The app will use basic bootstrap to provide a theme for the interface and base queries will be support to provide time and budget totals for issues, milestones, labels, and commit messages(+commit comments). The Sinatra app is fully functioning with GitHub OAuth2 support and will download your repo issue, milestone, and commit data (that has time and budget information) into MongoDB. Stay Tuned!

Feb 23, 2014: Support has been re-added for tasks, milestones, and code commits, and code commit comments. The code still needs some cleanup in term of OO based structure, but it is fully functioning. All features listed below are supported. I will be updating the diagrams and images of the improved data structure in the next few days as time permits.

Feb 19, 2014: Large changes are occurring with Time Tracker to make it more modular. All old code will be kept in the "Old Files to be Processed" folder until all functions have been transferred into the new modular structure. This will be a multi-phase transition so changes will occur. As of Feb 19, 2014, the Issue Time Tracking with NonBillable Hours support has been provided along with download into MongoDB. Next will be to get Issue Budgets working followed by Milestone Budgets, followed by a rebuild of the Advanced Label support which covers creating multiple label levels/categories. The Final stage will be the implementation of the Task level time and budget tracking. If anyone has a need for a feature sooner rather than later, please post the request in the issue queue. See the 0.5 Branch for the code changes

How to run the Web App:

1. Register/Create a Application at https://github.com/settings/applications/new. Set your fields to the following:

   1.1. Homepage URL: http://localhost:9292

   1.2. Authorization callback URL: http://localhost:9292/auth/github/callback

   1.3. Application Name: GitHub-Time-Tracking or whatever you want to call your application.

2. Install MongoDB (typically: brew update, followed by: brew install mongodb)

3. cd into the app folder and run the following commands in the app folder:

   3.1. Run mongod in terminal

   3.2. Open a second terminal window and run: bundle install

   3.3.GITHUB_CLIENT_ID="YOUR CLIENT ID" GITHUB_CLIENT_SECRET="YOUR CLIENT SECRET" bundle exec rackup
   Get the Client ID and Client Secret from the settings of your created/registered GitHub Application in Step 1.

4. Go to http://localhost:9292

NOTE: The web app is under development at the moment, so while the code will always be executable for demo purposes, there are many links that have hard coded variables at the moment. So if you want to test out on your own repo you will have to make a few modifications.

--

Minimal Viable Product: Time Tracking Web App

Some Initial same images for first iteration of development

Time Tracking Usage Patterns

Logging Time for an Issue

Logging time for a specific issue should be done in its own comment. The comment should not include any data other than the time tracking information.
NOTE: The Body of the Issue (the text you write when you first open the issue), is not a comment. You must make a comment for a time-comment to function. The logic is that if you were to make a issue, the opening of the issue would contain the information about the issue, and then subsequent comments would have time-comments.

Examples

1. :clock1: 2h # => :clock1: 2h

2. :clock1: 2h, 3pm # => :clock1: 2h, 3pm

3. :clock1: 2h, 3:20pm # => :clock1: 2h, 3:20pm

4. :clock1: 2h, Feb 26, 2014 # => :clock1: 2h, Feb 26, 2014

5. :clock1: 2h, Feb 26, 2014 3pm # => :clock1: 2h, Feb 26, 2014 3pm

6. :clock1: 2h, Feb 26, 2014 3:20pm # => :clock1: 2h, Feb 26, 2014 3:20pm

7. :clock1: 2h, Installed security patch and restarted the server. # => :clock1: 2h, Installed security patch and restarted the server.

8. :clock1: 2h, 3pm, Installed security patch and restarted the server. # => :clock1: 2h, 3pm, Installed security patch and restarted the server.

9. :clock1: 2h, 3:20pm, Installed security patch and restarted the server. # => :clock1: 2h, 3:20pm, Installed security patch and restarted the server.

10. :clock1: 2h, Feb 26, 2014, Installed security patch and restarted the server. # => :clock1: 2h, Feb 26, 2014, Installed security patch and restarted the server.

11. :clock1: 2h, Feb 26, 2014 3pm, Installed security patch and restarted the server. # => :clock1: 2h, Feb 26, 2014 3pm, Installed security patch and restarted the server.

12. :clock1: 2h, Feb 26, 2014 3:20pm, Installed security patch and restarted the server. # => :clock1: 2h, Feb 26, 2014 3:20pm, Installed security patch and restarted the server.

• Dates and times can be provided in various formats, but the above formats are recommended for plain text readability.

• Any GitHub.com supported clock Emoji is supported:
  ":clock130:", ":clock11:", ":clock1230:", ":clock3:", ":clock430:", ":clock6:", ":clock730:", ":clock9:", ":clock10:", ":clock1130:", ":clock2:", ":clock330:", ":clock5:", ":clock630:", ":clock8:", ":clock930:", ":clock1:", ":clock1030:", ":clock12:", ":clock230:", ":clock4:", ":clock530:", ":clock7:", ":clock830:"

Sample

Logging Time for a Code Commit

When logging time in a Code Commit, the code commit message should follow the usage pattern. The commit message that you would normally submit as part of the code commit comes after the time tracking information. See example 7 below for a typical usage pattern. Code Commit time logging can be done as part of the overall Git Commit Message, individual GitHub Commit Comment or Line Comment.

Examples

1. :clock1: 2h # => :clock1: 2h

2. :clock1: 2h, 3pm # => :clock1: 2h, 3pm

3. :clock1: 2h, 3:20pm # => :clock1: 2h, 3:20pm

4. :clock1: 2h, Feb 26, 2014 # => :clock1: 2h, Feb 26, 2014

5. :clock1: 2h, Feb 26, 2014 3pm # => :clock1: 2h, Feb 26, 2014 3pm

6. :clock1: 2h, Feb 26, 2014 3:20pm # => :clock1: 2h, Feb 26, 2014 3:20pm

7. :clock1: 2h, Installed security patch and restarted the server. # => :clock1: 2h, Installed security patch and restarted the server.

8. :clock1: 2h, 3pm, Installed security patch and restarted the server. # => :clock1: 2h, 3pm, Installed security patch and restarted the server.

9. :clock1: 2h, 3:20pm, Installed security patch and restarted the server. # => :clock1: 2h, 3:20pm, Installed security patch and restarted the server.

10. :clock1: 2h, Feb 26, 2014, Installed security patch and restarted the server. # => :clock1: 2h, Feb 26, 2014, Installed security patch and restarted the server.

11. :clock1: 2h, Feb 26, 2014 3pm, Installed security patch and restarted the server. # => :clock1: 2h, Feb 26, 2014 3pm, Installed security patch and restarted the server.

12. :clock1: 2h, Feb 26, 2014 3:20pm, Installed security patch and restarted the server. # => :clock1: 2h, Feb 26, 2014 3:20pm, Installed security patch and restarted the server.

• Dates and times can be provided in various formats, but the above formats are recommended for plain text readability.

• Any GitHub.com supported clock Emoji is supported:
  ":clock130:", ":clock11:", ":clock1230:", ":clock3:", ":clock430:", ":clock6:", ":clock730:", ":clock9:", ":clock10:", ":clock1130:", ":clock2:", ":clock330:", ":clock5:", ":clock630:", ":clock8:", ":clock930:", ":clock1:", ":clock1030:", ":clock12:", ":clock230:", ":clock4:", ":clock530:", ":clock7:", ":clock830:"

Sample

Code Commit Message:

Code Commit Comment:

Code Commit Line Comment:

Logging Budgets for an Issue

Logging a budget for a specific issue should be done in its own comment. The comment should not include any data other than the budget tracking information.

Examples

1. :dart: 5d # => :dart: 5d

2. :dart: 5d, We cannot go over this time at all! # => :dart: 5d, We cannot go over this time at all!

Sample

Logging Budgets for a Milestone

Logging a budget for a milestone should be done at the beginning of the milestone description. The typical milestone description information comes after the budget information. See example 2 below for a typical usage pattern.

Examples

1. :dart: 5d # => :dart: 5d

2. :dart: 5d, We cannot go over this time at all! # => :dart: 5d, We cannot go over this time at all!

Sample

Tracking Non-Billable Time and Budgets

The ability to indicate where a Time Log and Budget is considered Non-Billable has been provided. This is typically used when staff are doing work that will not be billed to the client, but you want to track their time and indicate how much non-billable/free time has been allocated. The assumption is that all time logs and budgets are billable unless indicated to be Non-Billable.

You may indicate when a time log or budget is non-billable time in any Issue Time Log, Issue Budget, Milestone Budget, Code Commit Message, and Code Commit Comment.

To indicate if time or budgets are non-billable, you add the :free: :free: emoji right after your chosen clock emoji (like :clock1: :clock1:) or for budget you would place the :free: :free: emoji right after the :dart: :dart: emoji.

Non-Billable Time and Budget Tracking Indicator Usage Example

Logging Non-Billable Time for an Issue

Examples

1. :clock1: :free: 2h # => :clock1: :free: 2h

Logging Non-Billable Time for a Code Commit Message

Examples

1. :clock1: :free: 2h # => :clock1: :free: 2h

Logging Non-Billable Time for a Code Commit Comment

Examples

1. :clock1: :free: 2h # => :clock1: :free: 2h

Logging Non-Billable Budgets for an Issue

Examples

1. :dart: :free: 5d # => :dart: :free: 5d

Logging Non-Billable Budgets for a Milestone

Examples

1. :dart: :free: 5d # => :dart: :free: 5d

Sample Data Structure for Reporting

NOTE: These images are out of date. New data structures have been implemented and are in full use in the Time Tracker Gem and the Sinatra App. Sample data structures will be updated shortly.

Time Logging in a Issue

Budget Logging in a Issue

Budget Logging in a Milestone

Code Commit Time Logging - Supports Time Logging in Commit Message and Commit Comments

Notice the parent Duration field is empty. This is due to time being logged in the commit comments rather than the the Git Commit Message. A use case for this would be if the developer forgot to add the Time tracking information in their Git Commit Message, they can just add it to the Commit Comments after the commit has been pushed to GitHub without any issues or errors.

Future Features

1. Tracking of Billable and non-billable hours Done

2. Breakdown by Milestones

3. Breakdown by User

4. Breakdown by Labels

5. Printable View

6. Import from CSV

7. Export to CSV

8. Budget Tracking (What is the allocated budget of a issue, milestone, label, etc) Done

9. Code Commit Time Tracking Done

10. Support Business Hours Time and Budget Logging. Example: 1 week will equal 5 days (1 Business Week) rather than 1 week equalling 7 days (1 Calendar Week). Most popular use case would be able to say 1 Day would equal 8 hours rather than 24 hours. This is upcoming as the Chronic_Duration Gem has merged a pull request to support this feature.

11. Add Ability to parse Label grouping words out of labels. This will allow Web app to categorize beyond milestones and to categorize within a label. Example: Label = Project Management: Project Oversight. Label = Business Analysis: Requirements Definition. Done

12. Add ability to track Size of Issues - Likely will use Labels as Size (something like Small, Med, Large)

13. Add ability to track estimated effort for an issue. Estimated effort and Budget are different. Budget is something that has been determined by the Project Management-like user. Estimated Effort is a duration that has been determined by the developer. Who this is submitted in the syntax still needs to be determined. Thinking maybe :8ball: or maybe Playing Cards emoji that is a relation to Agile Poker. Labels support is already provided. So you can currently use labels to categorize level of effort estimates.

14. Explore the use of Natural Language Processing Libraries such as OpenNPL for better text processing.

15. Add GitLab support. This is upcoming. Need to tweak data input structures and OmniOAuth support. But it looks like its very possible.

Process Overview

Future Process rebuilt around Object Based design:

Data Analysis

This section will grow as the data analysis / UI is developed for the application

Data output from Data Analyzer and MongoDB

Using the MongoDB Aggregation Framework a series of high level aggregations are preformed to provide the required data for the front-end to display needed Time Tracking information.

Issue Time Output

NOTE: These images are out of date. New data structures have been implemented and are in full use in the Time Tracker Gem and the Sinatra App. Structures will be updated shortly.

[
    {
        "repo_name"=>"StephenOTT/Test1",
        "type"=>"Issue Time",
        "assigned_milestone_number"=>1,
        "issue_number"=>6,
        "issue_state"=>"open",
        "duration_sum"=>43200,
        "issue_count"=>3
    },
    {
        "repo_name"=>"StephenOTT/Test1",
        "type"=>"Issue Time",
        "assigned_milestone_number"=>1,
        "issue_number"=>7,
        "issue_state"=>"open",
        "duration_sum"=>14400,
        "issue_count"=>1
    }
]

Issue Budget Output

[
    {
        "repo_name"=>"StephenOTT/Test1",
        "type"=>"Issue Budget",
        "issue_number"=>7,
        "assigned_milestone_number"=>1,
        "issue_state"=>"open",
        "duration_sum"=>57600,
        "issue_count"=>1
    }
]

Milestone Budget Output

[
    {
        "repo_name"=>"StephenOTT/Test1",
        "type"=>"Milestone Budget",
        "milestone_number"=>1,
        "milestone_state"=>"open",
        "duration_sum"=>604800,
        "milestone_count"=>1
    }
]