Project Tracker

Build Checklist

Track completed and pending work across the concert site and music school system. Check items as they are completed โ€” progress is saved automatically in this browser.

Overall Progress

0%
0 completed 0 pending 0 total

๐ŸŽต Concert Site

Registration Page
Performer card with instrument dropdown (Piano, Violin, etc.)
Piece information โ€” title, composer, duration
Guest management and pricing
PayPal and Zelle payment options
Time slot capacity tracking (11 AM / 12 PM)
Duplicate email detection
Supabase DB save with retry logic
Formspree + EmailJS confirmation email
Sponsored by Steinway Piano Galleries section
Admin Panel
Dashboard with live stats
Registrations โ€” view, confirm, cancel, manual add, export CSV
Concert Program โ€” generate, reorder, lock/unlock, print per slot
Events management
Email Campaigns (Mailchimp)
PayPal Sync
Sandbox / Live mode toggle
Health Check
Inventory management
Security โ€” change password, session info
API Config โ€” status of all integrations
Pending
Fix Twilio SMS โ€” not receiving texts Bug
Remove unused admin-v2.html and admin-legacy.html files

๐ŸŽ“ Music School System

Foundation
Separate Supabase project (RWM Music School DB)
Complete schema v3 โ€” 29 tables, multi-school, multi-currency (USD/PEN)
Multi-school architecture โ€” RWM-US (Alpharetta GA) + RWM-PE (Trujillo Peru)
School switcher โ€” sidebar dropdown persisted in localStorage
Sandbox / Live mode toggle on all school pages โ€” blocks DB writes in sandbox
Deploy school system (risingwithmelodies.org/school/) Deploy
Modules โ€” Completed
Students โ€” full enrollment form, guardian, financial aid, auto student ID, search, filter, export CSV
Programs โ€” class types (Music/English/Arts/Sports), instrument, pricing (USD/PEN), activate/deactivate
Staff โ€” roles, instruments taught, hourly/monthly rate, hire date, bio, CSV export
Enrollments โ€” student + program + teacher + schedule, tuition type, discount %, status management
Attendance โ€” daily lesson tracking, auto-generate from schedule, Present/Absent/Late/Excused, notes
Gradebook โ€” assessments (practical/theory/recital/exam), grade entry, report cards with publish/print
Billing โ€” monthly + per-lesson invoices, payment recording (Zelle/cash/check), multi-currency
Scholarships & Donors โ€” scholarship programs, student awards, donor profiles, donation tracking
Dashboard Analytics โ€” 8 live stats, today's schedule with attendance dots, recent students, quick actions
Inventory โ€” instruments, books, equipment, loan tracking with availability bar
Communications โ€” announcements, email (mailto), SMS (Twilio), draft/send history
Volunteers โ€” concert registrants auto-saved to school DB, manual add, CSV export
Concert โ†’ School cross-save โ€” donors saved to Scholarships, volunteers saved to Volunteers (RWM-PE)
Stripe integration for online tuition payments + manual invoice creation
Parent / Student Portal โ€” login, overview, attendance, invoices, Stripe pay, report cards

๐Ÿ“„ Documentation

Admin User Guides
Docs home page
Concert Admin User Guide
School Admin User Guide
Deploy docs (risingwithmelodies.org/docs/) Deploy
Technical & Operations
Technical Reference โ€” system architecture, data model
Deployment Guide โ€” build and deploy to Cloudflare workflow
Operations Guide โ€” weekly/monthly checklist
Troubleshooting Guide โ€” common issues and fixes

โš–๏ธ Legal & Compliance

FICA Partnership (Iquitos Hub) โ€” found during agreement review, Sep 2026
Get RWM Board authorization/resolution approving the FICA partnership and Iquitos expansion, per Bylaws Article Ten ยง1 (contracts require Board authorization before an officer executes them) โ€” DONE: unanimously adopted at the special Board meeting held 9/27/2026; see signed minutes โ†’
Confirm and document (in Board minutes) that no RWM Director/officer has a personal or financial conflict of interest with FICA, per Bylaws Article Nine โ€” DONE: inquiry made and documented in the same signed minutes โ†’
Request FICA's official Ficha RUC (SUNAT certificate) to confirm RUC 20605420622, legal name, active status, and address match the agreement
Confirm RWM's registration status with Peru's APCI as an ENIEX (foreign entity executing technical cooperation programs in Peru) Needs Verification
Confirm RWM's SUNAT registration as a qualified donation recipient before shipping instruments/materials to the Iquitos hub, to avoid customs holds and import taxes Needs Verification
Basic sanctions/watchlist (OFAC) screening of FICA before finalizing partnership โ€” standard due diligence for international nonprofit partnerships