[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_102":103,"_104":105},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","giuseppelongo","name","Carica-file-excel","path","main.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":25,"_58":32,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/giuseppelongo/Carica-file-excel/code/main.ts","extension","id","62c15adc-13b4-4526-8e2b-8be66eaecb0a","fileId","ed5e6d5a-ac56-11f1-9e36-1607ee4eb77e","parentId","branchId","b148589e-01f8-48de-8abe-7ef6d293b317","branchVersion",7,"latest",true,"createdAt",["D",1788969886588],"version",6,"fileType","http","content","/**\n * Val Town HTTP val — importa le commesse reali (185 righe) sulla scheda\n * \"Elenco Commesse\" (board id 5103849226), nel gruppo \"Commesse Attive\".\n *\n * METODO SEMPLICE, nessun JavaScript lato client: ogni visita alla pagina\n * crea un lotto di righe (BATCH_SIZE) e mostra un link \"Continua\" da\n * cliccare per il lotto successivo. Nessun file esterno, nessuna cache\n * di mezzo, nessuna dipendenza da script che gira nel browser.\n *\n * USO:\n * GET / → dry run, mostra quante righe mancano\n * GET /?confirm=1 → crea un lotto, poi mostra un link per continuare\n *\n * Richiede la env var MONDAY_TOKEN.\n *\n * Nota: Stato generale, Budget ore e Date commessa NON vengono valorizzati\n * perché il file originale non li contiene — restano da compilare a mano.\n */\n\nconst API_URL = \"https://api.monday.com/v2\";\nconst BOARD_ID = \"5103849226\";\nconst GROUP_TITLE = \"Commesse Attive\";\nconst CLIENTE_COLUMN_TITLE = \"Cliente\";\nconst PL_COLUMN_TITLE = \"PL (da assegnare)\";\nconst BATCH_SIZE = 15;\n\ninterface Row {\n work: string;\n cliente: string;\n pl: string;\n}\n\nconst DATA: Row[] = [\n {\n \"work\": \"T_26/210\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/208\",\n \"cliente\": \"AMARC02\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/207\",\n \"cliente\": \"SO.GE.RI\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/203\",\n \"cliente\": \"TEA SB\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/205\",\n \"cliente\": \"IDEA_MILANO\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/206\",\n \"cliente\": \"SITE\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/046.05\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/033.27\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/033.28\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/200\",\n \"cliente\": \"ISOIL\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/201\",\n \"cliente\": \"COMUNE DI SPIGNO MONFERRATO\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/197\",\n \"cliente\": \"ASCANI\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/192\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/033.24\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/184.03\",\n \"cliente\": \"UNARETI BS\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/191\",\n \"cliente\": \"SICAM\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/190\",\n \"cliente\": \"FERROVIENORD\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/188\",\n \"cliente\": \"AMAGA\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/187\",\n \"cliente\": \"GEOMAR\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_24/212.03\",\n \"cliente\": \"CIIP\",\n \"pl\": \"LEONARDUZZI\",\n },\n {\n \"work\": \"T_25/_01.01\",\n \"cliente\": \"ALFA01\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/183\",\n \"cliente\": \"COGEN\",\n \"pl\": \"BASILICO\",\n },\n {\n \"work\": \"T_26/180\",\n \"cliente\": \"SEI\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/177\",\n \"cliente\": \"SIEL\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/172\",\n \"cliente\": \"ALPI ACQUE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/174\",\n \"cliente\": \"IDEA_MILANO\",\n \"pl\": \"CESANI\",\n },\n {\n \"work\": \"T_26/175\",\n \"cliente\": \"AP RETI01\",\n \"pl\": \"CINQUEGRANA\",\n },\n {\n \"work\": \"T_26/033.22\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/170\",\n \"cliente\": \"BACINI-PIACENTINI_03\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/171\",\n \"cliente\": \"SORICAL\",\n \"pl\": \"FUJANI\",\n },\n {\n \"work\": \"T_24/333.02\",\n \"cliente\": \"UNARETI BS\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/162\",\n \"cliente\": \"COMUNI RIUNITI BM\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/164\",\n \"cliente\": \"ALPI ACQUE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/165\",\n \"cliente\": \"ACQUA PUBBLICA SABINA01\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/166\",\n \"cliente\": \"ACQUA PUBBLICA SABINA01\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/158\",\n \"cliente\": \"CAP_HOLDING01\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/153\",\n \"cliente\": \"AIR LIQUIDE\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/156\",\n \"cliente\": \"LAZZARINI\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/157\",\n \"cliente\": \"A.QUANTUM\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/135.02\",\n \"cliente\": \"ACEA02\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/135.03\",\n \"cliente\": \"ACEA02\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_25/200.01\",\n \"cliente\": \"ETRA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/139\",\n \"cliente\": \"AKRASUN\",\n \"pl\": \"CONTE\",\n },\n {\n \"work\": \"T_26/143\",\n \"cliente\": \"ALMACIS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/146\",\n \"cliente\": \"ECODEPURA\",\n \"pl\": \"BASILICO\",\n },\n {\n \"work\": \"T_26/147\",\n \"cliente\": \"GESTIONE ACQUA\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/137\",\n \"cliente\": \"AKRASUN\",\n \"pl\": \"CONTE\",\n },\n {\n \"work\": \"T_26/134\",\n \"cliente\": \"COMO ACQUA02\",\n \"pl\": \"MAZZUCCHI\",\n },\n {\n \"work\": \"T_26/135\",\n \"cliente\": \"ACEA02\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_25/322.01\",\n \"cliente\": \"RUZZO RETI\",\n \"pl\": \"FIERRO\",\n },\n {\n \"work\": \"T_26/124\",\n \"cliente\": \"GIOVANNI MALINCONICO\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/125\",\n \"cliente\": \"CAFC\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/121\",\n \"cliente\": \"EDC ELETTROSISTEM\",\n \"pl\": \"PASSA\",\n },\n {\n \"work\": \"T_26/114\",\n \"cliente\": \"LAZZARINI\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/115\",\n \"cliente\": \"ALMACIS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/108\",\n \"cliente\": \"HERA-TECH_SRL\",\n \"pl\": \"RAUCCI\",\n },\n {\n \"work\": \"T_26/109\",\n \"cliente\": \"R-ACQUE-01\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/111\",\n \"cliente\": \"TEA SB\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/105\",\n \"cliente\": \"TAMAI E MINETTO_01\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/099\",\n \"cliente\": \"ALPI ACQUE\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_25/046.03\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/046.04\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/033.05\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.06\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.07\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.08\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.09\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.10\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/033.11\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/087\",\n \"cliente\": \"TALETE\",\n \"pl\": \"CIARLO\",\n },\n {\n \"work\": \"T_26/088\",\n \"cliente\": \"ELETTROPIU01\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/090\",\n \"cliente\": \"F.LLI SALA\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/093\",\n \"cliente\": \"AMAGA\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/096\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"RAUCCI\",\n },\n {\n \"work\": \"T_26/076\",\n \"cliente\": \"ACEGAS-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/077\",\n \"cliente\": \"ACEGAS-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/069\",\n \"cliente\": \"TEAPER\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/064\",\n \"cliente\": \"BECCACECI\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/066\",\n \"cliente\": \"RUZZO RETI\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_26/061\",\n \"cliente\": \"SMAT\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/063\",\n \"cliente\": \"LARIO\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/053\",\n \"cliente\": \"R-ACQUE-01\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_26/054\",\n \"cliente\": \"AIR LIQUIDE02\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_26/046\",\n \"cliente\": \"EUROCONDOTTE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/043\",\n \"cliente\": \"AQA\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/033\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/034\",\n \"cliente\": \"MARCHE MULTISERVIZI\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/035\",\n \"cliente\": \"INRETESPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_26/036\",\n \"cliente\": \"AIMAG\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_26/032\",\n \"cliente\": \"ACQUE BRESCIANE\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/024\",\n \"cliente\": \"SO.GE.RI\",\n \"pl\": \"FIERRO\",\n },\n {\n \"work\": \"T_26/011\",\n \"cliente\": \"CAP_HOLDING01\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_26/012\",\n \"cliente\": \"SMAT\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_26/016\",\n \"cliente\": \"EDC ELETTROSISTEM\",\n \"pl\": \"CIARLO\",\n },\n {\n \"work\": \"T_26/010\",\n \"cliente\": \"ACEGAS-SPA\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_26/009\",\n \"cliente\": \"GRAN SASSO\",\n \"pl\": \"FIERRO\",\n },\n {\n \"work\": \"2023/001\",\n \"cliente\": \"REGIONE MOLISE\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"2023/142.02\",\n \"cliente\": \"OPUS\",\n \"pl\": \"FUJANI\",\n },\n {\n \"work\": \"T_25/397\",\n \"cliente\": \"CABRINI ALBINO\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_25/395\",\n \"cliente\": \"LTA\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_24/212\",\n \"cliente\": \"CIIP\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/010\",\n \"cliente\": \"CONSTRAT\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_25/385\",\n \"cliente\": \"R.G.A.\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/142.01\",\n \"cliente\": \"OPUS\",\n \"pl\": \"FUJANI\",\n },\n {\n \"work\": \"T_25/297\",\n \"cliente\": \"CIIP\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/318\",\n \"cliente\": \"GRIM\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/367\",\n \"cliente\": \"GRAN SASSO\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_24/252\",\n \"cliente\": \"CEBAT\",\n \"pl\": \"FUJANI\",\n },\n {\n \"work\": \"T_25/340\",\n \"cliente\": \"V-RETI\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_25/322\",\n \"cliente\": \"RUZZO RETI\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/213\",\n \"cliente\": \"NEVERHACK\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/305\",\n \"cliente\": \"SMAT\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_25/300\",\n \"cliente\": \"AP RETI02\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/079\",\n \"cliente\": \"GEOMAR\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/267\",\n \"cliente\": \"GESTIONE ACQUA\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_25/230\",\n \"cliente\": \"RIVIERACQUA\",\n \"pl\": \"FIERRO\",\n },\n {\n \"work\": \"T_25/226\",\n \"cliente\": \"AMAG\",\n \"pl\": \"FIERRO\",\n },\n {\n \"work\": \"T_25/223\",\n \"cliente\": \"ACDA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"2023/388\",\n \"cliente\": \"ACDA\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/323\",\n \"cliente\": \"ACQUE BRESCIANE\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"2023/514\",\n \"cliente\": \"SICILIACQUE01\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/046\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_25/191\",\n \"cliente\": \"GRAN SASSO\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/184\",\n \"cliente\": \"MM\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/180\",\n \"cliente\": \"BRIANZACQUE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/155\",\n \"cliente\": \"ACINQUE TECNOLOGIE\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_25/130\",\n \"cliente\": \"ATS\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_25/098\",\n \"cliente\": \"F.LLI SALA\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/097\",\n \"cliente\": \"AMAMBIENTE\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"2022/171\",\n \"cliente\": \"TENNACOLA\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_25/066\",\n \"cliente\": \"LERETI\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/047\",\n \"cliente\": \"IDEA_MILANO\",\n \"pl\": \"CORTELLINO\",\n },\n {\n \"work\": \"2022/018\",\n \"cliente\": \"A2A-BRESCIA_04\",\n \"pl\": \"CESANI\",\n },\n {\n \"work\": \"2024/103\",\n \"cliente\": \"CAP_HOLDING01\",\n \"pl\": \"DODA\",\n },\n {\n \"work\": \"T_25/030\",\n \"cliente\": \"ALFA01\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/014\",\n \"cliente\": \"ACQUE BRESCIANE\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_25/_03\",\n \"cliente\": \"COMO ACQUA02\",\n \"pl\": \"BARROTTA M\",\n },\n {\n \"work\": \"T_24/190\",\n \"cliente\": \"BECCACECI\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/467\",\n \"cliente\": \"LERETI\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_24/455\",\n \"cliente\": \"LAZZARINI\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_24/442\",\n \"cliente\": \"ACINQUE INNOVAZIONE\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_24/426\",\n \"cliente\": \"KRATOS\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_24/315\",\n \"cliente\": \"TENNACOLA\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/408\",\n \"cliente\": \"ENYDROS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2021/379\",\n \"cliente\": \"CAP_HOLDING01\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_24/374\",\n \"cliente\": \"HERA-SPA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"T_24/334\",\n \"cliente\": \"V-RETI\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"T_24/317\",\n \"cliente\": \"CIIP\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/518\",\n \"cliente\": \"TEATEK\",\n \"pl\": \"VALENTINO\",\n },\n {\n \"work\": \"T_24/250\",\n \"cliente\": \"AIR LIQUIDE02\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"T_24/234\",\n \"cliente\": \"SMAT\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2021/541\",\n \"cliente\": \"CAP_HOLDING01\",\n \"pl\": \"RAUCCI\",\n },\n {\n \"work\": \"T_24/212.01\",\n \"cliente\": \"CIIP\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/209\",\n \"cliente\": \"VERITAS\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"T_25/374\",\n \"cliente\": \"AIR LIQUIDE02\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"2024/111\",\n \"cliente\": \"IRETI-SPA\",\n \"pl\": \"TARANTO\",\n },\n {\n \"work\": \"2024/072\",\n \"cliente\": \"ACQUE VERONESI\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"2023/558\",\n \"cliente\": \"IRETI-SPA\",\n \"pl\": \"TARANTO\",\n },\n {\n \"work\": \"2023/546\",\n \"cliente\": \"ACQUEDOTTO DEL FIORA\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"2023/530\",\n \"cliente\": \"A2A-BRESCIA_04\",\n \"pl\": \"CESANI\",\n },\n {\n \"work\": \"2023/536.PVE.07\",\n \"cliente\": \"PIAVE SERVIZI\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/536.PVE.06\",\n \"cliente\": \"PIAVE SERVIZI\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/197\",\n \"cliente\": \"AIR LIQUIDE02\",\n \"pl\": \"PERAZZOLI\",\n },\n {\n \"work\": \"2023/536.BIM.00\",\n \"cliente\": \"BIM\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/536\",\n \"cliente\": \"VIVERACQUA\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/536.BIM.01\",\n \"cliente\": \"SIB01\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"2023/491\",\n \"cliente\": \"ACINQUE TECNOLOGIE\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"2023/420\",\n \"cliente\": \"ACQUEDOTTO PUGLIESE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/411\",\n \"cliente\": \"ACQUE VENETE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/004\",\n \"cliente\": \"SIB01\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"2023/349\",\n \"cliente\": \"ACQUEDOTTO PUGLIESE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2023/319\",\n \"cliente\": \"R-ACQUE-01\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"2023/163\",\n \"cliente\": \"GRAN SASSO\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"T_24/321\",\n \"cliente\": \"UNIBO01\",\n \"pl\": \"FABIANI\",\n },\n {\n \"work\": \"2023/072\",\n \"cliente\": \"ACQUE BRESCIANE\",\n \"pl\": \"TARANTO\",\n },\n {\n \"work\": \"2023/006\",\n \"cliente\": \"ACQUE BRESCIANE\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2022/433\",\n \"cliente\": \"ACINQUE TECNOLOGIE\",\n \"pl\": \"SANTULLO\",\n },\n {\n \"work\": \"2021/540\",\n \"cliente\": \"ALFA01\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2021/539\",\n \"cliente\": \"ALFA01\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2021/543\",\n \"cliente\": \"VIACQUA\",\n \"pl\": \"BARLETTA\",\n },\n {\n \"work\": \"2023/536.ATS.04\",\n \"cliente\": \"ATS\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"2021/539.01\",\n \"cliente\": \"ALFA01\",\n \"pl\": \"SCARANO\",\n },\n {\n \"work\": \"T_25/215\",\n \"cliente\": \"KRATOS\",\n \"pl\": \"GNIZIO\",\n },\n {\n \"work\": \"2021/455\",\n \"cliente\": \"IREN-SPA\",\n \"pl\": \"TARANTO\",\n },\n {\n \"work\": \"T_24/477\",\n \"cliente\": \"ABBANOA\",\n \"pl\": \"CESANI\",\n },\n];\n\nasync function callMonday(\n token: string,\n query: string,\n variables: Record,\n) {\n const res = await fetch(API_URL, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": token,\n },\n body: JSON.stringify({ query, variables }),\n });\n const json = await res.json();\n if (json.errors) {\n throw new Error(JSON.stringify(json.errors));\n }\n return json.data;\n}\n\nfunction sleep(ms: number) {\n return new Promise((resolve) => setTimeout(resolve, ms));\n}\n\nfunction htmlPage(bodyHtml: string) {\n return `\n\nImport commesse su Monday\n\n${bodyHtml}\n`;\n}\n\nexport default async function (req: Request): Promise {\n const token = Deno.env.get(\"MONDAY_TOKEN\");\n const noCacheHeaders = {\n \"Content-Type\": \"text/html; charset=utf-8\",\n \"Cache-Control\": \"no-store, no-cache, must-revalidate\",\n };\n\n if (!token) {\n return new Response(htmlPage(\"

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",false,"label",[14],"963b82f7-1053-41e4-84d1-88a3f3429faa",["D",1788962477426],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","235b2c97-abca-4f67-8091-33858c671eac","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f8577-5e75-704d-b4de-437c92c732ed","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_101":97},"org",{"_9":10,"_94":95,"_96":97,"_55":56,"_98":99,"_100":42},"branch",{"_35":30,"_11":85,"_22":28,"_86":45,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":12,"_93":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Giuseppe Longo","avatar","https://lh3.googleusercontent.com/a/ACg8ocKvqdQpRFJ66BYMngHXCvp_dbjR2poqGycp83mPfWd9MmSk0Q=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_78":-5,"_135":136,"_137":138,"_139":140,"_141":42,"_142":42,"_143":42,"_144":32,"_145":-5,"_146":-7,"_147":-7,"_148":62,"_149":42,"_150":42,"_151":-5,"_152":42,"_153":42,"_154":42,"_155":-5},"ENV",{"_106":107,"_108":109,"_110":85,"_111":112,"_113":114,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]