AdvanTech Academy Content Builder

First-time setup: Run schema/academy_v2_schema.sql in Supabase SQL Editor, then refresh this page. This builder is the first step toward moving content out of giant HTML files.

Build sequence

Use this order when creating a new training track:

1. Create Track 2. Create Modules under that Track 3. Add Lessons and Reference Cards 4. Add Quiz Questions 5. Export a backup 6. Later: connect the Training Site runtime to load this content dynamically

Track Editor

SlugTitleDescriptionIconColorSort Order

Existing Tracks

Module cleanup: Use Archive to hide a module from the Training Site without deleting data. Use Delete only after exporting a backup; deletion cascades module lessons, references, quiz questions, assignments, and certifications.

Module Editor

TrackSlugTitleDescription

Icon

Sort Order

Passing Score

XP Reward

Existing Modules

Lesson Editor

ModuleTitleBody HTMLSort Order

Existing Lessons

Reference Editor

ModuleTitleTypeBody HTMLSort Order

Existing References

Question Editor

Module

Existing Questions

Export / Backup

Download database-managed training content for backups, migration, or AI-generated editing.

Import Full Track JSON

Import a full course with track, modules, lessons, references, and questions. Existing tracks/modules with matching slugs are updated; lessons, references, and questions are appended.

Choose JSON file Or paste JSON

Import Quiz Questions CSV

Use this for question banks. Required columns: track_slug,module_slug,question,option_a,option_b,option_c,option_d,correct_index,explanation. Optional: category,difficulty,scenario,sort_order.

Choose CSV file Or paste CSV

Import Preview

Always preview before importing. Errors must be fixed before import.

No import preview yet.

Runtime status

This phase adds import/export for v2 content. The next build step is to make the Training Site consume these tables directly.

No export loaded yet.

Review-only workflow: AI can draft training material, but it will not auto-publish. Review the generated JSON, then send it through Import / Backup.

Generate Course Draft

Source URL (vendor docs, Microsoft Learn, Ubiquiti docs, SOP page) Or paste source text / SOP / notes

Track slug

Track title

Module slug

Module title

Target role

Difficulty

Question count

Reference cards

The draft should create original AdvanTech training content, not copy source text verbatim. Always review before publishing.

Refresh Existing Module

Module Refresh instruction

Suggestions are saved as drafts for admin review; they do not change course content automatically.

AI Draft Output

Use Validate / Preview after sending this to Import. Do not import until you inspect lesson text, reference cards, and questions.

Academy v2 Content Builder