Chronophore

Added
- New UI implemented with Qt5.
- The new UI is more stable and easy to use.

Changed
- The old Tk UI is no longer used by default, but is still available with the `--tk` command line option.

Fixed
- The numpad enter key is properly bound in all Qt dialogs.
- The numpad enter key is properly bound in the Tk user type selection dialog.

Removed
- `chronophore_migrate.py`
- `json_to_sqlite.py`
- These scripts are attached separately below in `removed_scripts.zip`.

Added
- Sign-in/sign-out confirmation dialog. Users can cancel a sign-in or sign-out.
- A window pops up to notify unregistered users they can register at the front desk.
- More informative logging in `--verbose` mode.

Changed
- When flagging forgotten timesheet entries, the `time_out` field will be left as `Null`. Previously it was set to `00:00`. A script called `chronophore_migrate.py` is included to update an existing database to conform with this convention.

Deprecated
- The `json_to_sqlite.py` script will be removed in the next release.

Fixed
- No longer crash when the config file is missing an option. Instead back up the existing config file and use the default in its stead.
- No longer try to flag already flagged timesheet entries.
- No longer include users from past days in 'currently signed in' list.

Removed
- Scripts to generate sample data and convert between .json and .xlsx are no longer needed, and have been removed.
- `excel_to_json.py`
- `json_to_excel.py`
- `gen_sample_data.py`
- `gen_user_data.py`
- They are attached separately below in `removed_scripts.zip`.

Added
- Command line options for Chronophore:
- `--testdb` 'create and use a database with test users'
- Test user IDs: `000000000`, `000111111`, `000222222`
- `--verbose` 'print a detailed log'
- `--debug` 'print debug log'
- `--version` 'print version info and exit'
- Support for different types of user:
- Each user can be a student, a tutor, or both.
- If they are both a student and a tutor, they will be prompted to choose each time they sign in.
- Automatic flagging of bad timesheet entries:
- Each time Chronophore starts, it looks through the timesheet data from past days, finds any entries where a user forgot to sign out, and flags them.

Changed
- Chronophore now stores data in a single sqlite database containing of the following two tables:
- **users**: Information about all registered users.
- **timesheet**: Sign-in and sign-out data.
- The database can be managed and browsed by many free and open source tools.
- [DB Browser for SQLite](http://sqlitebrowser.org/) offers a simple graphical interface. It can export the data to .csv, which can then be easily imported into a spreadsheet.
- JSON files are no longer used for data storage. A script, `json_to_sqlite.py` is included to migrate old json data to the new sqlite database.

Deprecated
- Scripts to generate sample data and convert between .json and .xlsx are no longer needed, and will be removed in the next release:
- `excel_to_json.py`
- `json_to_excel.py`
- `gen_sample_data.py`
- `gen_user_data.py`

Removed
- Configuration options for validation
- `validate_users`: Users now must be registered in the database to be able to sign in.
- `user_id_length`: Length of user ids is no longer constrained or enforced.

Added
- Proper configuration file support! A default configuration file is generated in the appropriate directory when one is not found.

Changed
- If users.json is not found, a new one is generated. Previously, this required a default users.json to be packaged with Chronophore and copied. Now Chronophore generates a very simple users.json with just two users. These can be used for testing purposes in place of a real user data file:
- Hildegard Jensen: 876543210
- Carrie Cyr: 880000000
- Directories for logging, data, and configuration files are now located appropriately for different platforms.
- Linux:
- Config Directory: `~/.config/chronophore/`
- Data Directory: `~/.local/share/chronophore/`
- Logging Directory: `~/.cache/chronophore/log/`
- Windows:
- Data & Config Directory: `%APPDATA%\Local\chronophore\chronophore\`
- Logging Directory: `%APPDATA%\Local\chronophore\chronophore\Logs`

Fixed
- Names consisting of more than 2 space-separated words are now displayed correctly by the GUI.
- Excel to JSON conversion script no longer fails when encountering an empty cell in read-only mode with openpyxl-2.4.0.

Added
- Support for Python 3.4.
- Verbose debug output for conversion scripts, `excel_to_json.py` and `json_to_excel.py`. Enable logging with the `-v`, `--verbose` argument.
- Configurability of font sizes in `config.py`.

Changed
- Default font sizes/weights.

Fixed
- Bug in excel to json conversion script. It no longer crashes when reading empty datetime cells.