{"definition_raw":"---\nid: acsa-website-update\ntitle: Update ACSA website passenger statistics\nschedule: \"00 06 * * 2\"\ntimeout: 300\nretry: true\nenabled: true\nnotify_on: always\nrun_as: shell\ncommand: \"cd /home/lucienne/workspace && python3 scripts/acsa_website_update.py\"\ntags: [flysafair, acsa, passengers, data]\nruntime_profile: direct_gemini\n---\n\n**OVERRIDES runtime profile:** uses Gemini vision directly via Python \u2014 never invokes `claude` CLI. Profile set to `direct_gemini` so the scheduled-tasks page reflects actual provider.\n\nWeekly ACSA website passenger statistics update. Downloads the consolidated\npassenger PDF from ACSA website, extracts departure data using Gemini vision,\nand updates ACSA Website Data.xlsx on Google Drive.\n\nSource: https://www.airports.co.za/business/statistics/aircraft-and-passenger\nTarget: ACSA Website Data.xlsx (Google Drive ID: 1dICi2ooUA-YcUk3my3hOyQNcWES-p7A1)\n\nRuns Tuesday 8:00am SAST (6:00 UTC). The IATA fuel update runs at 8:30am \u2014 30 min gap.\n\nPreviously used claude CLI to read the skill and execute steps, but that timed out\nat 600s (MC-586). Replaced with a direct Python script using Gemini for PDF extraction,\nwhich completes in ~30s.\n","id":"acsa-website-update","last_run":{"duration_s":6.190436,"log_path":"/home/lucienne/workspace/logs/task-runs/acsa-website-update/396751.log","output":"Downloading ACSA passenger statistics PDF...\n  URL: https://www.airports.co.za/StatisticsLib/ACSA%20AERONAUTICAL%20PASSENGER%20GROUP%20STATS.pdf\n  Downloaded 547,818 bytes\nExtracting data from PDF using PyMuPDF...\n  Found 15 Departure FY columns\n  Latest FY column: FY26/27\n  FY25/26 domestic: 12 months\n  FY25/26 regional: 12 months\n  FY25/26 international: 12 months\n  FY26/27 domestic: 1 months\n  FY26/27 regional: 1 months\n  FY26/27 international: 1 months\nDownloading ACSA Website Data.xlsx from Google Drive...\n  Downloaded (file_id: 1dICi2ooUA-YcUk3my3hOyQNcWES-p7A1)\nUpdating spreadsheet...\n  Backup created\n  No new data to add \u2014 spreadsheet is up to date\n\nNo new data to add \u2014 spreadsheet is already up to date.\n","started_at":"2026-06-09T06:00:00.388184+02:00","status":"completed"},"next_run":"2026-06-16 06:00","next_run_iso":"2026-06-16T06:00:00+02:00","runs":[{"duration_s":6.190436,"finished_at":"2026-06-09T06:00:06.581977+02:00","id":396751,"log_path":"/home/lucienne/workspace/logs/task-runs/acsa-website-update/396751.log","output":"Downloading ACSA passenger statistics PDF...\n  URL: https://www.airports.co.za/StatisticsLib/ACSA%20AERONAUTICAL%20PASSENGER%20GROUP%20STATS.pdf\n  Downloaded 547,818 bytes\nExtracting data from PDF using PyMuPDF...\n  Found 15 Departure FY columns\n  Latest FY column: FY26/27\n  FY25/26 domestic: 12 months\n  FY25/26 regional: 12 months\n  FY25/26 international: 12 months\n  FY26/27 domestic: 1 months\n  FY26/27 regional: 1 months\n  FY26/27 international: 1 months\nDownloading ACSA Website Data.xlsx from Google Drive...\n  Downloaded (file_id: 1dICi2ooUA-YcUk3my3hOyQNcWES-p7A1)\nUpdating spreadsheet...\n  Backup created\n  No new data to add \u2014 spreadsheet is up to date\n\nNo new data to add \u2014 spreadsheet is already up to date.\n","started_at":"2026-06-09T06:00:00.388184+02:00","status":"completed","task_id":"acsa-website-update","task_name":"Update ACSA website passenger statistics"}],"runs_limit":20,"schedule":"00 06 * * 2","schedule_label":{"description":"Tue at 06:00","is_custom":false,"label":"Weekly (Tue)","sort":6,"sort_time":"06:00"},"stats":{"avg_duration":6.190436,"completed":1,"failed":0,"timeout":0,"total":1},"task":{"_description":"**OVERRIDES runtime profile:** uses Gemini vision directly via Python \u2014 never invokes `claude` CLI. Profile set to `direct_gemini` so the scheduled-tasks page reflects actual provider.\n\nWeekly ACSA website passenger statistics update. Downloads the consolidated\npassenger PDF from ACSA website, extracts departure data using Gemini vision,\nand updates ACSA Website Data.xlsx on Google Drive.\n\nSource: https://www.airports.co.za/business/statistics/aircraft-and-passenger\nTarget: ACSA Website Data.xlsx (Google Drive ID: 1dICi2ooUA-YcUk3my3hOyQNcWES-p7A1)\n\nRuns Tuesday 8:00am SAST (6:00 UTC). The IATA fuel update runs at 8:30am \u2014 30 min gap.\n\nPreviously used claude CLI to read the skill and execute steps, but that timed out\nat 600s (MC-586). Replaced with a direct Python script using Gemini for PDF extraction,\nwhich completes in ~30s.","_file":"acsa-website-update.md","_path":"/home/lucienne/workspace/tasks/acsa-website-update.md","command":"cd /home/lucienne/workspace && python3 scripts/acsa_website_update.py","enabled":true,"id":"acsa-website-update","notify_on":"always","retry":true,"run_as":"shell","runtime_profile":"direct_gemini","schedule":"00 06 * * 2","tags":["flysafair","acsa","passengers","data"],"timeout":300,"title":"Update ACSA website passenger statistics"}}
