Tools

Technical/diagnostic endpoints — not needed for day-to-day dashboard use.

Status & diagnostics (read-only)

backfill_progress.phpread-only

Live status of the Active-stage cron backfill: current letter/position, processed/failed counts.

cron_debug.phpread-only

Deeper diagnostic for the cron job: lock file state, progress file, and the tail of its log file. Useful if backfill_progress.php looks stuck.

Manual backfill triggers

backfill.php?action=list&stage=PWCread-only

List PWC case folders. Add &stage=ACTIVE&letter=A to list Active folders under one letter.

backfill.php?action=process&stage=...&folder=<name>mutates DB

Process exactly one case folder (full detail output). The Active backfill now runs automatically via cron_runner.php — use this only for a manual one-off re-scan.

backfill.php?action=batch&stage=...[&letter=A]&start=0&limit=5mutates DB

Process several folders in one request (mostly superseded by the cron job for Active; still useful for ad-hoc re-runs).

One-time setup (already run, safe to leave alone)

migrate_file_metadata.phpmutates schema

Adds file_size_bytes/client_modified_at/unreadable_reason columns to `files`. Idempotent -- safe to revisit if unsure whether it already ran.

install.phpmutates schema

Original schema installer. Self-locks after first run -- revisiting just reports "already installed."

Not linked here on purpose

dropbox_oauth_exchange.php and dropbox_test.php are inert leftovers from initial setup (no logic/secrets) — pending physical removal once a working cPanel delete path is found. webhook.php is an API endpoint for Dropbox's own notifications, not something to browse directly.