Update ACSA website passenger statistics

← Back to Tasks

OVERRIDES runtime profile: uses Gemini vision directly via Python — never invokes claude CLI. Profile set to direct_gemini so the scheduled-tasks page reflects actual provider.

Weekly ACSA website passenger statistics update. Downloads the consolidated passenger PDF from ACSA website, extracts departure data using Gemini vision, and updates ACSA Website Data.xlsx on Google Drive.

Source: https://www.airports.co.za/business/statistics/aircraft-and-passenger Target: ACSA Website Data.xlsx (Google Drive ID: 1dICi2ooUA-YcUk3my3hOyQNcWES-p7A1)

Runs Tuesday 8:00am SAST (6:00 UTC). The IATA fuel update runs at 8:30am — 30 min gap.

Previously used claude CLI to read the skill and execute steps, but that timed out at 600s (MC-586). Replaced with a direct Python script using Gemini for PDF extraction, which completes in ~30s.

Schedule Tue at 06:0000 06 * * 2

EnabledYes

Run Asshell

Timeout300s

RetryYes

Next Runin 3d (2026-06-16 06:00)

Task Definition

tasks/acsa-website-update.md

Run Asshell

Commandset

Tool-lessNo

BackgroundNo

Runtime profile

Notify destination

cd /home/lucienne/workspace && python3 scripts/acsa_website_update.py

---
id: acsa-website-update
title: Update ACSA website passenger statistics
schedule: "00 06 * * 2"
timeout: 300
retry: true
enabled: true
notify_on: always
run_as: shell
command: "cd /home/lucienne/workspace && python3 scripts/acsa_website_update.py"
tags: [flysafair, acsa, passengers, data]
runtime_profile: direct_gemini
---

**OVERRIDES runtime profile:** uses Gemini vision directly via Python — never invokes `claude` CLI. Profile set to `direct_gemini` so the scheduled-tasks page reflects actual provider.

Weekly ACSA website passenger statistics update. Downloads the consolidated
passenger PDF from ACSA website, extracts departure data using Gemini vision,
and updates ACSA Website Data.xlsx on Google Drive.

Source: https://www.airports.co.za/business/statistics/aircraft-and-passenger
Target: ACSA Website Data.xlsx (Google Drive ID: 1dICi2ooUA-YcUk3my3hOyQNcWES-p7A1)

Runs Tuesday 8:00am SAST (6:00 UTC). The IATA fuel update runs at 8:30am — 30 min gap.

Previously used claude CLI to read the skill and execute steps, but that timed out
at 600s (MC-586). Replaced with a direct Python script using Gemini for PDF extraction,
which completes in ~30s.

Edit Schedule

Frequency

Result:

Runs (7d)

Completed

Failed

Timeout

100%

Success (7d)

Avg Duration

flysafair acsa passengers data

Run History (1)

Started	Finished	Status	Duration	Output	Log
4d ago	4d ago	completed	6s	Downloading ACSA passenger statistics PDF... URL: https://www.airports.co.za/StatisticsLib/ACSA%20AERONAUTICAL%20PASSE ... Downloading ACSA passenger statistics PDF... URL: https://www.airports.co.za/StatisticsLib/ACSA%20AERONAUTICAL%20PASSENGER%20GROUP%20STATS.pdf Downloaded 547,818 bytes Extracting data from PDF using PyMuPDF... Found 15 Departure FY columns Latest FY column: FY26/27 FY25/26 domestic: 12 months FY25/26 regional: 12 months FY25/26 international: 12 months FY26/27 domestic: 1 months FY26/27 regional: 1 months FY26/27 international: 1 months Downloading ACSA Website Data.xlsx from Google Drive... Downloaded (file_id: 1dICi2ooUA-YcUk3my3hOyQNcWES-p7A1) Updating spreadsheet... Backup created No new data to add — spreadsheet is up to date No new data to add — spreadsheet is already up to date.	View log

Comments (0)

No comments yet — add instructions for Luci

←