Files

OC-5070 ece3222d3a Add AD1 session data, memory entries for datasheet pipeline and security incident

- Imported AD1 Claude session files to clients/dataforth/session-logs/
- Created memory: project_datasheet_pipeline.md (full pipeline architecture)
- Created memory: project_dataforth_incident_2026-03-27.md (security incident + MFA)
- Updated MEMORY.md index
- Updated session log with AD1 pipeline rebuild findings

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>

2026-03-27 20:07:20 -07:00

2.7 KiB

Raw Permalink Blame History

Claude Session Summary — 2026-03-27

Objective

Reconstruct the Dataforth test datasheet pipeline after AD2 crypto wipe. Unblock customer shipment (Quatronix/China, 73 datasheets needed urgently).

Key Accomplishments

Pipeline Analysis

Mapped complete 5-stage pipeline: DOS test stations → NAS → AD2 sync → DFWDS → website
Identified CTONWTXT.BAT gap (TXT files stuck on DOS machines since Sept 2025)
Confirmed DFWDS.exe config lost in wipe, old website upload endpoints dead (404)
Found production config + VB6 source on ENGR share

New Pipeline Built (C:\Shares\testdatadb)

Spec Parser (parsers/spec-reader.js): Reads 8 binary spec DAT files, 1470 models
Exact-Match Formatter (templates/datasheet-exact.js): Reverse-engineered from QuickBASIC source
Export System (database/export-datasheets.js): Auto-generates TXT to X:\For_Web after import
PDF On-Demand (routes/api.js): /api/datasheet/:id/pdf endpoint
UI Improvements: ALL filter, auto-search, PDF download button, export status display

Data Reconciliation

1,436,007 DB records matched to existing For_Web files and marked as exported
500,419 pre-2026 files archived into year subfolders (X:\For_Web\2013, etc.)
Added forweb_exported_at and datasheet_exported_at tracking columns

Customer Issue Resolved

Generated 72 of 73 requested datasheets (TXT + PDF) for Quatronix
Located on Desktop\Quatronix-Datasheets\
1 remaining (177000-15, SCM5B49-05) needs empty spec file from John

Infrastructure Fixes

Opened firewall on HGHAUBNER for SMB access
Fixed TestDataDB search defaulting to today's date
Identified testdatadb Windows service permission issues (SYSTEM vs sysadmin)

Files Created/Modified

See project_pipeline_rebuilt.md for full list.

Open Items

Website upload replacement (old ASP.NET endpoints dead)
7B datasheet formatting (specs loaded, formatter needs 7B-specific layout)
SCM5B49 spec file empty — need from John
MAQ20/PWRM10 integration (XLS format, different pipeline)
10D integration (JSON format, ~2 months out)
Service permissions cleanup (runs as SYSTEM)
Serial numbering standards discussion with John

Key Contacts

John Lehman (jlehman@dataforth.com) — Engineering, QB code, specs
Peter Iliya (pIliya@dataforth.com) — Applications Engineer, manual datasheet retrieval
Ken Hoffman — TestDataSheetUploader author (VB.NET)
Ginger (gy@quatronix-cn.com) — Quatronix China, customer requesting datasheets

Key Paths

Test DB app: C:\Shares\testdatadb\
Spec data: C:\Shares\testdatadb\specdata\
For_Web: X:\For_Web\ (\ad2\webshare)
ENGR share: \AD1\Engineering\ENGR\ATE\
NAS: 192.168.0.9 (D2TESTNAS, rsync daemon port 873)
Sync script: C:\Shares\test\scripts\Sync-FromNAS-rsync.ps1

2.7 KiB Raw Permalink Blame History