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",[109],"pulls","branches",1,"forks","envVars",{"_132":126,"_134":42},"connections",{"_132":42,"_133":42},"count","unfilledCount","emptyCount",{"_18":108,"_20":109,"_110":36,"_111":-5,"_112":68,"_113":66,"_114":38,"_22":136,"_65":116,"_117":118,"_119":120,"_121":26,"_122":-5,"_137":138,"_86":139},["D",1788969886588],"children",[],[109],["D",1788962477426],{"_16":17,"_84":80},{"_16":17,"_77":78,"_79":80,"_33":34,"_81":82,"_83":26},{"_65":66,"_20":67,"_18":68,"_69":19,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":21,"_76":17},"ctx",{"_58":-5,"_104":177,"_178":179,"_180":181,"_182":26,"_183":26,"_184":26,"_185":38,"_186":-5,"_187":-7,"_188":-7,"_189":42,"_190":26,"_191":26,"_192":-5,"_193":26,"_194":26,"_195":26,"_196":-5},"ENV",{"_148":149,"_150":151,"_152":67,"_153":154,"_155":156,"_157":158,"_159":160,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176},"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"]

Search