Create a SQLite database containing data from your Toggl account
Project description
toggl-to-sqlite
Create a SQLite database containing data from your Toggl account.
How to install
$ pip install toggl-to-sqlite
Usage
You will need to first obtain a valid API token for your toggl account. You can do this by running the auth
command and following the prompts:
$ toggl-to-sqlite auth
You will need to get your API Token from this page
https://track.toggl.com/profile
Once you have your API Token enter it at the command line.
Authentication tokens written to auth.json
Now you can fetch all of your items from toggl like this:
$ toggl-to-sqlite fetch toggl.db
You can choose to get only time_entries
, projects
, or workspaces
by speciying a type in the argument like this.
To get ONLY your workspaces:
$ toggl-to-sqlite fetch -t workspaces toggl.db
To get your workspaces and projects:
$ toggl-to-sqlite fetch -t workspaces -t projects toggl.db
The default is to get all three of time_entries
, projects
, and workspaces
Additionally, you can specify to get time_entries since a specific date. You do this by specifying the since
option:
$ toggl-to-sqlite fetch -s 2021-03-13
Using with Datasette
The SQLite database produced by this tool is designed to be browsed using Datasette. Use the datasette-render-timestamps plugin to improve the display of the timestamp values.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for toggl_to_sqlite-0.2.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7cfffb3af7f931c412ffe3c65f9be82e460fe22d81d8056b673e0371ed4f8334 |
|
MD5 | 53d7939392a930e044a339f3f5e90d6a |
|
BLAKE2b-256 | 95314077cac0d89de086097bf0f9aac935a0962f23a0a22d7974cd3acbfb2074 |