[object Object]

← back to Filemaker Mcp

auto-save: 2026-07-12T08:47:12 (2 files) — scripts/bulk-series-dwgl-to-dwlg.mjs scripts/bulk-series-dwlg-to-cork.mjs

c542aa6e19f3182a82a5fd1b97c9139daca40a1f · 2026-07-12 08:47:18 -0700 · Steve Abrams

Files touched

Diff

commit c542aa6e19f3182a82a5fd1b97c9139daca40a1f
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Sun Jul 12 08:47:18 2026 -0700

    auto-save: 2026-07-12T08:47:12 (2 files) — scripts/bulk-series-dwgl-to-dwlg.mjs scripts/bulk-series-dwlg-to-cork.mjs
---
 scripts/bulk-series-dwgl-to-dwlg.mjs | 11 +++++++++++
 scripts/bulk-series-dwlg-to-cork.mjs | 11 +++++++++++
 2 files changed, 22 insertions(+)

diff --git a/scripts/bulk-series-dwgl-to-dwlg.mjs b/scripts/bulk-series-dwgl-to-dwlg.mjs
new file mode 100644
index 0000000..1a29543
--- /dev/null
+++ b/scripts/bulk-series-dwgl-to-dwlg.mjs
@@ -0,0 +1,11 @@
+import * as fm from '../src/fm-client.js';
+const ENTRY='Add wallcovering', FULL='*List Wallpapers - Full View';
+const sleep=ms=>new Promise(r=>setTimeout(r,ms));
+let ok=0,fail=0;
+for(let pass=0;pass<20;pass++){
+  const r=await fm.findRecords('WALLPAPER',FULL,{Series:'==DWGL',vid:'GREEN'},{limit:100}).catch(()=>({records:[]}));
+  const recs=r.records||[]; if(!recs.length) break;
+  console.log(`pass ${pass+1}: ${recs.length} DWGL records`);
+  for(const rec of recs){ try{ await fm.updateRecord('WALLPAPER',ENTRY,rec.recordId,{Series:'DWLG'},{dryRun:false}); ok++; if(ok%25===0)console.log(`  ...${ok}`); await sleep(90);}catch(e){fail++;console.error(`  FAIL ${rec.recordId}: ${e.fmCode||e.message}`);await sleep(250);} }
+}
+console.log(`\nDONE. updated=${ok} fail=${fail}`);
diff --git a/scripts/bulk-series-dwlg-to-cork.mjs b/scripts/bulk-series-dwlg-to-cork.mjs
new file mode 100644
index 0000000..ab04001
--- /dev/null
+++ b/scripts/bulk-series-dwlg-to-cork.mjs
@@ -0,0 +1,11 @@
+import * as fm from '../src/fm-client.js';
+const ENTRY='Add wallcovering', FULL='*List Wallpapers - Full View';
+const sleep=ms=>new Promise(r=>setTimeout(r,ms));
+let ok=0,fail=0;
+for(let pass=0;pass<20;pass++){
+  const r=await fm.findRecords('WALLPAPER',FULL,{Series:'==DWLG',vid:'GREEN'},{limit:100}).catch(()=>({records:[]}));
+  const recs=r.records||[]; if(!recs.length) break;
+  console.log(`pass ${pass+1}: ${recs.length} DWLG records`);
+  for(const rec of recs){ try{ await fm.updateRecord('WALLPAPER',ENTRY,rec.recordId,{Series:'Cork'},{dryRun:false}); ok++; if(ok%25===0)console.log(`  ...${ok}`); await sleep(90);}catch(e){fail++;console.error(`  FAIL ${rec.recordId}: ${e.fmCode||e.message}`);await sleep(250);} }
+}
+console.log(`\nDONE. updated=${ok} fail=${fail}`);

← c23bb05 auto-save: 2026-07-12T08:17:05 (1 files) — scripts/bulk-set-  ·  back to Filemaker Mcp  ·  auto-save: 2026-07-12T19:19:48 (1 files) — scripts/bulk-crea 9f680a3 →