Klok 2 Entelect Time sheets (K2ET)

Transforms Klok2's time sheet format to the Entelect's one for importing.

Klok is a great tool for tracking your time sheets with. It is available in both a free and paid-for version. However neither option outputs data in a format that the Entelect time sheet system can handle and manually copying over your comments and times can be tedious and error prone.

Enter Klok 2 Entelect Time sheets (K2ET)!

Table of Contents

• Features
• Coming soon
• Setup
• Exporting and Importing
• Potential Ideas/Enhancements

Features

1. Simply drag the project-category you are working on to the working area, or double click it, a timer starts.
2. If you want to switch projects/categories, double click or drag that.
3. Before you take a break or go home, hit the stop button.
4. Once a day/week/month export your time sheet data from Klok and into Entelect's time sheet system.
5. Capture comments at any time to the block you are working on.

Coming Soon

1. Support for sentiment field by parsing the comment for any of the 3 smilies/emojis - :) :| :(
2. Support the ticket field by parsing the comment for a # symbol?
3. Klok marks a whole project as billable or non-billable, so would need to use the comment field. Maybe @billable?

Setup

1. Download and install Node.js 6.x or above
2. Download or Clone K2ET to your computer.
3. Open the K2ET folder in a terminal/command prompt and type npm install
4. Download your preferred version of Klok from the versions page.
5. Download your personalised time sheet template from the Entelect time sheet system. It will have the correct spelling of your personalised projects and category list.
6. Add some of the projects and categories that you frequently use, this should be in a 2 level project-category like you can see here:
7. Configure your Klok options as follows:
8. Capture your time by either double clicking on the categry or draggaing it to the Drop here to work on box.

Do not capture time against the project node directly or you will be sad :(

For tips and tricks to using Klok, check out the features page

Exporting and Importing

1. Choose the date range to export data for in the app. For the least admin, do this every week, however note that you can choose a custom date range. This comes in handy when the end of the month is in the middle of the week.
2. Save the file into your resources folder, it will be a .xls file.
3. Open the file in excel, you will get a warning, click yes.
4. Select File -> Save As, enter the name and file extension as below
5. Open the K2ET folder in a terminal/command prompt and type node .
6. Upload the file to the Entelect time sheet system using Chrome, FireFox does not seem to be supported. Verify and save the results.

Potential Ideas/Enhancements

1. Use something like git-release-notes to pull in comment data, based on some pre-defined format
2. Host this as a service
3. Create and distribute an electron app.
4. Find a way to sync the projects & categories across from Entelect to Klok, maybe using Klokwork Team Console
5. Ignore certain projects(Config list?) or entries (Comment?)
6. Ability to mark specific time entries as billable/nonbillable based on comment.
7. Ability to specify ticket number in comment.
8. Ability to specify Sentiment in comment.