---
name: "Ford Asset Pack SFTP Transfer"
client: Ford
status: active
server: box-cli-01
tech: [Python, Box API, SFTP, Mailgun]
local_path: /Users/ai_leed/Documents/Projects/Oliver/ford-gechub-sftp
deploy: python main.py [--daemon]
url: 
tags: [ford, sftp, box, gechub, automation, mailgun]
created: 2026-04-14
---

## Overview
Automated Box → GECHUB SFTP transfer for Ford asset pack ZIPs. Monitors 3 Box folders (PROD, EDU, QA), downloads, uploads to SFTP, archives, sends email via Mailgun. One-shot or daemon mode.

## Tech Stack
- **Backend:** Python
- **Integrations:** Box API, SFTP (paramiko), Mailgun
- **Infrastructure:** No Docker

## Deployment
- **One-shot:** `python main.py`
- **Daemon:** `python main.py --daemon`
- **Local path:** `/Users/ai_leed/Documents/Projects/Oliver/ford-gechub-sftp`

## Environments
| Env | Box Folder | SFTP |
|-----|-----------|------|
| PROD | Box/PROD | GECHUB PROD |
| EDU | Box/EDU | GECHUB EDU |
| QA | Box/QA | GECHUB QA |

## Sessions
### 2026-04-29 – Asked | Added email recipients to
**Asked:** Asked | Added email recipients to distribution list and modified report to use 90-day cumulative window | report_email.py, report_email_recipients.csv, CLAUDE.md
**Done:** —

### 2026-04-29 – Add three people to the weekly
**Asked:** Add three people to the weekly distribution list and make the report accumulative over time.
**Done:** Updated distribution list recipients and modified report to show rolling data instead of weekly reset.

### 2026-04-29 – Add recipients to the distribution list
**Asked:** Add recipients to the distribution list and make the report accumulative over 90 days instead of weekly.
**Done:** Updated distribution list with three new recipients and changed report logic from 7-day to 90-day rolling window.

### 2026-04-29 – Add recipients to distribution list and
**Asked:** Add recipients to distribution list and convert weekly report to rolling 90-day cumulative view | Added 3 email addresses to recipients list, changed report window from 7 days to 90 days, updated subject line and headers to reflect rolling 3-month cadence | report_email_recipients.csv, report_email.py, CLAUDE.md
**Done:** —

### 2026-04-29 – Add three email recipients to distribution
**Asked:** Add three email recipients to distribution list and convert weekly report to rolling 90-day accumulative view | Added Louise, Jason, and Zoe to recipients; changed timedelta from 6 to 89 days; updated report naming and help text | report_email_recipients.csv, report_email.py
**Done:** —

### 2026-04-14 – Project catalogued
**Done:** Added to Obsidian second brain.

---
## Change Log
| Date | Requested | Changed | Files |
|------|-----------|---------|-------|
| 2026-04-29 | Distribution list update, rolling report data | report_email_recipients.csv, report_email.py | CLAUDE.md, report_email.py, report_email_recipients.csv |
| 2026-04-29 | Distribution update, Report window expansion | Added louisetallowin@oliver.agency, jasoncatton@oliver.agency, zoegarnett@oliver.agency; Changed timedelta from 6 days to 89 days; Updated subject line and email body text | report_email_recipients.csv, report_email.py |
| 2026-04-14 | Initial setup | Note created | — |

## Related
- [[ford_qc/Ford QC System]]
