Upload the Service Orders seed CSV downloaded from the PEP portal. This tool
fills the three blank columns — INDIVIDUAL PROVIDER ID, START DATE,
END DATE — from the matching Airtable PEP Collection record
(matched on PO # = the record's Line Item #), preserving the rest of
your file exactly, and returns the completed CSV to upload back to the portal.
It never writes to Airtable (read-only) and only ever fills blank cells —
an already-filled cell is never changed.
You must be signed in as an administrator to use this page.
Sign inThese rows could not be fully filled (missing a required field), so they were excluded from the downloaded CSV to keep it upload-ready for the portal. Fix the underlying record (e.g. link its booking) and re-export to include them.
| PO # | Student | Amount | Why removed |
|---|
These CSV rows had a PO # that matched no PEP Collection record, so their
INDIVIDUAL PROVIDER ID / START DATE / END DATE were
left blank. This does not block the download — review them and re-run if needed.
| PO # | Student | Amount |
|---|
These Airtable records are in the Bookings "PEP Collection" view, are linked
to a PEP Collection record with Status = Pending, but did not
appear as a PO # in your seed CSV. This may indicate a sync issue — it may be
worth investigating why they weren't in the file downloaded from the PEP portal. (Informational
only — your CSV was still generated.)
| PO # (Line Item #) | Student | Amount | Status |
|---|
| PO # | Student | Result | Filled | Notes |
|---|