Admin · Setup

Import workbench

Paste JSON, see exactly what it will do, then apply through an audited database function. Applies run as you, so sign in first.

You are signed out

Previews still work, but every apply will be refused. Go to login.

EnvironmentReadyRoot env loaded

Remote writesTest windowGuarded CLIs

Bootstrap payloadValid1 company, 48 periods

Schema apply50 workbenchespnpm v2:migration-status

Work

Sprint history

Back to the app

External AI briefing

Copy this prompt, paste it into ChatGPT/Claude with your Excel/CSV, then paste the returned JSON here.

Company

PAN: not set — add at /app/company

VAT: not set — add at /app/company

Fiscal yearSource dataNepal VAT/TDS conventionsAmounts in minor units (paisa)I will attach a spreadsheet

Your notes for the AI (column mapping, PAN, special cases)

Examples are templates, not gospel

Repo examples pass structural validation but use placeholder tax IDs and sample amounts. Your accountant should confirm statutory rules and opening balances before you apply in production.

Sprint history JSON

Valid

121 lines

{
  "companyCode": "SCC",
  "sprints": [
    {
      "workspaceCode": "OPS",
      "code": "FB-SPRINT-EXAMPLE-1",
      "name": "Sprint 12 (legacy)",
      "startsOnAd": "2025-01-05",
      "endsOnAd": "2025-01-18",
      "closedAt": "2025-01-19T03:15:00.000Z",
      "closedByEmail": "sammancreative@gmail.com",
      "legacyRef": {
        "path": "companies/legacyCo/workspaces/legacyWs/sprint_reports/sprint_board1_2025-01-18",
        "boardPath": "companies/legacyCo/workspaces/legacyWs/kanban_boards/board1",
        "generation": 3
      },
      "summary": {
        "plannedScope": 14,
        "plannedCompleted": 11,
        "carriedForwardAtStart": 2,
        "addedMidSprint": 3,
        "expedited": 1,
        "removed": 1,
        "cancelled": 0,
        "unresolvedCarryForward": 3,
        "returnedToBacklog": 1,
        "scopeChangeRate": 0.29,
        "spilloverReason": null,
        "nextSprintIntention": null
      },
      "members": [
        {
          "employeeCode": "SC-001",
          "legacyPerson": null,
          "assigned": 8,
          "completed": 6,
          "wip": 1,
          "unresolved": 2,
          "notStarted": 1,
          "reviewRequests": 3,
          "reviewed": 4,
          "plannedAssigned": 7,
          "plannedCompleted": 6,
          "unplannedAssigned": 1,
          "unplannedCompleted": 0,
          "carriedForwardAssigned": 1,
          "expeditedAssigned": 0
        },
        {
          "employeeCode": null,
          "legacyPerson": { "uid": "legacyUid123", "email": "former.colleague@example.com", "name": "Former Colleague" },
          "assigned": 6,
          "completed": 5,
          "wip": 0,
          "unresolved": 1,
          "notStarted": 0,
          "reviewRequests": 2,
          "reviewed": 1,
          "plannedAssigned": 6,
          "plannedCompleted": 5,
          "unplannedAssigned": 0,
          "unplannedCompleted": 0,
          "carriedForwardAssigned": 1,
          "expeditedAssigned": 1
        }
      ],
      "cards": [
        { "title": "Example card", "workStatus": "done", "issueType": "task", "priority": "medium", "storyPointEstimate": 3, "sprintEntryType": "planned", "closeDisposition": "completed" }
      ]
    },
    {
      "workspaceCode": "OPS",
      "code": "FB-SPRINT-EXAMPLE-2",
      "name": "Sprint 3 (legacy, generation 1)",
      "startsOnAd": "2024-12-22",
      "endsOnAd": "2025-01-04",
      "closedAt": "2025-01-04T12:00:00.000Z",
      "closedByEmail": null,
      "legacyRef": {
        "path": "companies/legacyCo/workspaces/legacyWs/sprint_reports/autoId1",
        "boardPath": "companies/legacyCo/workspaces/legacyWs/kanban_boards/board0",
        "generation": 1
      },
      "summary": {
        "plannedScope": null,
        "plannedCompleted": null,
        "carriedForwardAtStart": null,
        "addedMidSprint": null,
        "expedited": null,
        "removed": null,
        "cancelled": null,
        "unresolvedCarryForward": null,
        "returnedToBacklog": null,
        "scopeChangeRate": null,
        "spilloverReason": null,
        "nextSprintIntention": null
      },
      "members": [
        {
          "employeeCode": "SC-002",
          "legacyPerson": null,
          "assigned": 4,
          "completed": 3,
          "wip": 0,
          "unresolved": 1,
          "notStarted": 0,
          "reviewRequests": 1,
          "reviewed": 2,
          "plannedAssigned": 0,
          "plannedCompleted": 0,
          "unplannedAssigned": 0,
          "unplannedCompleted": 0,
          "carriedForwardAssigned": 0,
          "expeditedAssigned": 0
        }
      ],
      "cards": []
    }
  ]
}

Preview

Sprint history preview

Company: SCC
Sprints: 2
Generations: gen1 1 · gen2 0 · gen3 1
Member rows: 3
Unresolved people: 1
Workspaces: OPS

1 warning

payload.sprints[0].members[1]: former.colleague@example.com is not matched to an employee; kept as legacy person

Upserts closed legacy sprints (Firebase sprint reports) with their counters and per-person numbers. Idempotent on the legacy path; never creates tasks.

Runs app.apply_import('sprint_history') as you; the database re-checks your permission and records an audit event.