Configure Toggl Trello Data - sitMCella/toggl-trello-kpi GitHub Wiki

The binary application in the Toggl Trello KPI application is used for retrieving the data from Trello and Toggl using the REST APIs.

Build project

Use the proper GOOS and GOARCH parameters from https://golang.org/doc/install/source#environment.

env GOOS=[host_operating_system] GOARCH=[host_cpu] go build -o toggl-trello-kpi cmd/main.go

Configure Toggl and Trello Data

Run the application:

./toggl-trello-kpi -choice={choice_id} [options]

Where:

• choice_id: 1 -> Download the Toggl Time data as CSV file.
• choice_id: 2 -> Download the Trello cards as CSV file.
• choice_id: 3 -> Insert either the Toggl Time entries or the Trello card entries into the database from a CSV file.
• choice_id: 4 -> Download and store into the database the Toggl Time data.
• choice_id: 5 -> Download and store into the database the Trello Board cards.
• choice_id: 6 -> Download the database as CSV file. Provide the database name as argument. Provide optionally the list of column names as argument.
• choice_id: 7 -> Update the values of one specific column of a database table from the CSV file. Provide the CSV file, the table name, and the column name as arguments.
• choice_id: 8 -> Create the Grafana dashboard.

Example 1. Download the Toggl Time data as CSV file: ./toggl-trello-kpi -choice=1 2021 02

Example 2. Download the Trello cards as CSV file: ./toggl-trello-kpi -choice=2

Example 3.1. Insert the Toggl Time data into the database from a CSV file: ./toggl-trello-kpi -choice=3 toggl_time_entries.csv toggl_time

Example 3.2. Insert the Trello cards into the database from a CSV file: ./toggl-trello-kpi -choice=3 trello_entries.csv trello_card

Example 4. Download and store into the database the Toggl Time data: ./toggl-trello-kpi -choice=4

Example 5. Download and store into the database the Trello Board cards: ./toggl-trello-kpi -choice=5

Example 6.1. Downlaod the database table "toggl_time" as CSV file "toggl_time.csv": ./toggl-trello-kpi -choice=6 toggl_time

Example 6.2. Downlaod the database table "toggl_time" as CSV file "toggl_time.csv", and filter the columns "id,description,trello_card_id": ./toggl-trello-kpi -choice=6 toggl_time id,description,trello_card_id

Example 7. Update the column "trello_card_id" in database table "toggl_time" from the CSV file "toggl_time.csv": ./toggl-trello-kpi -choice=7 toggl_time.csv toggl_time trello_card_id

Example 8. Create the Grafana Dashboard from the configuration defined in "configuration/settings.yml": ./toggl-trello-kpi -choice=8

The choices 4, 5, 6 and 7 provide optional features.