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}","label",[18],"pulls","branches","forks","envVars",{"_203":45,"_205":26},"connections",{"_203":26,"_204":26},"count","unfilledCount","emptyCount",{"_38":188,"_13":18,"_66":67,"_48":-5,"_40":41,"_189":112,"_190":130,"_42":207,"_44":105,"_68":88,"_192":193,"_70":24,"_194":-5,"_208":209,"_17":210},["D",1788969886588],"children",[],[18],["D",1788962477426],{"_11":12,"_166":73},{"_11":12,"_161":162,"_72":73,"_30":71,"_163":164,"_165":24},{"_44":112,"_13":16,"_38":41,"_153":118,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":-5,"_159":14,"_160":12},"ctx",{"_56":-5,"_185":248,"_249":250,"_251":252,"_253":24,"_254":24,"_255":24,"_256":130,"_257":-5,"_258":-7,"_259":-7,"_260":26,"_261":24,"_262":24,"_263":-5,"_264":24,"_265":24,"_266":24,"_267":-5},"ENV",{"_219":220,"_221":222,"_223":16,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247},"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"]

History · main.ts