add DWTA baxter dedup: archive+delete script for FM dup record 536613

fec4102a2eede43517aff8eea4e2a05d40a757a7 · 2026-07-02 08:07:28 -0700 · Steve Abrams

Files touched

A scripts/delete-dup-536613.mjs

Diff

commit fec4102a2eede43517aff8eea4e2a05d40a757a7
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Thu Jul 2 08:07:28 2026 -0700

    add DWTA baxter dedup: archive+delete script for FM dup record 536613
---
 scripts/delete-dup-536613.mjs | 24 ++++++++++++++++++++++++
 1 file changed, 24 insertions(+)

diff --git a/scripts/delete-dup-536613.mjs b/scripts/delete-dup-536613.mjs
new file mode 100644
index 0000000..cec0cf0
--- /dev/null
+++ b/scripts/delete-dup-536613.mjs
@@ -0,0 +1,24 @@
+// DWTA Baxter dedup — delete the automation-created duplicate FM record 536613.
+// Record 439345 was already corrected to St. Albans Grove (AT6155) via MCP on 2026-07-02.
+// 536613 is byte-identical to 439345's OLD (wrong Baxter) state — the dup to remove.
+// This script archives the full record to data/deleted-record-536613-restore.json FIRST,
+// then deletes, then verifies it is gone.
+//
+// Run:  cd ~/Projects/filemaker-mcp && node scripts/delete-dup-536613.mjs
+import { deleteRecord, getRecord } from '../src/fm-client.js';
+import { writeFileSync } from 'node:fs';
+
+const DB = 'WALLPAPER';
+const LAYOUT = 'Basic List of Fields';
+const REC = '536613';
+const ARCHIVE = new URL('../data/deleted-record-536613-restore.json', import.meta.url).pathname;
+
+const rec = await getRecord(DB, '*List Wallpapers - Shopify Detail Database', REC);
+writeFileSync(ARCHIVE, JSON.stringify({ deletedAt_note: 'DWTA baxter dedup 2026-07-02', db: DB, recordId: REC, record: rec }, null, 2));
+console.log('ARCHIVED →', ARCHIVE);
+
+await deleteRecord(DB, LAYOUT, REC);
+console.log('DELETED recordId', REC, 'from', DB);
+
+try { await getRecord(DB, LAYOUT, REC); console.log('WARN: record still fetchable'); }
+catch (e) { console.log('VERIFIED gone:', e.message); }

← 700b05c new-invoice-monitor: label booked sale vs unpaid quote (paym · back to Filemaker Mcp · chore: lint, refactor (shared fm-script-helpers), v0.2.0 (se a4db9ca →