Working Hours Tracker
Work time manager for Sailfish OS
View on GitHub
Get it from OpenRepos
Flattr this project
Donate using Paypal
About
An easy to use and simple Working Hours Tracker for SailfishOS.
Current features:
- Adding hours
- Timer
- Viewing hours in different categories
- Deleting
- Editing
- Resetting database in settings
- Cover actions for timer and adding new hours
- Cover info for today, week and month
- Changing effort times by adjusting duration
- Adding break possibility
- Settings for default duration and default break
- Setting for timer autostart on app startup
- Break functionality in timer
- Possibility to adjust timer start time
- Support for different projects
- Project coloring
- Shows price for efforts if project hourlyrate is set
- Project view
- Category summary
- Email reports
- Exporting as csv and .sql
- Importing .sql dump
- Error logging
- Tasks within projects
Donations are welcome
Paypal EUR
Paypal USD
Working Hours Tracker project is in transifex. Please contribute to translations there:
Project in transifex
How to use
Working Hours Tracker is quite easy to use. Here are some detailed explanations on how to use it.
Adding hours
- You can access the add hours in the pulley menu on the first page. It takes you to the add page.
- Start the timer when starting to work. You can then close the app if you want to and the timer will stay running. At the end of your work day, stop the timer and it should take you to the add page where you can adjust the details, add description and select the project.
Adding projects
Projects can be added and edited in the settings. You can select the labelcolor and hourlyrate for a project. You can edit projects by clicking them. When editing a project you can select if you want to make that project the default project which will be automatically selected when adding hours. If you set the hourlyrate for a project, you will see the price for spent hours in the detailed listing and summaries.
Using the timer
Timer can be used by pressing the big button on the first page. When started, you will see three buttons for controlling the timer.
On the left you have a break button which is meant to be used if you have a break during your workday that you don't want to include in the duration. Break works just like the timer: you start it by clicking it and stop it when the break is over.
The button in the middle stops the timer and takes you to the add page where you will be able to adjust the start and endtime and other details for the effort. The hours will be saved only when accepting the dialog.
On the right side you have a button for adjusting the timer start time. It can be used if you forget to start the timer when you start to work.
Using the cover
Cover actions can be used to quickly add hours or to control the timer. Cover actions include adding hours, starting the timer, starting a break, ending a break and stopping the timer.
When stopping the timer from the cover, it should open up the appwindow in the add view and after closing the dialog it should get minimized back to cover.
Summaries
On the first page you will see total hours for different categories. If you have more than one projects you should see a attached page that can be accessed by swiping left from the first page. There you can see hours for one project at a time
Clicking a category will take you to the detailed listing view where you can see all entries in that category. You can edit those entries by clicking them.
By swiping left in the detailed view you can see a detailed summary for that category.
Settings
There are a few settings in the settings page that makes adding hours faster and easier. Default duration and default break duration will be used when manually adding hours. Starts now or Ends now by default means the option to select if you want the start time or the endtime be set to the time now when adding hours manually.
Other settings are explained in the settings page and more will come in the future versions.
Exporting
In the settings you find different methods for exporting data from Working Hours Tracker.
When selecting to export Hours as CSV the syntax will look like this:
'uid','date','startTime','endTime',duration,'project','description',breakDuration
Where entries surrounded by ' are strings (LONGVARCHAR or TEXT in the sqlite database) And durations are of type REAL with . as decimal separator. An example line would look like this:
'2015231425401087574','2015-04-20','12:38','18:44',6.1,'20153191429477190454','Code review',0
This is also the syntax which is expected for the .csv importing (Coming later...) Exporting
as .csv from Working Hours Tracker will create the data in the right format but if you e.g
want to import your existing data into Working Hours Tracker you can create .csv files in
the above syntax.
Please note that uid must be an unique id of type LONGVARCHAR and project should be an id
of an existing project in your database.
Project in hours means a project id.
When exporting projects as CSV the syntax will look like this:
'id','name',hourlyRate,contractRate,budget,hourBudget,'labelColor'
An example project line would look like this:
'20153191429477190454','Project name',0,0,0,0,'#ccb865'
Exporting the whole database creates a sqlite dump of the database.
Importing
At the moment importing is only possible from a .sql file. The .csv file support will come later.
Don't worry for duplicates when importing because the entries have unique id's and duplicates
cannot exist in the database due to unique constraints.
Please note that importing uses INSERT OR REPLACE so you can update edited entries.
Download stats
Since 14.10.2015