Exam schedule app for Haliç University students.
Pick your courses, see every exam's date, time and room, and export the schedule to your calendar or as an image. Turkish and English. Not an official university site.
| Feature | Description |
|---|---|
| Course search | Search by code, name or acronym; hlu finds HLÜ. |
| Sections | Courses whose sections sit exams at different times are listed per section; program name is added when sections share a number. |
| Exact times | Dates and times are shown exactly as the university's Excel states them (Istanbul time), whatever the device time zone. |
| Calendar export | One .ics file with every selected exam (iOS, Android, Google, Outlook). |
| Image export | Schedule as a PNG, shared on phones and downloaded on desktop. |
| Bilingual | Turkish and English, picked from the browser language. |
| Exam days | A strip of the exam period, read from the data, with your exam days filled in. |
The site looks like a printed optical answer sheet. The logo spells an H with filled bubbles, and selected courses look shaded in with a pencil.
- Color: Haliç blue
#001BC3, taken from the university's logo. - Type: IBM Plex Sans and IBM Plex Mono.
- Theme: Light only, like the paper it copies. Colors live in
frontend/src/app/globals.css.
There is no backend. The university publishes the exam schedule as an Excel file; a script turns it into one static JSON file that the site loads.
graph LR
A["halic.edu.tr<br/>exam Excel"] --> B["scripts/sync.py"]
B --> C["frontend/public/data/exams.json"]
C --> D["Vercel<br/>Next.js static site"]
D --> E["Browser"]
sync.py handles the format quirks seen in past semesters (joined course codes, names containing ;, renamed columns, time cells stored as text or as Excel times). Anything it does not recognise makes it fail without writing, so the last good data stays live.
Prerequisites: Node.js 22+, uv (only for the sync script).
cd frontend
npm install
npm run dev # http://localhost:3000When a new exam schedule is announced:
- Put the "tüm liste" Excel link from the announcement on halic.edu.tr into
scripts/source.url. - Update the semester and exam type in
frontend/src/config/constants.ts. - Open a pull request. CI downloads and parses the file and shows a summary (exam count, date range) so you can check it is the right one.
After merge, the sync workflow regenerates exams.json on main. It also runs every hour, so later edits to the same Excel are picked up. If the file can't be parsed, nothing is written and the last good data stays live.
To run it locally: cd scripts && uv run sync.py (or pass a downloaded file: uv run sync.py <file>.xlsx).
| Command | Where | What |
|---|---|---|
npm run lint / npm run format |
frontend/ |
Biome lint and format |
npm test |
frontend/ |
Date and calendar tests (node:test) |
uv run pytest |
scripts/ |
Excel parsing tests |
CI runs all of them on every pull request; the frontend tests run with TZ=America/Los_Angeles so time zone bugs can't hide behind an Istanbul machine.
halic-exam-genius-pro/
├── frontend/
│ ├── public/data/exams.json # generated by scripts/sync.py
│ └── src/
│ ├── app/ # Next.js app router
│ ├── components/ # UI components
│ ├── config/constants.ts # semester and exam type labels
│ └── lib/ # data loading, dates, ICS, i18n
├── scripts/
│ ├── source.url # Excel link of the current exam period
│ ├── sync.py # Excel → exams.json
│ └── test_sync.py
└── .github/workflows/ # ci.yml, sync-data.yml