#568 Mirror Trello, Jira, Planner and OpenProject into timelines
–
- github
- github/openchronology/timeline-app
- github/openchronology/timeline-app#568
- pull request
- state:merged
Part of #538 (and #533): boards and plans join repositories as sources of work, so one timeline can gather a Trello board, a Jira project, a Planner plan, an OpenProject project and GitHub repositories. ## What a timeline shows - **Each card** (card, issue, task or work package) is a duration from its creation, ongoing until it is done. - **Its stays:** its time in each column (list, bucket or status) is a duration tagged `in column` and `status: `. - **Its plan:** its start and due dates become a `Planned: …` duration, so separating by `planned` gives a Gantt chart against what happened. OpenProject milestones are moments on their dates, and progress is tagged `progress: %`. - **Moments:** created, moved, assigned and unassigned, completed and reopened, labelled, renamed, rescheduled, progress. - **Links:** dependencies and parents (Jira issue links within the project, OpenProject relations). - **Tags:** the platform, `project: `, the card's own (`jira/proj-12`, `trello/ #12`), people as ` / `, and labels. ## How it gets there | Platform | Live | History | | --- | --- | --- | | Trello | webhooks (`X-Trello-Webhook`, HMAC-SHA1 over the body and the callback URL); the receiver answers Trello's `HEAD` check and reads each delivery's card again | the board's card actions | | Jira Cloud / Data Center | webhooks (`X-Hub-Signature`, sha256) | each issue's changelog, the start date's field found by name | | Microsoft Planner | no webhooks: the receiver reads routed plans every `PLANNER_POLL_MINUTES` and compares | creation, assignments and completion as Planner dates them | | OpenProject | webhooks (`X-OP-Signature`, sha1); a delivery is compared with the last one seen | each work package's activity (in English) and relations | - **Routing:** boards go in the same `github-routes.json` as repositories: `{"board": "jira:acme.atlassian.net/PROJ", "timeline": …}`. - **Importer:** `och-import-github --board ` reads what exists. - **New kinds:** `schedule` (plans, new dates, progress), `completed` under `state`, and `linked` under `relations`. - **Memory:** the receiver keeps each card's last reading in `boards.json` beside `GITHUB_STATE`. **Docs:** `docs/boards.md` (in the help's section with GitHub). Packaged `github.env` and Compose list the new settings, all commented out or empty. ## Testing - **Unit tests:** `test/board-source.test.mjs` covers each platform against a fake API. That includes the receiver taking Trello, Jira and OpenProject deliveries and refusing bad signatures, and Planner read three times (first reading, no change, then a move with progress). - **Against a real OpenProject 15** (local Docker): - **Reading:** the reader got the seeded demo project: 13 work packages with their plans, 3 milestones, parents and relations as 12 links. - **My changes:** a status change, closing and progress, made through the API, came out as moments. - **A real webhook:** a delivery captured from OpenProject's webhook log passed the receiver's signature check (401 with a wrong secret). - **Two fixes it led to:** a work package's first activity holds its starting values, not changes, and user links carry no names, so they are looked up. - **Not tested live:** Trello, Jira and Planner need accounts. Their API shapes come from their documentation, and their webhook signatures from their docs and third-party guides. 🤖 Generated with [Claude Code](https://claude.com/claude-code) https://claude.ai/code/session_011fFY8eruEi1xAkkMBni13B https://github.com/circagraph/timeline-app/pull/568
Related
- #12 Undo / Redo
- #533 gantt chart / employee task action tracking integration
- #538 Work-item sources: aggregate GitHub assignments, then Planner and kanban boards
- #569 Plan work as a Gantt chart: forge due dates, roadmaps and Microsoft Project files
- #571 Build Ubuntu server packages from the runners' own mirror
- Merge pull request #568 from openchronology/feat/work-boards
Open #568 Mirror Trello, Jira, Planner and OpenProject into timelines in the timeline