Working Hours Tracker
An easy to use and simple Working Hours Tracker for SailfishOS
- v. 1.3.7-1 (for phone and tablet) available in Jolla store (12.02.2018)
- Newest version available in openrepos
- Newest version also available with direct download here
Donations are welcome :)
Working Hours Tracker project is in transifex. Please contribute to translations there:
Updating resources in transifex
.tx/config contains the basic config for what needs to be pushed to tx.
~/.transifexrc, which stores your Transifex credentials in your home directory. You shouldn’t share this file since it contains your own credentials.
To push a source file, use the -s or --source flag with the push command:
$ tx push -s
To pull translations from Transifex, run the following command:
$ tx pull -a
- Adding hours
- Timer - saves starting time to database
- Viewing hours in different categories
- 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
- Exporting as .sql dump
- Importing database dump
- Setting for default break in timer
- Tasks within projects
- Autofill last used input
- Rounding to nearest
How to use
Working Hours Tracker is quite easy to use. Adding hours can be done in two different ways.
- 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.
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.
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.
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.
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:
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:
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:
An example project line would look like this:
Exporting the whole database creates a sqlite dump of the database.
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.
Still WIP (but it works)
Notes to myself on how to release a new version. This should be automated somehow.
- Verify that changes work correctly on all device types
- Push related changes to master
- Build both ARM and x86 versions in QT Creator
harbour-workinghourstracker.ymlwith correct version and build numbers
CHANGELOG.mdwith related changes
harbour-workinghourstracker.changeswith related changes
- Pull newest translations from Transifex
$ tx pull -a
- Commit these changes with commmit message:
- Push changes to master
- Create tag
- Push tag to origin
- Create a new release in GitHub with new binaries as attachments
- Release new binaries in openrepos
- Optionally send new release to Jolla store QA
- Make sure Github issues and
Roadmapproject are up to date