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

Write the raw-extract to INCOMING-FORMAT transform script

To doOwner · Claratransform-script

Unlocks 5Derive distinct container count per bol_number (CBP gives a list, the contract wants a count)Normalize country names to ISO alpha-2 and report every unmapped value Handle lbs to kg conversion driven by the extract's own unit field Reconcile estimated vs actual arrival date semantics in the mapping 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

**Write the raw-extract to INCOMING-FORMAT transform script** · to do

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

## Unlocks 5

- Derive distinct container count per bol_number (CBP gives a list, the contract wants a count)
- Normalize country names to ISO alpha-2 and report every unmapped value
- Handle lbs to kg conversion driven by the extract's own unit field
- Reconcile estimated vs actual arrival date semantics in the mapping
- Approve: Ingest & Incoming Format

## The brief on file

Clara — write the raw-extract to INCOMING-FORMAT transform script. This is in the ClearSource lane (task transform-script). 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

Write the raw-extract to INCOMING-FORMAT transform script