ACSA monthly domestic passenger data update

← Back to Tasks

OVERRIDES runtime profile: uses direct_python (plain Python, no model) because the command chain never invokes the claude CLI or any LLM API — pure-infra task; scheduler provider env injection is a no-op (MC-4942 U12 sweep).

Checks daily (7am SAST) if new FLYSAFAIR STATS files have appeared in the ACSA Google Drive folder. If new files found, extracts domestic departure data and updates ACSA Monthly Data.xlsx.

No AI needed — pure Python with openpyxl. Tracks processed files in .acsa-monthly-state.json to avoid reprocessing.

Source folder: Google Drive ACSA/ (ID: 1ANZkMmVWSk5TCvTsBI8WgjFA7qWMUQJE) Target: ACSA Monthly Data.xlsx in Reporting Data folder Pattern: FLYSAFAIR [MONTH] [YEAR] STATS.xlsx

Schedule Daily at 05:000 5 * * *

EnabledYes

Run Asshell

Timeout300s

RetryYes

Next Runin 23h (2026-06-14 05:00)

Task Definition

tasks/acsa-monthly-data.md

Run Asshell

Commandset

Tool-lessNo

BackgroundNo

Runtime profile

Notify destination

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

---
id: acsa-monthly-data
title: ACSA monthly domestic passenger data update
schedule: "0 5 * * *"
timeout: 300
retry: true
enabled: true
notify_on: failure
run_as: shell
command: "cd /home/lucienne/workspace && python3 scripts/acsa_monthly_update.py"
tags: [flysafair, acsa, passengers, monthly]
runtime_profile: direct_python
---
**OVERRIDES runtime profile:** uses `direct_python` (plain Python, no model) because the command chain never invokes the `claude` CLI or any LLM API — pure-infra task; scheduler provider env injection is a no-op (MC-4942 U12 sweep).

Checks daily (7am SAST) if new FLYSAFAIR STATS files have appeared in the
ACSA Google Drive folder. If new files found, extracts domestic departure
data and updates ACSA Monthly Data.xlsx.

No AI needed — pure Python with openpyxl. Tracks processed files in
.acsa-monthly-state.json to avoid reprocessing.

Source folder: Google Drive ACSA/ (ID: 1ANZkMmVWSk5TCvTsBI8WgjFA7qWMUQJE)
Target: ACSA Monthly Data.xlsx in Reporting Data folder
Pattern: FLYSAFAIR [MONTH] [YEAR] STATS.xlsx

Edit Schedule

Frequency

Result:

Runs (7d)

Completed

Failed

Timeout

100%

Success (7d)

Avg Duration

flysafair acsa passengers monthly

Run History (8)

Started	Finished	Status	Duration	Output	Log
1h ago	1h ago	completed	5s	=== ACSA Monthly Data Update — 2026-06-13 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FL ... === ACSA Monthly Data Update — 2026-06-13 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FLYSAFAIR MARCH 2026 STATS.xlsx (modified: 2026-04-13T06:28:56.242Z) Extracted: March 2026 Downloaded ACSA Monthly Data.xlsx OVERWRITE: March 2026 (row 90) — Pax=1,286,461, Seats=1,608,027, FA Pax=812,862, FA LF=0.8723 Saved 1 updates Uploaded to Google Drive Success: Updated March 2026	View log
1d ago	1d ago	completed	6s	=== ACSA Monthly Data Update — 2026-06-12 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FL ... === ACSA Monthly Data Update — 2026-06-12 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FLYSAFAIR MARCH 2026 STATS.xlsx (modified: 2026-04-13T06:29:55.000Z) Extracted: March 2026 Downloaded ACSA Monthly Data.xlsx OVERWRITE: March 2026 (row 90) — Pax=1,286,461, Seats=1,608,027, FA Pax=812,862, FA LF=0.8723 Saved 1 updates Uploaded to Google Drive Success: Updated March 2026	View log
2d ago	2d ago	completed	6s	=== ACSA Monthly Data Update — 2026-06-11 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FL ... === ACSA Monthly Data Update — 2026-06-11 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FLYSAFAIR MARCH 2026 STATS.xlsx (modified: 2026-04-13T06:29:55.000Z) Extracted: March 2026 Downloaded ACSA Monthly Data.xlsx OVERWRITE: March 2026 (row 90) — Pax=1,286,461, Seats=1,608,027, FA Pax=812,862, FA LF=0.8723 Saved 1 updates Uploaded to Google Drive Success: Updated March 2026	View log
3d ago	3d ago	completed	6s	=== ACSA Monthly Data Update — 2026-06-10 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FL ... === ACSA Monthly Data Update — 2026-06-10 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FLYSAFAIR MARCH 2026 STATS.xlsx (modified: 2026-04-13T06:28:56.242Z) Extracted: March 2026 Downloaded ACSA Monthly Data.xlsx OVERWRITE: March 2026 (row 90) — Pax=1,286,461, Seats=1,608,027, FA Pax=812,862, FA LF=0.8723 Saved 1 updates Uploaded to Google Drive Success: Updated March 2026	View log
4d ago	4d ago	completed	6s	=== ACSA Monthly Data Update — 2026-06-09 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FL ... === ACSA Monthly Data Update — 2026-06-09 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FLYSAFAIR MARCH 2026 STATS.xlsx (modified: 2026-04-13T06:29:55.000Z) Extracted: March 2026 Downloaded ACSA Monthly Data.xlsx OVERWRITE: March 2026 (row 90) — Pax=1,286,461, Seats=1,608,027, FA Pax=812,862, FA LF=0.8723 Saved 1 updates Uploaded to Google Drive Success: Updated March 2026	View log
5d ago	5d ago	completed	6s	=== ACSA Monthly Data Update — 2026-06-08 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FL ... === ACSA Monthly Data Update — 2026-06-08 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FLYSAFAIR MARCH 2026 STATS.xlsx (modified: 2026-04-13T06:28:56.242Z) Extracted: March 2026 Downloaded ACSA Monthly Data.xlsx OVERWRITE: March 2026 (row 90) — Pax=1,286,461, Seats=1,608,027, FA Pax=812,862, FA LF=0.8723 Saved 1 updates Uploaded to Google Drive Success: Updated March 2026	View log
6d ago	6d ago	completed	6s	=== ACSA Monthly Data Update — 2026-06-07 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FL ... === ACSA Monthly Data Update — 2026-06-07 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FLYSAFAIR MARCH 2026 STATS.xlsx (modified: 2026-04-13T06:29:55.000Z) Extracted: March 2026 Downloaded ACSA Monthly Data.xlsx OVERWRITE: March 2026 (row 90) — Pax=1,286,461, Seats=1,608,027, FA Pax=812,862, FA LF=0.8723 Saved 1 updates Uploaded to Google Drive Success: Updated March 2026	View log
7d ago	7d ago	completed	6s	=== ACSA Monthly Data Update — 2026-06-06 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FL ... === ACSA Monthly Data Update — 2026-06-06 05:00 === Found 6 FLYSAFAIR STATS files 1 new/updated file(s) to process: FLYSAFAIR MARCH 2026 STATS.xlsx (modified: 2026-04-13T06:28:56.242Z) Extracted: March 2026 Downloaded ACSA Monthly Data.xlsx OVERWRITE: March 2026 (row 90) — Pax=1,286,461, Seats=1,608,027, FA Pax=812,862, FA LF=0.8723 Saved 1 updates Uploaded to Google Drive Success: Updated March 2026	View log

Comments (0)

No comments yet — add instructions for Luci

←