Ask Daniel's CODEX · index

Grok Build Handoff — Codey Gate 2 Complete

Grok Build Handoff — Codey Gate 2 Complete

→ Syd + Publish

IN Lattice · Intelligent Netware · MA5 Council

FieldValue
Written2026-06-19 (afternoon — Codey session complete)
Carbon StewardDaniel Comp
Primary build partnerGrok Build (D:\04_WORK\Code\Lattice\_ChatUI)
Prior handoffsGrok_Handoff_SynNA_20260619_SessionEnd.md · Grok_Handoff_SynNA_PhaseGrid.md · Grok_Handoff_SynNA_Gate2_Codey.md
StatusCodey Gate 2 feature-complete for the-makers-exodus · Daniel final proof → Syd Gate 3SFTP + SQL publish

New thread opener (read this first)

  1. This file — what Codey shipped, what to verify, ordered next steps
  2. handoffs/Grok_Handoff_SynNA_PhaseGrid.md — master grid Phases 3–8 (Syd, SQL, SFTP, dashboard)
  3. Active packet: D:\03_MAP\Syn_Pipeline\the-makers-exodus\

Lattice UI: http://127.0.0.1:8780python app.py from _ChatUI

Backup convention: python backup.py before edits


Executive summary

Codey Gate 2 is done for this article cycle. The pipeline now supports fractome switching, composition inserts from plain language, Template7 bottom sections with live tokens, and a trustworthy Gate 2 preview tab.

Daniel is correct about the next macro phase: publish is SFTP images to the Windows remote webserver, then SQL insert into DNN (Ventrian NewsArticles). That maps to Phase Grid 5–6 — but Syd proof (Phase 4) and one assemble backtrack should happen first.

Codey is parked. Next build partner focus: Syd (metadata proof form), then syn_publish.py (SFTP), then syn_sql_build.py (SSMS-ready insert).


Active packet — `the-makers-exodus`

FieldValue
PathD:\03_MAP\Syn_Pipeline\the-makers-exodus\
Stateassembled
Fractomescotomaville → template standard
NA reserved239 (syn_config.yaml publish.next_na_id)
Last assemble2026-06-19T21:06:33+00:00
Composition insertblockquote-primary in The Elixir You Are Required to Transmit

Preview: http://127.0.0.1:8780/api/pipeline/the-makers-exodus/preview Or Codey preview button → tab syn-gate2-preview

Key artifacts:

FileRole
article.mdArnie prose + SUMMARY + SYN_PIPELINE
assembled.htmlSyndication body — remote banner/divider URLs + Template7 bottom
preview.htmlGate 2 Tahoe preview (local API image paths)
status.yamlState, images, composition.inserts[], assemble metadata
inline/image-1.jpgAirstream proof image (Movement 1)

What Codey shipped (this session — do not

regress)

Apply-to-packet (composition inserts)

Preview reliability

Template7 bottom sections (assets/_Template7_Bottom_Sections_v1.html)

BlockBehavior
AI Sherpa linkshttps://initium.scotomaville.com/{{SLUG}}_grok (claude, chatgpt, perplexity, gemini) — infilled at assemble
Syndication iconsyn-us?na={na_id} from publish.next_na_id
Full-bleed divider{{FULL_BLEED_IMAGE}} — remote in assembled.html, local API in preview
INITIUM download rowcol-md-7 + col-md-4 (Lattice Template1 pattern — 8+4 wrapped in preview)
TEXT DANIEL CTAhref="sms:+12105574779"

Assemble core (unchanged ratified rules)


Daniel — Gate 2 final proof checklist

Hard-refresh syn-gate2-preview (Ctrl+Shift+R) before sign-off:

Layout

Content & links

Publish artifact sanity

Sign-off phrase: "Gate 2 approved for Syd" (or note defects + reassemble command below)

``powershell cd D:\04_WORK\Code\Lattice\_ChatUI\.Scripts python syn_pipeline.py --assemble the-makers-exodus ``


Backtrack / double-check before publish

These are not Codey polish items — they block or risk a bad first live publish.

| Issue | Severity | Action |

1assembled.html inline image uses local preview URL (127.0.0.1:8780/api/pipeline/…/inline/image-1.jpg)BLOCKERFix syn_assemble.py: assembled body must emit remote image_url_base path for inline/*.jpg; preview keeps local API. SFTP inline/image-1.jpg to remote folder.
2templates/syd/_references_li.html missingHighPhase 3C — extract REFERENCES block from Template7/assets; wire build_references_html()
3syd agent not in agent_order.jsonHighPhase 4A — add after codey
4syn_sql_build.py does not existHighPhase 5C — scaffold from D:\04_WORK\Code\Garwis\Arnie_DB_Insert_v2.sql
5syn_publish.py does not existHighPhase 6A — paramiko SFTP; fill syn_config.publish host/user/paths
6SFTP config empty (sftp_host, sftp_user, remote_image_folder, public_base_url)HighDaniel fills at 3.1 onboarding
7next_na_id: 239 vs live DNN autoincrementMediumConfirm next Ventrian ArticleID before SQL; bump config after publish
8Categories / badge from Forrest briefMediumSyd proof form must surface or default for the-makers-exodus
9Master + candidate JPGsLowNot referenced in assembled.html; optional archive cleanup

Publish pipeline order (Daniel's mental model — confirmed)

You were right: images on the server first, then database row that references those URLs.

`` Gate 2 proof (Daniel) → Syd proof tab (metadata last-chance edit) → Approve for SQL → syn_sql_build.py → {slug}_insert.sql (state: sql_ready) → syn_publish.py → SFTP all image files ← BEFORE commit → HTTPS verify → HEAD 200 + Content-Length match per file → SSMS → run insert.sql, COMMIT → state: published → bump next_na_id, archive to published_root ``

SFTP file list for the-makers-exodus (minimum):

FileDNN SortOrder / role
the-makers-exodus_200.jpgthumb (0)
the-makers-exodus_1920x420.jpgbanner desktop (1)
the-makers-exodus_768x420.jpgtablet (2)
the-makers-exodus_480x420.jpgmobile (3)
the-makers-exodus_1920x960.jpgbody divider
inline/image-1.jpginline prose image (after assemble fix §1)

Remote folder (confirm pre-flight): images/articles/danielcomp/ per Arnie_DB_Insert_v2.sql


Step-by-step task list (next sessions)

Phase A — Daniel human gate (no code)

StepTaskDone when
A.1Run Gate 2 proof checklist aboveAll boxes checked or defects logged
A.2Open assembled.html in browser (or DNN test module)Section gaps + blockquote survive upload
A.3Sign off: "Gate 2 approved for Syd"Recorded in thread or handoff note

Phase B — Assemble backtrack (Grok — before

SFTP)

StepTaskTouchpointsDone when
B.1Remote URL for inline images in assembled.html onlysyn_assemble.py _inline_image_url()assembled.html has syn.scotomaville.com/… inline src
B.2Reassemble + verify preview still local--assemble the-makers-exodusPreview OK; assembled remote
B.3Extract references <li> templatetemplates/syd/_references_li.html{{NA_ID}} renders

Phase C — Syd Gate 3 (Grok —

Phase Grid 4)

StepTaskTouchpointsDone when
C.1Add syd to sidebar + agent_order.jsonindex.htmlGate 3 card fas fa-rss
C.2Proof tab syn-syd-proofmirror Gate 2 tab patternSingle tab, no sprawl
C.3Legacy NA proof formtitle, summary, body view, images row, cats, badge, refs, dates, STATUS
C.4GET/PATCH /api/pipeline/{slug}/na-recordapp.py, status.yaml na_record:Edits persist
C.5State assembledproof_draft on first openAPIstatus.yaml updates
C.6Daniel fills proof for the-makers-exodusUIApprove for SQL ready

Phase D — SQL build (Grok — Phase

Grid 5)

StepTaskTouchpointsDone when
D.1Implement syn_sql_build.pyfill Arnie_DB_Insert_v2.sql placeholders{slug}_insert.sql in packet
D.2Byte sizes from status.imagesstatus.yamlSQL DECLARE sizes match files
D.3N'…' escaping for title/summary/bodytest fixture--test-sql-build passes
D.4State → sql_readywatcher/APIDaniel reviews in SSMS

Phase E — SFTP + live publish (Grok

+ Daniel — Phase Grid 6)

StepTaskTouchpointsDone when
E.1Fill syn_config.publish SFTP fieldssyn_config.yamlhost, user, remote folder, public_base_url
E.2Implement syn_publish.py (paramiko)new scriptuploads § file list
E.3HTTPS HEAD verify per imagepublish script200 + Content-Length match
E.4Daniel runs SSMS insert{slug}_insert.sqlArticle live on fractome
E.5Bump next_na_id to 240syn_config.yamlSynced with DNN
E.6Archive packet → published_rootwatcherD:/06_STORE/SERVER/Syndicated/the-makers-exodus/

Phase F — Post-publish (deferred)

StepTaskWhen
F.1Codex KB ingest on publishedPhase 7
F.2Lattice dashboard for in-flight packetsPhase 8

Division of labor (unchanged)

AgentOwns
ArnieProse, SUMMARY, SYN_PIPELINE; inline images in article.md
PicassoGate 1 imagery
CodeyFractome, template, composition inserts, Template7 bottom — complete
DanielGate 2 proof; token review; SSMS commit; publish sign-off
SydNA record proof; approve for SQL
Assembleassembled.html + preview.html structure

Key files (Codey session)

PathRole
.Scripts/syn_assemble.pyBody merge, Template7 infill, {{SLUG}}, composition inserts, preview CSS
.Scripts/syn_config.yamlnext_na_id: 239, publish SFTP stubs, bottom_sections_file
assets/_Template7_Bottom_Sections_v1.htmlAI links, INITIUM, SMS CTA
app.pyCodey apply bridge, composition API, session packet_slug, prompts
index.htmlSlug detection, preview tab, Gate 2 wiring
profiles/codey/learned_composition.mdTEACH lessons (blockquote-primary, spacing, etc.)

Verification commands

``powershell cd D:\04_WORK\Code\Lattice\_ChatUI\.Scripts python syn_pipeline.py --test-assemble python syn_pipeline.py --assemble the-makers-exodus ``

```powershell

After inline-URL fix (Phase B.1) — confirm assembled

has NO 127.0.0.1 Select-String -Path "D:\03_MAP\Syn_Pipeline\the-makers-exodus\assembled.html" -Pattern "127.0.0.1"

Should return nothing

```

```powershell cd D:\04_WORK\Code\Lattice\_ChatUI python app.py

→ http://127.0.0.1:8780

```


Context seed (paste at next session start)

Codey Gate 2 is complete for the-makers-exodus. Packet is assembled with blockquote insert, Template7 bottom ({{SLUG}} AI links, na=239, SMS CTA, INITIUM col-md-7+4). Fix inline image remote URL in assembled.html before publish. Next: Daniel Gate 2 sign-off → build Syd proof tab (Phase 4) → syn_sql_build → syn_publish SFTP → SSMS. Read handoffs/Grok_Handoff_SynNA_CodeyComplete_20260619.md and Phase Grid Phases 4–6.


Written by Grok Build · 2026-06-19 · Codey parked · Syd + SFTP + SQL next

Ask Daniel's CODEX