Command

PePersonal JEJust Electrolyte RTRelease Timer TtTacTile CSClearSource AtAthletic

ClearSource›ClearSource live on real, daily U.S. customs data›Ingest & Incoming Format·10 in this wave

Approve: Ingest & Incoming FormatTo do · blocker Write the raw-extract to INCOMING-FORMAT transform scriptTo do Derive distinct container count per bol_number (CBP gives a list, the contract wants a count)To do Normalize country names to ISO alpha-2 and report every unmapped valueTo do Handle lbs to kg conversion driven by the extract's own unit fieldTo do Reconcile estimated vs actual arrival date semantics in the mappingTo do Run file-drop ingest end to end on the real extractTo do Review the first batch's quarantine jsonl and fix systematic row failuresTo do Widen the HS_RULES keyword set beyond its hand-built ~13 categoriesTo do Stop synthetic being the default pipeline source once real drops existTo do

Wave

Ingest & Incoming Format

ClearSource › ClearSource live on real, daily U.S. customs data › Ingest & Incoming Format

0/10 done10 open1 open blocker

Selected taskclear

Derive distinct container count per bol_number (CBP gives a list, the contract wants a count)

To doOwner · Claraing-container-count

Waiting on 1 · 1 still openWrite the raw-extract to INCOMING-FORMAT transform script

Unlocks 2Run file-drop ingest end to end on the real extract Approve: Ingest & Incoming Format

Show the prompt

You are Clara, the agent for the ClearSource lane of Command.

Open the lane and work there:

```bash
cd ~/Command/clearsource && claude
```

Read that lane's CLAUDE.md and lane.json before you touch anything — they
carry your identity, your scope, and the hazards specific to this lane.
Read state from the hub (https://clearsource.matthewkvamme.com) or ask. Never guess at it.

## The task

**Derive distinct container count per bol_number (CBP gives a list, the contract wants a count)** · to do

Where it sits: ClearSource › ClearSource live on real, daily U.S. customs data › Ingest & Incoming Format

## Waiting on 1

- Write the raw-extract to INCOMING-FORMAT transform script — to do

1 of those is still open. If one genuinely blocks this, say so and stop rather than working around it.

## Unlocks 2

- Run file-drop ingest end to end on the real extract
- Approve: Ingest & Incoming Format

## The brief on file

Clara — derive distinct container count per bol_number (CBP gives a list, the contract wants a count). This is in the ClearSource lane (task ing-container-count). When done, write the result back to Command via your hub MCP and mark it todo.

## How to work this

- Do the work, don't just plan it. If the fix is obvious and safe, make it.
- Surface anything needing Matthew's sign-off instead of deciding it yourself.
- Short replies. Lead with the answer, then stop.
- Finish by saying what changed, what you verified, and what you'd do next.

To doIn progressDoneBlockedPick a wave on the left · tap a task to expand it

Lanes

Ingest & Incoming Format

Derive distinct container count per bol_number (CBP gives a list, the contract wants a count)