Microsoft Redeem Code Finder

A sleek web app for Singapore MCTs to search Microsoft Learn courses, open Singapore-tracked course pages, and generate achievement codes end-to-end via Playwright.

Live Demo · Report Bug · Request Feature

Screenshot

About

A web app for Singapore-based Microsoft Certified Trainers (MCTs) to look up Microsoft Learn courses from the official Title Plan, open the correctly-tracked Singapore course page, and generate achievement codes end-to-end via Playwright browser automation.

Code generation requires running the Python backend locally — GitHub Pages can only serve the static search UI.

Key Features

• Search the 132-course April 2026 Title Plan by course number or title
• Open Singapore course page with correct partner tracking: ?WT.mc_id=ilt_partner_webpage_wwl&ocid=5238477
• Generate achievement codes locally — Playwright drives Chromium through the full Microsoft Learn request flow
• Auto-save generated codes to CSV with timestamps for record-keeping
• Debug support — screenshots + HTML dumps on failure for easy troubleshooting

Tech Stack

Layer	Technology
Frontend	Plain HTML / CSS / JS (no build step)
Backend	Flask (static serving + JSON API)
Automation	Playwright (Python) + Chromium
Data Source	Microsoft MCT Courseware Title Plan (Excel)
Deployment	GitHub Pages (static) / Local (full mode)

Architecture

┌─────────────────────────────────────────────────┐
│ Browser (UI) │
│ index.html · styles.css · app.js │
├─────────────────────────────────────────────────┤
│ Flask Server (server.py) │
│ GET / ── Static file serving │
│ POST /api/login ── Auth flow │
│ POST /api/generate ── Code generation │
├──────────────┬──────────────────┬────────────────┤
│ login.py │ generate.py │ paths.py │
│ Headed │ Headless │ Shared │
│ Chromium │ Chromium │ paths + │
│ sign-in │ code request │ SG suffix │
├──────────────┴──────────────────┴────────────────┤
│ Data Layer │
│ courses.json · storage_state.json · codes.csv │
└─────────────────────────────────────────────────┘

Project Structure

microsoftredeemcode/
├── .github/workflows/pages.yml # deploys webapp/ to GitHub Pages
├── titleplan_may1_2026.xlsx # source of truth
├── webapp/
│ ├── index.html · styles.css · app.js # static UI
│ ├── courses.json # extracted from xlsx
│ ├── extract_courses.py # xlsx → json
│ ├── server.py # Flask app: static + /api/*
│ └── backend/
│ ├── login.py # Playwright sign-in flow
│ ├── generate.py # Playwright code-generation flow
│ └── paths.py # shared paths + Singapore URL suffix
└── README.md

Getting Started

Static Mode (search + SG links only)

Just open https://alfredang.github.io/microsoftredeemcode/ — no install required.

Full Mode (with code generation)

git clone https://github.com/alfredang/microsoftredeemcode.git
cd microsoftredeemcode/webapp
# Install Python deps
python -m pip install flask playwright openpyxl
python -m playwright install chromium
# Start the app
python server.py

Open http://localhost:8000.

Code Generation

One-time: Sign in to Microsoft Learn

Click Sign in to Microsoft in the auth bar at the top of the page. A Chromium window opens — sign in with your MCT account, then either click the injected Finish & save session banner or close the window. Playwright writes your session to webapp/data/storage_state.json and reuses it silently for subsequent generations.

⚠️storage_state.json contains live Microsoft auth cookies. It is in .gitignore — never commit it.

Generating a Code

1. Search for a course.
2. On the matching card, set Number of students.
3. Click Generate achievement code.

The code + URL render inline on the card and are appended to data/codes.csv:

timestamp,courseNumber,code,url,students2026-04-15T02:34:12+00:00,AI-102T00,8X582M,https://learn.microsoft.com/...,25

If a step fails, a screenshot + full page HTML dump land in data/debug/ and the UI shows a step-labeled error.

Updating the Title Plan

When a new titleplan_*.xlsx drops:

1. Replace the xlsx at the repo root.
2. Update the path in webapp/extract_courses.py if the filename changed.
3. Regenerate the JSON: python webapp/extract_courses.py.
4. Commit courses.json alongside the xlsx.

Security Notes

• storage_state.json (MS auth cookies) and codes.csv (generated codes) are gitignored
• The Flask server binds to 127.0.0.1 only — not exposed to the network
• Never commit the data/ folder contents

---

Developed by Tertiary Infotech Academy Pte. Ltd.

Internal partner tooling. Not affiliated with or endorsed by Microsoft.

If this tool is helpful, give it a ⭐!