wakapi-sync

name	wakapi-sync
description	Daily Wakapi (WakaTime-compatible) summary → local CSV files. Fetch today stats and append/update CSVs for totals, top projects, and top languages.
metadata	{"openclaw":{"requires":{"env":["WAKAPI_URL","WAKAPI_API_KEY","WAKAPI_OUT_DIR"]},"primaryEnv":"WAKAPI_OUT_DIR"}}

wakapi-sync

Daily Wakapi (WakaTime-compatible) summary → local CSV files.

What it does

• Fetches today stats from Wakapi and appends/updates CSVs:
  • daily-total.csv (1 row/day)
  • daily-top-projects.csv (N rows/day)
  • daily-top-languages.csv (N rows/day)

Requirements

• Node.js 18+

Configuration (env vars)

• WAKAPI_URL (required)
  • Example: https://wakapi.example.com
• WAKAPI_API_KEY (required)
  • Your Wakapi API key.
• WAKAPI_OUT_DIR (required)
  • Output directory for CSVs.
  • Example: ~/wakapi-data

Optional:

• WAKAPI_TOP_N_PROJECTS (default: 10)
• WAKAPI_TOP_N_LANGUAGES (default: 10)

Auth:

• Uses Authorization: Basic base64(<api_key>) (matches our current Wakapi setup).

Usage

Run:

node scripts/wakapi-daily-summary.mjs

Output CSV schemas

daily-total.csv

Columns:

• date (YYYY-MM-DD)
• total_seconds
• total_hours
• projects_count
• languages_count

daily-top-projects.csv

Columns:

• date
• rank
• project
• seconds
• hours
• percent

daily-top-languages.csv

Columns:

• date
• rank
• language
• seconds
• hours
• percent