USJ Schedule Importer

System Settings

Current Year

Academic year for module data.

Sync Settings

Sync API Endpoint

Server URL for data sync. Leave empty to use default.

Authentication

🔒 Not logged in

AI Configuration

AI Provider

API Endpoint

API Key

Model

Prompt Template

Use {{record}} as placeholder for the Excel record data.

You are a university course schedule converter. Analyze the record and determine the scheduling approach.

SCHEDULE METHODS:
- "automatic": Let scheduler assign timeslots based on constraints
- "manual": Sessions are pre-assigned (fixed schedule in the data)
- "combined": Mix of automatic and manual
- "ignore": No scheduling needed (0 credits, by appointment, etc.)

CALCULATION RULES:
- 1 credit (Module Crs) = 10 hours of teaching
- Session duration: add 15min buffer (e.g., "2h45m" → 3 hours)
- Total sessions = (credits × 10) ÷ session hours
- 1 block = ~5 weeks, 1 semester = 3 blocks = ~15 weeks
- Parse "Weekdays Constraints" for specific days (Mon=1...Fri=5)
- "morning" → preferredSlotType=1, "afternoon" → 2

BLOCKS (2025-2026):
- Block 1: Sep 1 - Oct 4 (Sem 1, weeks 1-5)
- Block 2: Oct 6 - Nov 8 (Sem 1, weeks 6-10)
- Block 3: Nov 10 - Dec 13 (Sem 1, weeks 11-15)
- Block 4: Jan 5 - Feb 7 (Sem 2, weeks 1-5)
- Block 5: Feb 8 - Mar 28 (Sem 2, weeks 6-10)
- Block 6: Apr 12 - May 16 (Sem 2, weeks 11-15)
- Block 7: May 17 - Jun 20 (Summer)

Input Record:
{{record}}

Output ONLY valid JSON:
{
  "confidence": <0-100>,
  "reasoning": "<explain how you derived these values>",
  "title": "<Module Title>",
  "lecturer": <lecturer id>,
  "totalSessions": <calculated>,
  "sessionsPerWeek": <calculated>,
  "allowedWeekdays": [1,2,3,4,5],
  "preferredBlocks": [<1-7 which blocks this can be scheduled>],
  "mustComplyBlocks": <true if block constraints are strict>,
  "preferredSlotType": <0=any, 1=morning, 2=afternoon>,
  "requiredRoomType": 0,
  "fixedTimeslot": -1,
  "durationWeek": <weeks>,
  "studentGroupIds": ["<group codes>"],
  "notes": "<constraints summary>"
}

Original Record

Hide empty

AI Response JSON

📅 USJ Schedule Importer

System Settings

Sync Settings

AI Configuration

Drop Excel File Here

Select a record

Original Record

Analysis Result

Input Record

AI Analysis

Preassigned Sessions

Analysis Reasoning

Prompt Sent to AI

Raw AI Response

Message

Data Store Viewer - Row ?

💾 Save

📋 Dataset Inspector

Module Sync Preview

👥 Student Groups Sync

👨‍🏫 Lecturers Sync