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

Run file-drop ingest end to end on the real extract

To doOwner · Claraing-sample-run

Waiting on 4 · 4 still openDerive 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

Unlocks 4Review the first batch's quarantine jsonl and fix systematic row failures Widen the HS_RULES keyword set beyond its hand-built ~13 categories Stop synthetic being the default pipeline source once real drops exist 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

**Run file-drop ingest end to end on the real extract** · to do

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

## Waiting on 4

- 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 value — to do
- Handle lbs to kg conversion driven by the extract's own unit field — to do
- Reconcile estimated vs actual arrival date semantics in the mapping — to do

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

## Unlocks 4

- Review the first batch's quarantine jsonl and fix systematic row failures
- Widen the HS_RULES keyword set beyond its hand-built ~13 categories
- Stop synthetic being the default pipeline source once real drops exist
- Approve: Ingest & Incoming Format

## The brief on file

Clara — run file-drop ingest end to end on the real extract. This is in the ClearSource lane (task ing-sample-run). 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

Run file-drop ingest end to end on the real extract