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

Releases are published to PyPI by CI (trusted publishing — no tokens). Tag a version and push the tag; .github/workflows/publish.yml runs the test suite, builds, and uploads:

git tag v0.2.1
git push origin v0.2.1

Do not twine upload by hand — the tag's CI job would then fail on PyPI's "file already exists".

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.1.tar.gz (60.1 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.1-py3-none-any.whl (39.5 kB view details)

Uploaded Python 3

File details

Details for the file tentpole-0.2.1.tar.gz.

File metadata

  • Download URL: tentpole-0.2.1.tar.gz
  • Upload date:
  • Size: 60.1 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.1.tar.gz
Algorithm Hash digest
SHA256 f6d356eb53b0b78f9a22d16f3750c845f62ced59f3da4927117139ce145e2fc0
MD5 bde4b6ab576bb44e2b78f6f94ab000eb
BLAKE2b-256 1f67f9d99b7f0b0b276ad2d69396b4eeef820c8871c6e42bab653fa29db2f5b0

See more details on using hashes here.

Provenance

The following attestation bundles were made for tentpole-0.2.1.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.1-py3-none-any.whl.

File metadata

  • Download URL: tentpole-0.2.1-py3-none-any.whl
  • Upload date:
  • Size: 39.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.1-py3-none-any.whl
Algorithm Hash digest
SHA256 970e8762ca03c9f7d7b48418da5daa69dd46fcade3767b0ac5b9a3dd214fcd6a
MD5 f77a2323a4c23edba8622794fa6109aa
BLAKE2b-256 7d273122c40d62ac47cb8198775a9c342c18fbabbac1a718e9daecea0dace838

See more details on using hashes here.

Provenance

The following attestation bundles were made for tentpole-0.2.1-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