Manca la env var MONDAY_TOKEN.

\"), {\n status: 200,\n headers: noCacheHeaders,\n });\n }\n\n const url = new URL(req.url);\n const confirm = url.searchParams.get(\"confirm\") === \"1\";\n\n try {\n const boardQuery = `\n query ($boardId: [ID!]) {\n boards(ids: $boardId) {\n columns { id title type }\n groups { id title }\n items_page(limit: 500) { items { id name } }\n }\n }`;\n const boardData = await callMonday(token, boardQuery, {\n boardId: [BOARD_ID],\n });\n const board = boardData.boards[0];\n\n const clienteCol = board.columns.find((c: any) =>\n c.title === CLIENTE_COLUMN_TITLE\n );\n if (!clienteCol) {\n return new Response(\n htmlPage(\n `

ERRORE: colonna \"${CLIENTE_COLUMN_TITLE}\" non trovata.

`,\n ),\n { status: 200, headers: noCacheHeaders },\n );\n }\n\n let plCol = board.columns.find((c: any) => c.title === PL_COLUMN_TITLE);\n if (!plCol && confirm) {\n const createColQuery = `\n mutation ($boardId: ID!, $title: String!) {\n create_column(board_id: $boardId, title: $title, column_type: text) { id title }\n }`;\n const created = await callMonday(token, createColQuery, {\n boardId: BOARD_ID,\n title: PL_COLUMN_TITLE,\n });\n plCol = created.create_column;\n }\n\n const group = board.groups.find((g: any) => g.title === GROUP_TITLE);\n if (!group) {\n return new Response(\n htmlPage(`

ERRORE: gruppo \"${GROUP_TITLE}\" non trovato.

`),\n { status: 200, headers: noCacheHeaders },\n );\n }\n\n const existingNames = new Set(\n board.items_page.items.map((i: any) => i.name),\n );\n const toCreate = DATA.filter((row) => !existingNames.has(row.work));\n const doneSoFar = DATA.length - toCreate.length;\n\n if (!confirm) {\n const body = `\n

Import commesse reali su Monday

Totale righe: ${DATA.length}. Già presenti: ${doneSoFar}. Da creare: ${toCreate.length}.

\n Avvia / continua caricamento`;\n return new Response(htmlPage(body), {\n status: 200,\n headers: noCacheHeaders,\n });\n }\n\n const batch = toCreate.slice(0, BATCH_SIZE);\n let created = 0;\n const failures: string[] = [];\n\n for (const row of batch) {\n const columnValues: Record = {\n [clienteCol.id]: row.cliente,\n };\n if (plCol) columnValues[plCol.id] = row.pl;\n try {\n const createItemQuery = `\n mutation ($boardId: ID!, $groupId: String, $itemName: String!, $columnValues: JSON) {\n create_item(board_id: $boardId, group_id: $groupId, item_name: $itemName, column_values: $columnValues) { id }\n }`;\n await callMonday(token, createItemQuery, {\n boardId: BOARD_ID,\n groupId: group.id,\n itemName: row.work,\n columnValues: JSON.stringify(columnValues),\n });\n created++;\n } catch (e) {\n failures.push(`${row.work} (${row.cliente}): ${e.message}`);\n }\n await sleep(100);\n }\n\n const newDoneSoFar = doneSoFar + created;\n const remaining = DATA.length - newDoneSoFar - failures.length;\n const percent = Math.round((newDoneSoFar / DATA.length) * 100);\n\n let body = `\n

Import commesse reali su Monday

Lotto completato: creati ${created} su ${batch.length} tentati.

Totale caricato finora: ${newDoneSoFar} di ${DATA.length} (${percent}%).

`;\n\n if (failures.length > 0) {\n body += `

Righe fallite in questo lotto:\\n${\n failures.join(\"\\n\")\n }

`;\n }\n\n if (remaining > 0 || failures.length > 0) {\n body +=\n `Continua con il prossimo lotto`;\n } else {\n body += `

Caricamento completato.

`;\n }\n\n return new Response(htmlPage(body), {\n status: 200,\n headers: noCacheHeaders,\n });\n } catch (e) {\n return new Response(htmlPage(`

ERRORE BLOCCANTE: ${e.message}

`), {\n status: 200,\n headers: noCacheHeaders,\n });\n }\n}","deleted","label",[115],"pulls",1,"forks","envVars",{"_137":131,"_139":54},"connections",{"_137":54,"_138":54},"count","unfilledCount","emptyCount",{"_20":114,"_13":115,"_116":48,"_117":-5,"_118":21,"_119":30,"_120":50,"_22":141,"_29":122,"_123":124,"_125":126,"_127":38,"_128":-5,"_142":143,"_91":144},["D",1788969886588],"children",[],[115],["D",1788962477426],{"_11":12,"_89":85},{"_11":12,"_82":83,"_84":85,"_45":46,"_86":87,"_88":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_77":-5,"_78":-5,"_79":-5,"_80":14,"_81":12},"ctx",{"_70":-5,"_110":182,"_183":184,"_185":186,"_187":38,"_188":38,"_189":38,"_190":50,"_191":-5,"_192":-7,"_193":-7,"_194":54,"_195":38,"_196":38,"_197":-5,"_198":38,"_199":38,"_200":38,"_201":-5},"ENV",{"_153":154,"_155":156,"_157":26,"_158":159,"_160":161,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Branches1

Branches
1