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

Approve: Ingest & Incoming Format

To doOwner · mecs-ingest-okBlocker

Waiting on 9 · 9 still openWrite the raw-extract to INCOMING-FORMAT transform script 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 Run file-drop ingest end to end on the real extract 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

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

**Approve: Ingest & Incoming Format** · to do · blocker

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

## Waiting on 9

- Write the raw-extract to INCOMING-FORMAT transform script — to 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 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
- Run file-drop ingest end to end on the real extract — to do
- Review the first batch's quarantine jsonl and fix systematic row failures — to do
- Widen the HS_RULES keyword set beyond its hand-built ~13 categories — to do
- Stop synthetic being the default pipeline source once real drops exist — to do

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

## The brief on file

Clara — get "Approve: Ingest & Incoming Format" ready for my sign-off — tell me exactly what you need from me. This is in the ClearSource lane (task cs-ingest-ok). 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

Approve: Ingest & Incoming Format