How can I export data from auto-tracker?

Tips, Tricks & How to's
7

For anyone following this, the clockify team has made this possible, now. The auto tracker entries are available in an SQLite database file.

“C:\Users\\AppData\Local\Clockify\ClockifyDB_v2.db” is the correct location under windows, or short: “%LocalAppData%\Clockify\ClockifyDB_v2.db” in the table “AutoTrackerItems“.

Here’s an R script I had a good fellow of mine “generate” to get started

library(DBI)
library(RSQLite)
library(tidyverse)

# Build path dynamically for any Windows user
db_path <- file.path(Sys.getenv("LOCALAPPDATA"), "Clockify", "ClockifyDB_v2.db")

if (!file.exists(db_path)) {
  stop("Clockify database not found at: ", db_path)
}

con <- dbConnect(SQLite(), dbname = db_path)

# Fetch tables
auto_tracker_items <- dbReadTable(con, "AutoTrackerItems") |> as_tibble()
time_entries       <- dbReadTable(con, "TimeEntries")      |> as_tibble()

dbDisconnect(con)

# Preview
glimpse(auto_tracker_items)
glimpse(time_entries)

and then do with that chaos whatever you will.

I am also posting this answer to Auto Tracker Data