B4i Fuel History — Weekly Auto-Update

Tuesday 15:00 SAST (13:00 UTC). Late buffer: Bernd typically sends Mon evening / Tue morning, so 15:00 catches stragglers.

What it does

Reads ~/workspace/PKA/SecondBrain/wiki/concepts/Fuel-Prices-B4i.md — gets last_updated from frontmatter.
Searches Outlook (m365 skill) for from:bernd@b4i.co.za subject:"B4i Fuel" since last_updated - 2 days (overlap window for late emails).
For each new email (not already a ### YYYY-MM-DD section in the note):
Reads body via graph_api.py read-message
Strips HTML, takes only the TOP update (caps at first From: header in body)
Formats as ### YYYY-MM-DD (Day) with yaml block (type/effective/trend) + bullet list of supplier/location moves
Appends new sections in chronological order.
Bumps last_updated: in frontmatter to today.
Re-embeds the updated MD as base64 into the HTML report (~/workspace/reports/fuel-impact-2026-05-07.html — replaces the _MD_B64 constant).
PKA auto-push commits changes.

Cadence

Wakes Tue 15:00 SAST. Runs in ~2-5 min.
If no new email since last_updated, exits with "NO NEW EMAILS" — no Telegram noise.
Notifies on change with summary of appended dates.

Telegram dest

elmar-pka topic — same as other FlySafair work.

Skip conditions

Email body < 200 chars after HTML strip → log + skip that email.
Non-tariff Bernd emails (admin/process) → still capture but flag type: admin in yaml block.

Cross-task notes

IATA fuel update: Tue 06:10 UTC (8:10 SAST) — separate, no conflict.
This: Tue 13:00 UTC (15:00 SAST) — 7-hour buffer.
If Bernd shifts cadence, push to Wed morning.

Failure modes

Outlook search fails (token expired) → retry true, will re-attempt next week or via manual trigger.
Note file missing → fail loud (Telegram alert).
Append conflict (someone else edited the note) → claude must merge cleanly via Edit tool, not overwrite.

Manual trigger

python3 /home/lucienne/workspace/scheduler.py run b4i-fuel-history-update

Schedule Tue at 13:000 13 * * 2

EnabledYes

Run Asshell

Timeout1800s

RetryYes

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

Task Definition

tasks/b4i-fuel-history-update.md

Run Asshell

Commandset

Tool-lessNo

BackgroundNo

Runtime profile

Notify destination

cd /home/lucienne/workspace/PKA && git pull --rebase --autostash --quiet 2>/dev/null || git rebase --abort 2>/dev/null; claude --settings ~/.claude/settings-worker.json --allowedTools Bash,Read,Edit,Glob,Grep -p "Two-part weekly fuel update.

PART 1 — B4i email history. Read ~/workspace/PKA/SecondBrain/wiki/concepts/Fuel-Prices-B4i.md. Get last_updated from frontmatter. Use python3 ~/.claude/skills/m365/scripts/graph_api.py search to find emails from bernd@b4i.co.za with subject 'B4i Fuel' since last_updated - 2 days. For each email NOT already represented (compare ### YYYY-MM-DD headings): read body, strip HTML, extract TOP update (cap at first ' From: ' header). Format as new '### YYYY-MM-DD (Day)' section using template at bottom. Append in chronological order. Bump last_updated.

PART 2 — Radixx surcharge files. Read ~/workspace/PKA/SecondBrain/wiki/concepts/Fuel-Surcharge-Radixx.md last_updated. Use Graph Search API via curl to query driveItems for 'Fuel levy' and 'April Fuel' since last_updated. For each new XLSX: download via Graph drive-item content endpoint to /tmp/fuel_levy/, parse with openpyxl (find 'Route Pair' header row, extract route + Final Surcharge Per Pax columns), append to ~/workspace/PKA/SecondBrain/wiki/concepts/fuel-surcharge-data/surcharge_history.{json,csv}. Update pivot table in the markdown note. Bump last_updated.

PART 3 — Refresh embedded base64 in ~/workspace/reports/fuel-impact-2026-05-07.html for the B4i note (replace _MD_B64= string with new base64 of Fuel-Prices-B4i.md). Update _SURCH_PIVOT JSON literal with new surcharge data.

Print summary: 'APPENDED N B4i emails, M surcharge weeks: ...' or 'NO NEW DATA'. PKA auto-push commits."

This task calls claude directly. If the scheduler profile is GLM, Kimi, or MiniMax, prefer ~/workspace/PKA/scripts/claude-provider-run.sh so backup providers run in API-key-only mode with explicit settings/MCP context.

---
id: b4i-fuel-history-update
title: Append latest B4i Fuel emails to SecondBrain note
schedule: "0 13 * * 2"
timeout: 1800
retry: true
enabled: true
notify_on: change
notify_to: elmar-pka
runtime_profile: claude_anthropic
run_as: shell
command: "cd /home/lucienne/workspace/PKA && git pull --rebase --autostash --quiet 2>/dev/null || git rebase --abort 2>/dev/null; claude --settings ~/.claude/settings-worker.json --allowedTools Bash,Read,Edit,Glob,Grep -p \"Two-part weekly fuel update.\n\nPART 1 — B4i email history. Read ~/workspace/PKA/SecondBrain/wiki/concepts/Fuel-Prices-B4i.md. Get last_updated from frontmatter. Use python3 ~/.claude/skills/m365/scripts/graph_api.py search to find emails from bernd@b4i.co.za with subject 'B4i Fuel' since last_updated - 2 days. For each email NOT already represented (compare ### YYYY-MM-DD headings): read body, strip HTML, extract TOP update (cap at first ' From: ' header). Format as new '### YYYY-MM-DD (Day)' section using template at bottom. Append in chronological order. Bump last_updated.\n\nPART 2 — Radixx surcharge files. Read ~/workspace/PKA/SecondBrain/wiki/concepts/Fuel-Surcharge-Radixx.md last_updated. Use Graph Search API via curl to query driveItems for 'Fuel levy' and 'April Fuel' since last_updated. For each new XLSX: download via Graph drive-item content endpoint to /tmp/fuel_levy/, parse with openpyxl (find 'Route Pair' header row, extract route + Final Surcharge Per Pax columns), append to ~/workspace/PKA/SecondBrain/wiki/concepts/fuel-surcharge-data/surcharge_history.{json,csv}. Update pivot table in the markdown note. Bump last_updated.\n\nPART 3 — Refresh embedded base64 in ~/workspace/reports/fuel-impact-2026-05-07.html for the B4i note (replace _MD_B64= string with new base64 of Fuel-Prices-B4i.md). Update _SURCH_PIVOT JSON literal with new surcharge data.\n\nPrint summary: 'APPENDED N B4i emails, M surcharge weeks: ...' or 'NO NEW DATA'. PKA auto-push commits.\""
tags: [flysafair, fuel, b4i, secondbrain]
---

# B4i Fuel History — Weekly Auto-Update

Tuesday 15:00 SAST (13:00 UTC). Late buffer: Bernd typically sends Mon evening / Tue morning, so 15:00 catches stragglers.

## What it does

1. Reads `~/workspace/PKA/SecondBrain/wiki/concepts/Fuel-Prices-B4i.md` — gets `last_updated` from frontmatter.
2. Searches Outlook (m365 skill) for `from:bernd@b4i.co.za subject:"B4i Fuel"` since `last_updated - 2 days` (overlap window for late emails).
3. For each new email (not already a `### YYYY-MM-DD` section in the note):
   - Reads body via `graph_api.py read-message`
   - Strips HTML, takes only the TOP update (caps at first ` From: ` header in body)
   - Formats as `### YYYY-MM-DD (Day)` with yaml block (type/effective/trend) + bullet list of supplier/location moves
4. Appends new sections in chronological order.
5. Bumps `last_updated:` in frontmatter to today.
6. Re-embeds the updated MD as base64 into the HTML report (`~/workspace/reports/fuel-impact-2026-05-07.html` — replaces the `_MD_B64` constant).
7. PKA auto-push commits changes.

## Cadence

- Wakes Tue 15:00 SAST. Runs in ~2-5 min.
- If no new email since `last_updated`, exits with "NO NEW EMAILS" — no Telegram noise.
- Notifies on change with summary of appended dates.

## Telegram dest

`elmar-pka` topic — same as other FlySafair work.

## Skip conditions

- Email body < 200 chars after HTML strip → log + skip that email.
- Non-tariff Bernd emails (admin/process) → still capture but flag `type: admin` in yaml block.

## Cross-task notes

- IATA fuel update: Tue 06:10 UTC (8:10 SAST) — separate, no conflict.
- This: Tue 13:00 UTC (15:00 SAST) — 7-hour buffer.
- If Bernd shifts cadence, push to Wed morning.

## Failure modes

- Outlook search fails (token expired) → retry true, will re-attempt next week or via manual trigger.
- Note file missing → fail loud (Telegram alert).
- Append conflict (someone else edited the note) → claude must merge cleanly via Edit tool, not overwrite.

## Manual trigger

```bash
python3 /home/lucienne/workspace/scheduler.py run b4i-fuel-history-update
```

Edit Schedule

Frequency

Result:

Runs (7d)

Completed

Failed

Timeout

100%

Success (7d)

11.3m

Avg Duration

flysafair fuel b4i secondbrain

Run History (1)

Started	Finished	Status	Duration	Output	Log
4d ago	4d ago	completed	11.3m	Done. HTML is gitignored (`reports/*/.html`) by design — on-disk refresh is the deliverable, no commit needed. PKA ... Done. HTML is gitignored (`reports/*/.html`) by design — on-disk refresh is the deliverable, no commit needed. PKA wiki+data committed (691078b0); luci-autopush pushes next cycle. ## APPENDED 1 B4i email, 1 surcharge week PART 1 — B4i (`Fuel-Prices-B4i.md`) - New section `### 2026-06-08 (Mon)` — weekly, effective Tue 9/6, increasing: Shell CPT +16cpl, Astron +56cpl, Shell JHB inland +R1.00/L, Engen DUR 85cpl < Shell (supply from Sat 13/6), ZNZ new tariff 10/6. - 2026-06-01 email already represented (last run). last_updated → 2026-06-09. PART 2 — Radixx (`Fuel-Surcharge-Radixx.md` + `surcharge_history.{json,csv}`) - 1 new file: `Fuel 2 June 2026.xlsx` → week 2026-06-02, 26 routes. - 19 May + 26 May = no surcharge file posted (pre-existing gap, naming changed `Fuel levy X`→`Fuel X`). - Formula re-validated against stored 05-12 (0 mismatches): `final = round-half-up(ex_vat × 1.15)`, =ex_vat for No Vat routes. +26 json/csv records, pivot column added. PART 3 — HTML* (`fuel-impact-2026-05-07.html`) - `_MD_B64` re-encoded (23,928 chars → decodes to updated note incl. 2026-06-08 ✓). - `_SURCH_PIVOT` rebuilt — 26/26 routes carry 02 Jun ✓. File 59,695→60,937 B. ⚠ Data flag: source file marks *CPT-PLZ as No Vat** (R268 ex-VAT) — domestic route, unusual. Drop 458→268 is partly real fuel easing, partly the VAT-treatment switch. Reflected file faithfully; may be a Pieter spreadsheet quirk worth a check. Suggested next: ping Pieter to confirm the CPT-PLZ *No Vat flag is intentional before the 02 Jun surcharge feeds any board/fare comms. Want me to flag the CPT-PLZ VAT anomaly to Pieter? (yes/no)	View log

Comments (0)

No comments yet — add instructions for Luci

←