Upload cruise ship schedule (CSV)
Upload Cruise Ship Schedule (CSV)
Upload your corrected Ketchikan schedule CSV. Data is saved to the database permanently — upload once and return anytime for predictions.
date, ship, arrival, departure, berth, boat
— berth is where the cruise ship docks (2, 3, WW). boat is the tour boat operator (DrmC, 50/50, BW). Use comma or slash for multiple boats on one ship (e.g. BW, BWA, DrmC).
Clean dispatch XML (optional)
Clean Dispatch XML
Optional: clean and repair raw XML before import. You can also upload files directly to the database below — uploads accumulate and are saved permanently.
| # | Field | Issue | Before | After | Confidence |
|---|---|---|---|---|---|
| Paste XML above and click Clean & Analyze | |||||
Add Tours Manually
Add missing dispatch rows here. Saved tours appear in Raw Schedules below.
Future Captain Shifts
Predictions load automatically from saved database history. Each row is one boat assignment, sorted A→Z by boat code.
AI Prediction Assistant
Ask the AI to add, remove, or move boat assignments in the forecast.
| Date | Day | Boats | Ship | Check-in | Return | Confidence | Source | Busy Day |
|---|---|---|---|---|---|---|---|---|
| Loading predictions… | ||||||||
Captain Overview
Each captain's next predicted shift and total forecast count
Loading captain data…
Busy Day Calendar
Estimated passenger volume from cruise ship capacity data — darker = busier port day
Loading calendar…
Upload History
Every import is logged. Data stays in the database across restarts — you only need to upload when you receive new dispatch schedules.
| Uploaded | Filename | Imported | Updated | Notes |
|---|---|---|---|---|
| Loading history… | ||||
Raw Schedules
Historical tour rows through today — future dates appear in Predictions, not here.
| Date | Header | Ship | Check-in | Return | Berth | Boat / Captain | Source | |
|---|---|---|---|---|---|---|---|---|
| Loading schedules… | ||||||||