One-way Jira -> Smartsheet planning transformer
Project description
tentpole
One-way Jira → Smartsheet planning transformer. Jira stays the sole authoring surface; tentpole mirrors work data into Smartsheet and computes the planning intelligence on top: per-person capacity vs. demand, milestone deadline risk, long-epic ("tent-pole") runway, cross-team dependency gaps, hygiene flags, and longitudinal estimation-accuracy learning.
Design
Three layers with hard boundaries:
- Extract (
tentpole extract,tentpole pull): Jira Cloud REST → a plain-data bundle directory; Smartsheet → current sheet state. - Transform (
tentpole sync): a pure core — no I/O, no clock — turns bundle + state into explicit per-sheet change plans, snapshot records, and a sync-health report. - Load (
tentpole push): executes the change plans with bulk row operations, partial-success handling, and 429 backoff.
The sync never writes to Jira. The only Jira writes are the
human-invoked tentpole fix apply walk over structured hygiene fix
proposals, restricted to a hard allowlist (set fixVersion, set parent,
add link — never transitions, never deletes).
Install
pip install tentpole
Quickstart
-
Write
tentpole.yaml:jira: base_url: https://yourco.atlassian.net email: you@yourco.com token_env: JIRA_TOKEN # token read from this env var scope_jql: project = ABC projects: [ABC] board_id: 42 smartsheet: # Gov deployments: https://api.smartsheetgov.com/2.0 base_url: https://api.smartsheet.com/2.0 token_env: SMARTSHEET_TOKEN sheets: # ids from `tentpole bootstrap` issues: 111 # or created by hand from epics: 222 # `tentpole schema show` fixversions: 333 # All six machine-owned sheets must dependencies: 444 # be configured; sync produces plans capacity: 555 # for each, and push refuses to let accuracy: 666 # any plan go nowhere core: team: [ada, grace]
-
Create the sheets: print
tentpole schema showand build them by hand (supported path), or try the experimentaltentpole bootstrap --config tentpole.yaml. -
Write
rules/hygiene.yaml(required fortentpole fix propose; optional fortentpole extractandtentpole sync):# Team hygiene rules (spec section 5). `jql` is evaluated by Jira at extract # time; the extract adapter stores matching keys under the rule's name in the # bundle's hygiene.json. `derived` names a built-in check from # tentpole.hygiene.DERIVED_CHECKS; when both are present they AND together. # `fix` names a proposal strategy from tentpole.fixes.STRATEGIES. hygiene: - name: unanchored-work severity: red jql: "fixVersion is EMPTY" derived: inherits_no_fixversion message: "No milestone attached (directly or via epic)" fix: inherit_epic_fixversion - name: orphan-task severity: yellow jql: 'issuetype != Bug AND parent is EMPTY' message: "Task belongs to no epic" fix: suggest_epic_from_siblings
-
Run the loop (daily or on demand):
tentpole extract --config tentpole.yaml --out bundle/ --rules rules/hygiene.yaml tentpole pull --config tentpole.yaml --state state/ tentpole sync --bundle bundle/ --state state/ --out out/ --rules rules/hygiene.yaml tentpole push --config tentpole.yaml --plans out/plans --state state/
-
Personal planning check, any time:
tentpole check --bundle bundle/ --me ada
-
Hygiene fixes (human-reviewed; the only path that writes to Jira):
tentpole fix propose --bundle bundle/ --rules rules/hygiene.yaml --out proposals.json tentpole fix apply --config tentpole.yaml --proposals proposals.json
Releasing
python -m build
python -m twine upload dist/*
License
MIT
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file tentpole-0.2.0.tar.gz.
File metadata
- Download URL: tentpole-0.2.0.tar.gz
- Upload date:
- Size: 57.8 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
395707d11e104de081797a1c852823876cb6c2b69762f82dd7c88dac97825de0
|
|
| MD5 |
e3406572bf4cf33becaff580d8958331
|
|
| BLAKE2b-256 |
3317e15c3ae9bf0fa6c55c0723851a557fc3b78fbdf6283e1ebe6daf227ff08f
|
Provenance
The following attestation bundles were made for tentpole-0.2.0.tar.gz:
Publisher:
publish.yml on translunar/tentpole
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
tentpole-0.2.0.tar.gz -
Subject digest:
395707d11e104de081797a1c852823876cb6c2b69762f82dd7c88dac97825de0 - Sigstore transparency entry: 2160892477
- Sigstore integration time:
-
Permalink:
translunar/tentpole@6d64b231e276c05f5cbd59540c815ebe18197545 -
Branch / Tag:
refs/tags/v0.2.0 - Owner: https://github.com/translunar
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yml@6d64b231e276c05f5cbd59540c815ebe18197545 -
Trigger Event:
push
-
Statement type:
File details
Details for the file tentpole-0.2.0-py3-none-any.whl.
File metadata
- Download URL: tentpole-0.2.0-py3-none-any.whl
- Upload date:
- Size: 38.5 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
d5c009e908f1daca40957301042e4fec4fb551d0b0183ea6f5b3d952850e4184
|
|
| MD5 |
953d86755c62b259f395cd0c88e7330b
|
|
| BLAKE2b-256 |
37dbe15f04ef618f153a27998d85382357ad803ad00be5ee174747a49c146ffb
|
Provenance
The following attestation bundles were made for tentpole-0.2.0-py3-none-any.whl:
Publisher:
publish.yml on translunar/tentpole
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
tentpole-0.2.0-py3-none-any.whl -
Subject digest:
d5c009e908f1daca40957301042e4fec4fb551d0b0183ea6f5b3d952850e4184 - Sigstore transparency entry: 2160892820
- Sigstore integration time:
-
Permalink:
translunar/tentpole@6d64b231e276c05f5cbd59540c815ebe18197545 -
Branch / Tag:
refs/tags/v0.2.0 - Owner: https://github.com/translunar
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yml@6d64b231e276c05f5cbd59540c815ebe18197545 -
Trigger Event:
push
-
Statement type: