Pack: WhipIT Developer Orientation
Status: Wave 1
WhipIT is a large, long-lived FileMaker ERP for exhibition and project businesses (~110 base tables, 1,100+ scripts in WhipIT 3.fmp12). This pack orients Simon and Claude Code for a ground-up rebuild — what exists, how it connects, and where the risk lives.
It documents the current system. It does not prescribe Simon's architecture, phasing, or stack choices.
api_integration application account (see API handover)| Artefact | Location | Role |
|---|---|---|
| API handover | ../migration/API_HANDOVER.md | Dev OData + Data API access |
| DDR XML | Dropbox Xzibit/DDRs/ | Authoritative schema + scripts |
| This pack | whipit-developer-orientation-pack/ | Indexed orientation |
| Whiplash scope | ../docs/WHIPLASH_PROJECT_INSTRUCTIONS.md | Sam's engagement boundaries |
| Tier | What | Who |
|---|---|---|
| Narrative | Chapters 1–10 (+ Ch3b) | Simon — concepts, couplings, risks |
| Registers + machine | registers/, machine/ | Claude — IDs, tables, scripts at scale |
Claude entry: CLAUDE.md
| File | Role |
|---|---|
| WhipIT 3 | Core ERP — jobs, quotes, time, messages, integrations |
| WhipITApp | Field/Go companion — time entry, pack lists, recent jobs (Ch3b) |
| WhipIT_Files | External container store — assets linked from WhipIT 3 (Ch2) |
Ch2 → Ch3 → registers/Table-Register.md → registers/Entity-Register.md → DDR XML
Use when: modelling data in a new database.
Ch4 → registers/Entity-Register.md (E08–E12) → ../migration/JOB_STAGE_PARITY_CHECKLIST.md → ../budgets/BUDGET_DOMAIN_MODEL_WHIPIT3.md
Use when: sales pipeline or labour budget logic.
Ch3b → Ch5 → PACKLIST scripts in registers/Script-Register.md
Use when: iOS/Go workflows or WhipITApp bridge.
Ch6 → Integration register (Wave 2) → DDR script groups ImportTick, TIMESHEET, export layouts
Use when: rewiring Xero, Zoho, ImportTick, etc.
CLAUDE.md → machine/WHIPIT3_SCRIPT_CATALOG.csv → register ID lookup → DDR for script steps
| Ch | Topic |
|---|---|
| 1 | This chapter — navigation |
| 2 | System landscape, hosting, three files |
| 3 | Domain model (entities ↔ tables) |
| 3b | WhipITApp companion (mini) |
| 4 | Jobs, quotes, budget rollup |
| 5 | Production — time, tasks, pack lists |
| 6 | Integrations and boundaries |
| 7 | People, auth, permissions |
| 8 | Reports and document outputs |
| 9 | Legacy, scaffolding, ignore list |
| 10 | Rebuild risks and parity traps |
| Appx | Registers |