trkr is a command-line tool to help track what our team is working on and
how long they work on it. With Trello and Google Sheets integration, it allows
you to search and select a related Trello card, and writes directly to a Worksheet.
Python 2.6+ or 3+
pip install trkrUsing trkr is as simple as running trkr run. A list of valid command is available
by running trkr --help.
Provide a description of the work accomplished. If none is provided, the commit message of the last commit at HEAD will be used.
Time worked in minutes (must be a valid integer).
You have the choice to (i)nput a card's URL, fuzzy (s)earch for a card, (p)ick from a list of your assigned cards, or choose to (n)ot include a card.
Enter a timestamp in the MM/DD/YYYY format. This can be skipped, and will instead
use the current date.
To start the setup script, run trkr setup. It will ask for an email, Trello
API keys, and the worksheet URL. All settings are saved at ~/.trkr/config.json,
and can be modified at a later time.
On Trello, navigate to a board and append .json to the URL. It should look
something like https://trello.com/c/<url>.json. When the JSON data has loaded,
hthe first id will be the Board ID; copy and save it somewhere.
Search next for your name or username, find the id associated with it, and
save it somewhere; this is your Client ID.
Trello API keys can be found at trello.com/app-key.
The hash found under Key is your API Key, and the one under Secret is your
API Secret. A Token can be generated by clicking Token on the same page; this
is your Token.
Once you've created a new Google Sheet, it's URL is the Document URL, and the name of the sheet at the bottom is the Worksheet Name.
In order to authorize trkr to read/write from a worksheet, follow the steps
layed out in Authorizing pygsheets.
With the JSON file in hand, move it to ~/.trkr/keyfile.json. Lastly, share
the worksheet with the email found in keyfile.json. trkr should now be setup
and ready to use!
trkr relies on the great work done by the pygsheets
and py-trello teams.