=== Job Execution Log === Job: ImdbUpdate Execution ID: 1223 Start Time: 2026-04-30 14:17:43 Command: C:\PYTHON\ImdbUpdate\RUN.bat Working Directory: C:\PYTHON\ImdbUpdate ================================================== ======================================== ImdbUpdate - Esecuzione ======================================== Rilevato ODBC Access 2026-04-30 14:17:44 - __main__ - INFO - ============================================================ 2026-04-30 14:17:44 - __main__ - INFO - ImdbUpdate v2 - Avvio (DuckDB pipeline) 2026-04-30 14:17:44 - __main__ - INFO - ============================================================ 2026-04-30 14:17:44 - __main__ - INFO - Base directory: C:\PYTHON\ImdbUpdate 2026-04-30 14:17:44 - __main__ - INFO - Temp directory: C:\PYTHON\ImdbUpdate\Temp 2026-04-30 14:17:44 - __main__ - INFO - Parquet output: C:\PYTHON\ImdbUpdate\parquet\imdb_full.parquet 2026-04-30 14:17:44 - __main__ - INFO - Pulizia file residui all'avvio... 2026-04-30 14:17:44 - __main__ - INFO - Nessun file residuo trovato 2026-04-30 14:17:44 - __main__ - INFO - Preparazione directory temporanea 2026-04-30 14:17:44 - __main__ - INFO - Eliminazione C:\PYTHON\ImdbUpdate\Temp 2026-04-30 14:17:44 - __main__ - INFO - Directory creata: C:\PYTHON\ImdbUpdate\Temp 2026-04-30 14:17:44 - __main__ - INFO - ============================================================ 2026-04-30 14:17:44 - __main__ - INFO - FASE 2: Download dataset IMDb 2026-04-30 14:17:44 - __main__ - INFO - ============================================================ 2026-04-30 14:17:44 - src.downloader - INFO - Download name_basics.tsv.gz da https://datasets.imdbws.com/name.basics.tsv.gz name_basics.tsv.gz: 0%| | 0.00/289M [00:00 name_basics.tsv 2026-04-30 14:18:00 - src.downloader - INFO - Decompressione completata: C:\PYTHON\ImdbUpdate\Temp\name_basics.tsv 2026-04-30 14:18:00 - src.downloader - INFO - Rinominato name_basics.tsv -> name_basics.txt 2026-04-30 14:18:00 - src.downloader - INFO - Download title_akas.tsv.gz da https://datasets.imdbws.com/title.akas.tsv.gz title_akas.tsv.gz: 0%| | 0.00/468M [00:00 title_akas.tsv 2026-04-30 14:18:28 - src.downloader - INFO - Decompressione completata: C:\PYTHON\ImdbUpdate\Temp\title_akas.tsv 2026-04-30 14:18:28 - src.downloader - INFO - Rinominato title_akas.tsv -> title_akas.txt 2026-04-30 14:18:28 - src.downloader - INFO - Download title_basics.tsv.gz da https://datasets.imdbws.com/title.basics.tsv.gz title_basics.tsv.gz: 0%| | 0.00/211M [00:00 title_basics.tsv 2026-04-30 14:18:42 - src.downloader - INFO - Decompressione completata: C:\PYTHON\ImdbUpdate\Temp\title_basics.tsv 2026-04-30 14:18:42 - src.downloader - INFO - Rinominato title_basics.tsv -> title_basics.txt 2026-04-30 14:18:42 - src.downloader - INFO - Download title_crew.tsv.gz da https://datasets.imdbws.com/title.crew.tsv.gz title_crew.tsv.gz: 0%| | 0.00/77.5M [00:00 title_crew.tsv 2026-04-30 14:18:47 - src.downloader - INFO - Decompressione completata: C:\PYTHON\ImdbUpdate\Temp\title_crew.tsv 2026-04-30 14:18:47 - src.downloader - INFO - Rinominato title_crew.tsv -> title_crew.txt 2026-04-30 14:18:47 - src.downloader - INFO - Download title_episode.tsv.gz da https://datasets.imdbws.com/title.episode.tsv.gz title_episode.tsv.gz: 0%| | 0.00/50.8M [00:00 title_episode.tsv 2026-04-30 14:18:50 - src.downloader - INFO - Decompressione completata: C:\PYTHON\ImdbUpdate\Temp\title_episode.tsv 2026-04-30 14:18:50 - src.downloader - INFO - Rinominato title_episode.tsv -> title_episode.txt 2026-04-30 14:18:50 - src.downloader - INFO - Download title_principals.tsv.gz da https://datasets.imdbws.com/title.principals.tsv.gz title_principals.tsv.gz: 0%| | 0.00/728M [00:00 title_principals.tsv 2026-04-30 14:19:33 - src.downloader - INFO - Decompressione completata: C:\PYTHON\ImdbUpdate\Temp\title_principals.tsv 2026-04-30 14:19:33 - src.downloader - INFO - Rinominato title_principals.tsv -> title_principals.txt 2026-04-30 14:19:33 - src.downloader - INFO - Download title_ratings.tsv.gz da https://datasets.imdbws.com/title.ratings.tsv.gz title_ratings.tsv.gz: 0%| | 0.00/8.03M [00:00 title_ratings.tsv 2026-04-30 14:19:34 - src.downloader - INFO - Decompressione completata: C:\PYTHON\ImdbUpdate\Temp\title_ratings.tsv 2026-04-30 14:19:34 - src.downloader - INFO - Rinominato title_ratings.tsv -> title_ratings.txt 2026-04-30 14:19:34 - src.downloader - INFO - Processati 7/7 file 2026-04-30 14:19:34 - __main__ - INFO - Download completato: 7 file 2026-04-30 14:19:34 - __main__ - INFO - ============================================================ 2026-04-30 14:19:34 - __main__ - INFO - FASE 3: Transform DuckDB \u2192 imdb.parquet 2026-04-30 14:19:34 - __main__ - INFO - ============================================================ 2026-04-30 14:19:34 - src.transformer - INFO - Caricamento title_basics: title_basics.txt 2026-04-30 14:19:43 - src.transformer - INFO - title_basics: 1,268,146 righe (filtrate per titleType) 2026-04-30 14:19:43 - src.transformer - INFO - Caricamento title_akas: title_akas.txt 2026-04-30 14:20:09 - src.transformer - INFO - title_akas: 5,339,896 righe (solo region=IT) 2026-04-30 14:20:09 - src.transformer - INFO - Caricamento title_ratings: title_ratings.txt 2026-04-30 14:20:10 - src.transformer - INFO - title_ratings: 1,666,757 righe 2026-04-30 14:20:10 - src.transformer - INFO - Caricamento title_principals: title_principals.txt 2026-04-30 14:20:58 - src.transformer - INFO - title_principals: 31,881,607 righe (director+actor) 2026-04-30 14:20:58 - src.transformer - INFO - Caricamento name_basics: name_basics.txt 2026-04-30 14:21:07 - src.transformer - INFO - name_basics: 15,286,980 righe 2026-04-30 14:21:07 - src.transformer - INFO - Costruzione new_imdb (step separati)... 2026-04-30 14:21:07 - src.transformer - INFO - Step 1/4: titoli italiani 2026-04-30 14:21:09 - src.transformer - INFO - Step 2/4: registi 2026-04-30 14:21:21 - src.transformer - INFO - Step 3/4: attori 2026-04-30 14:21:41 - src.transformer - INFO - Step 4/4: join finale 2026-04-30 14:21:45 - src.transformer - INFO - new_imdb: 1,268,146 righe 2026-04-30 14:21:45 - src.transformer - INFO - Scrittura parquet: C:\PYTHON\ImdbUpdate\parquet\imdb_full.parquet 2026-04-30 14:21:47 - src.transformer - INFO - Parquet scritto: 1,268,146 righe, 51.3 MB 2026-04-30 14:21:48 - __main__ - INFO - Transform completato: 1,268,146 righe in parquet 2026-04-30 14:21:49 - __main__ - INFO - Parquet copiato in: I:\SOFTWARE\PYTHON_SRV\PYTHON_LOCAL\MyICR_Suite\local_db\parquet\imdb_full.parquet 2026-04-30 14:21:49 - __main__ - INFO - ============================================================ 2026-04-30 14:21:49 - __main__ - INFO - FASE 4: Export Parquet \u2192 MS Access 2026-04-30 14:21:49 - __main__ - INFO - ============================================================ 2026-04-30 14:21:49 - src.access_exporter - INFO - Copia template Access: db_split_IMDB.accdb -> db_split_IMDB.accdb 2026-04-30 14:21:49 - src.access_exporter - INFO - Database Access creato: C:\PYTHON\ImdbUpdate\Temp\db_split_IMDB.accdb 2026-04-30 14:21:49 - src.access_exporter - INFO - Export Parquet -> Access: C:\PYTHON\ImdbUpdate\Temp\db_split_IMDB.accdb 2026-04-30 14:26:03 - src.access_exporter - INFO - Export completato: 1,268,146 record in IMDB 2026-04-30 14:26:03 - src.access_exporter - INFO - Arricchimento OTT_EMESSO via tabella linkata OTT... 2026-04-30 14:26:20 - src.access_exporter - INFO - Titoli OTT SVOD distinti: 38,482 2026-04-30 14:27:01 - src.access_exporter - INFO - OTT_EMESSO aggiornato: 38,482 record 2026-04-30 14:27:01 - src.access_exporter - INFO - Compattamento db_split_IMDB.accdb... 2026-04-30 14:27:13 - src.access_exporter - INFO - Compattamento completato 2026-04-30 14:27:13 - src.access_exporter - INFO - Copia db_split_IMDB.accdb in 2 destinazioni 2026-04-30 14:27:23 - src.access_exporter - INFO - Copiato in: I:\SOFTWARE\ProcedureICR\ICRmonitor\MonitorLinker\db_split_IMDB.accdb 2026-04-30 14:27:24 - src.access_exporter - INFO - Copiato in: C:\IcrMonitor\MonitorLinker\db_split_IMDB.accdb 2026-04-30 14:27:24 - __main__ - INFO - ============================================================ 2026-04-30 14:27:24 - __main__ - INFO - FASE 5: Copia IMDB in GemmaLoader (opzionale) 2026-04-30 14:27:24 - __main__ - INFO - ============================================================ 2026-04-30 14:27:24 - src.access_exporter - INFO - Copia IMDB in GemmaLoader: \\mediaset.it\cologno\icr_acquisti\GemmaLoader\GemmaLoader.accdb 2026-04-30 14:27:24 - src.access_exporter - INFO - Download GemmaLoader in locale... 2026-04-30 14:27:37 - src.access_exporter - INFO - Aggiornamento IMDB locale (csv_transfer)... 2026-04-30 14:27:50 - src.access_exporter - INFO - Compattamento GemmaLoader locale... 2026-04-30 14:27:58 - src.access_exporter - INFO - Compattamento completato 2026-04-30 14:27:58 - src.access_exporter - INFO - Upload GemmaLoader in rete... 2026-04-30 14:28:08 - src.access_exporter - INFO - Copia GemmaLoader completata 2026-04-30 14:28:08 - __main__ - INFO - ============================================================ 2026-04-30 14:28:08 - __main__ - INFO - FASE 6: Scrittura log finale 2026-04-30 14:28:08 - __main__ - INFO - ============================================================ 2026-04-30 14:28:08 - __main__ - INFO - Log creato: I:\SOFTWARE\ProcedureICR\ICRmonitor\MonitorLinker\UPDATES\log\UPDATE_IMDB al 30-04-26.txt 2026-04-30 14:28:08 - __main__ - INFO - ============================================================ 2026-04-30 14:28:08 - __main__ - INFO - FASE 7: Pulizia file temporanei 2026-04-30 14:28:08 - __main__ - INFO - ============================================================ 2026-04-30 14:28:08 - __main__ - INFO - Eliminato: name_basics.tsv.gz (0.28 GB) 2026-04-30 14:28:08 - __main__ - INFO - Eliminato: title_akas.tsv.gz (0.46 GB) 2026-04-30 14:28:08 - __main__ - INFO - Eliminato: title_basics.tsv.gz (0.21 GB) 2026-04-30 14:28:08 - __main__ - INFO - Eliminato: title_crew.tsv.gz (0.08 GB) 2026-04-30 14:28:08 - __main__ - INFO - Eliminato: title_episode.tsv.gz (0.05 GB) 2026-04-30 14:28:08 - __main__ - INFO - Eliminato: title_principals.tsv.gz (0.71 GB) 2026-04-30 14:28:08 - __main__ - INFO - Eliminato: title_ratings.tsv.gz (0.01 GB) 2026-04-30 14:28:08 - __main__ - INFO - Eliminato: name_basics.txt (0.88 GB) 2026-04-30 14:28:08 - __main__ - INFO - Eliminato: title_akas.txt (2.66 GB) 2026-04-30 14:28:08 - __main__ - INFO - Eliminato: title_basics.txt (1.01 GB) 2026-04-30 14:28:08 - __main__ - INFO - Eliminato: title_crew.txt (0.38 GB) 2026-04-30 14:28:08 - __main__ - INFO - Eliminato: title_episode.txt (0.24 GB) 2026-04-30 14:28:08 - __main__ - INFO - Eliminato: title_principals.txt (4.13 GB) 2026-04-30 14:28:08 - __main__ - INFO - Eliminato: title_ratings.txt (0.03 GB) 2026-04-30 14:28:08 - __main__ - INFO - Eliminato: db_split_IMDB.accdb (0.29 GB) 2026-04-30 14:28:08 - __main__ - INFO - Spazio liberato totale: 11.40 GB 2026-04-30 14:28:08 - __main__ - INFO - ============================================================ 2026-04-30 14:28:08 - __main__ - INFO - Completato con successo in 0:10:23.840165 2026-04-30 14:28:08 - __main__ - INFO - ============================================================