Skip to main content

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

  1. 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]
    
  2. Create the sheets: print tentpole schema show and build them by hand (supported path), or try the experimental tentpole bootstrap --config tentpole.yaml.

  3. Write rules/hygiene.yaml (required for tentpole fix propose; optional for tentpole extract and tentpole 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
    
  4. 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/
    
  5. Personal planning check, any time:

    tentpole check --bundle bundle/ --me ada
    
  6. 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

tentpole-0.2.0.tar.gz (57.8 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

tentpole-0.2.0-py3-none-any.whl (38.5 kB view details)

Uploaded Python 3

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

Hashes for tentpole-0.2.0.tar.gz
Algorithm Hash digest
SHA256 395707d11e104de081797a1c852823876cb6c2b69762f82dd7c88dac97825de0
MD5 e3406572bf4cf33becaff580d8958331
BLAKE2b-256 3317e15c3ae9bf0fa6c55c0723851a557fc3b78fbdf6283e1ebe6daf227ff08f

See more details on using hashes here.

Provenance

The following attestation bundles were made for tentpole-0.2.0.tar.gz:

Publisher: publish.yml on translunar/tentpole

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

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

Hashes for tentpole-0.2.0-py3-none-any.whl
Algorithm Hash digest
SHA256 d5c009e908f1daca40957301042e4fec4fb551d0b0183ea6f5b3d952850e4184
MD5 953d86755c62b259f395cd0c88e7330b
BLAKE2b-256 37dbe15f04ef618f153a27998d85382357ad803ad00be5ee174747a49c146ffb

See more details on using hashes here.

Provenance

The following attestation bundles were made for tentpole-0.2.0-py3-none-any.whl:

Publisher: publish.yml on translunar/tentpole

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page