claudetools/Test Datasheets/weekend-update-draft.md

Subject: Test Datasheets - Weekend Update: All 73 Quatronix Sheets Generated, Work Order Search Live

John, Ken,

Quick update on progress since Friday's email. The pipeline is significantly further along.

Quatronix Customer Issue - RESOLVED

All 73 requested datasheets have been generated (TXT + PDF). The last holdout was SCM5B49-05 (SN 177000-15) — the 5B49DATA.DAT spec file was empty, but John pointed us to 5B49_2.DAT which had the data. All 73 files are ready to send to Peter/Ginger.

Model Spec Coverage Expanded

We went from 751 model specs to 1,470+ by loading additional spec databases:

Spec File	Family	Models
5BMAIN.DAT	SCM5B	481
5B45DATA.DAT	SCM5B (freq/counter)	56
DB5B48.DAT	SCM5B (multi-bandwidth)	3
5B49_2.DAT	SCM5B (sample & hold)	15
8BMAIN.DAT	8B	148
DSCOUT.DAT	DSCA (output)	23
DSCMAIN4.DAT	DSCA (input)	391
SCTMAIN.DAT	DSCT	103
7BMAIN.DAT	SCM7B	276

If there are additional spec files we're missing, let me know the paths and we'll add them.

SCM7B Support Added

The 7B product family is now fully supported in the datasheet generator:

• 31 test parameters (vs 20 for SCM5B)
• Correct header ("SCM" prefix prepended to model name)
• 120VAC Withstand / Hi-Pot (skipped for 7BPT models)
• "Packing Check List" with blank fields (vs pre-marked checkboxes on 5B/8B)
• "Tested by" and "QC" signature lines
• Note: The 7B DAT format (single CSV line) doesn't include individual accuracy test points, so the accuracy table is omitted. Only the Final Test Results section is generated from DAT data.

Work Order Search & Linking

Imported all 33,745 work order status reports from the test station Reports folders:

• 63,263 individual test lines parsed (serial number, model, pass/fail, date/time, station)
• 2.27 million test records linked to their work orders

In the web app (http://192.168.0.6:3000):

• New "Work Order #" search field — enter a WO number to find all associated test records
• Click the WO number in any record's detail view to see the full work order:
  • All serial numbers tested under that WO
  • Pass/fail status for each (including retests)
  • Test program and version used
  • Test station and timestamps
• New work order reports are automatically imported when synced from the NAS

Datasheet Formatting Refined

Compared generated datasheets against originals from the DFWDS archive and fixed column alignment to match the QuickBASIC output:

• TAB positions match exactly (parameter names, measured values, spec limits, pass/fail)
• Number formatting matches QB PRINT USING (right-justified, correct decimal places)
• STR$() behavior replicated (leading space for positive numbers, dropped leading zeros)
• Spec limit formatting matches (e.g., "+/- .03 %" not "+/- 0.03 %")

View Button Updated

The "SHEET" button in the web app now shows a styled HTML page that matches the PDF/TXT layout — white page, monospace font, same column alignment. Includes Print and Download PDF buttons.

Infrastructure

• Created domain service account (INTRANET\svc_testdatadb) for the TestDataDB Windows service — resolves the file permission issues we were hitting
• Added STAGE folder sync to the NAS sync script — TXT datasheets from DOS machines will now be pulled to AD2 automatically
• Work order report import added to sync script — new reports are ingested automatically every 15 minutes

Still Open

1. Website upload — The old Uploader.aspx endpoints are dead. Need to determine the new upload mechanism for dataforth.com.
2. STAGE backlog — ~8,100 TXT files on the NAS from DOS machines need to be processed (script ready, haven't run it yet).
3. Pending ForWeb export — ~845K records in the database don't have TXT files in For_Web yet (mostly 7B and older records). Can batch-export as needed.

Let me know if you need anything else.

Mike