ETL Operations
Import from Fargo Public Schools Website
Automatically fetch the latest enrollment data from the district's official monthly enrollment summaries.
View source: fargo.k12.nd.us/about-us/enrollment-dataImport Enrollment CSV
Upload CSV with enrollment headcount data.
Required columns: SchoolCode, GradeLevel, StudentCount
Example: EBENN,K,85
Import Forecasts
Upload RSP forecast CSV.
Required columns: SchoolCode, GradeLevel, ForecastedEnrollment
Example: EBENN,K,90
Import Rooms
Upload room inventory CSV.
Required columns: SchoolCode, RoomNumber, RoomTypeCode
Optional: RoomName, ArchCapacity, FuncCapacity
Import RSP Format CSV (Wide Format)
Import enrollment or forecast data from RSP-style CSV files with grade columns.
Format: School, Capacity, Kind, 1st, 2nd, 3rd, 4th, 5th, 6th, 7th, 8th, 9th, 10th, 11th, 12th, Total
Import HPM Educational Adequacy Data
Import space inventory data from the HPM Educational Adequacy report. This data includes room inventory counts, required spaces, and shortfalls for all schools.
Data source: HPM Educational Adequacy - Space Shortfall Analysis
Import Individual Room Details
Import detailed room-by-room inventory with actual room numbers from the HPM Educational Adequacy Excel file. This provides individual room records (1000+ rooms) for use in visual space planning.
Required columns: SchoolCode, RoomNumber, RoomName, SpaceType, ProgramArea, SFActual
Example: EBENN,101,Classroom,Elementary Classroom,Core Academics,850
Recent ETL Runs
| Process | Year | Status | Rows In | Loaded | Rejected | Started |
|---|---|---|---|---|---|---|
| Room Inventory CSV Import | N/A | Failed | 0 | 0 | 0 | 2025-12-15T03:12:04.688Z |
| Room Inventory CSV Import | N/A | Failed | 0 | 0 | 0 | 2025-12-15T02:35:11.286Z |