Skip to content

CSV_MIGRATION_GUIDE.md

Latest commit

 

History

History
174 lines (130 loc) · 5.14 KB

CSV_MIGRATION_GUIDE.md

File metadata and controls

174 lines (130 loc) · 5.14 KB

CSV Format Migration Guide

Old Format (No Longer Supported)

Category1,Category2,Category3
$100,"Q: Question|A: Answer","Q: Question|A: Answer","Q: Question|A: Answer"
$200,"Q: Question|A: Answer","Q: Question|A: Answer","Q: Question|A: Answer"
$300,"Q: Question|A: Answer","Q: Question|A: Answer","Q: Question|A: Answer"
$400,"Q: Question|A: Answer","Q: Question|A: Answer","Q: Question|A: Answer"
$500,"Q: Question|A: Answer","Q: Question|A: Answer","Q: Question|A: Answer"

Problem: Same questions used for both Jeopardy and Double Jeopardy rounds

New Format (Required)

Category1,Category2,Category3
$100,"Q: Question|A: Answer","Q: Question|A: Answer","Q: Question|A: Answer"
$200,"Q: Question|A: Answer","Q: Question|A: Answer","Q: Question|A: Answer"
$300,"Q: Question|A: Answer","Q: Question|A: Answer","Q: Question|A: Answer"
$400,"Q: Question|A: Answer","Q: Question|A: Answer","Q: Question|A: Answer"
$500,"Q: Question|A: Answer","Q: Question|A: Answer","Q: Question|A: Answer"
DOUBLE JEOPARDY
Category1,Category2,Category3
$200,"Q: Different Question|A: Answer","Q: Different Question|A: Answer","Q: Different Question|A: Answer"
$400,"Q: Different Question|A: Answer","Q: Different Question|A: Answer","Q: Different Question|A: Answer"
$600,"Q: Different Question|A: Answer","Q: Different Question|A: Answer","Q: Different Question|A: Answer"
$800,"Q: Different Question|A: Answer","Q: Different Question|A: Answer","Q: Different Question|A: Answer"
$1000,"Q: Different Question|A: Answer","Q: Different Question|A: Answer","Q: Different Question|A: Answer"

Benefit: Separate, completely different questions for each round!

Migration Steps

If you have an old CSV file, here's how to convert it:

Step 1: Keep Your Jeopardy Questions

Copy your existing content as-is, this becomes the Jeopardy section.

Step 2: Create New Double Jeopardy Questions

Write completely new questions for the Double Jeopardy section with higher difficulty.

Step 3: Add the Separator

Between the two sections, add a line with: DOUBLE JEOPARDY

Step 4: Adjust Values

Jeopardy values stay: $100, $200, $300, $400, $500 Double Jeopardy values: $200, $400, $600, $800, $1000

Step 5: Test

Upload the new CSV and verify both rounds load correctly.

Detailed Example: Conversion Process

BEFORE (Old Format)

Science,History
$100,"Q: What is H2O?|A: Water","Q: Titanic year?|A: 1912"
$200,"Q: Gold symbol?|A: Au","Q: Columbus sailed?|A: 1492"

↓↓↓ CONVERT TO ↓↓↓

AFTER (New Format)

Science,History
$100,"Q: What is H2O?|A: Water","Q: Titanic year?|A: 1912"
$200,"Q: Gold symbol?|A: Au","Q: Columbus sailed?|A: 1492"
DOUBLE JEOPARDY
Science,History
$200,"Q: Speed of light?|A: 300000 km/s","Q: French Revolution?|A: 1789"
$400,"Q: Cell type: prokaryotic or?|A: Eukaryotic","Q: First Roman Emperor?|A: Augustus"

Question Sourcing Ideas

For Jeopardy Round:

  • Medium difficulty questions
  • Covers broad topics within each category
  • Progressive difficulty across the $100-$500 values

For Double Jeopardy Round:

  • Different categories or same categories with different topics
  • Higher difficulty (since values are higher)
  • Can be more specific or more challenging
  • Avoid reusing any answers from Jeopardy round

Quick Checklist

When creating your CSV file:

Jeopardy Section:

  • 5-6 categories listed
  • 5 value levels: $100, $200, $300, $400, $500
  • Each cell has "Q: ...|A: ..." format
  • All questions are unique

Separator:

  • Line with "DOUBLE JEOPARDY" (any case)

Double Jeopardy Section:

  • Same 5-6 categories (or different ones)
  • 5 value levels: $200, $400, $600, $800, $1000
  • Each cell has "Q: ...|A: ..." format
  • All questions are COMPLETELY DIFFERENT from Jeopardy
  • Questions aligned with higher difficulty/values

Format Rules

Question Format

All questions must follow this format in CSV cells:

"Q: Question text|A: Answer text"

Category Names

  • Separated by commas on first row
  • No quotes needed
  • Can have spaces

Values

  • Jeopardy: $100, $200, $300, $400, $500
  • Double Jeopardy: $200, $400, $600, $800, $1000
  • Must be in ascending order in CSV

Special Cases

  • To skip a category/value combo, use empty quotes: ""
  • Question text can be multiple sentences
  • Answers can be multi-word or phrases

Testing Your CSV

  1. Open the Jeopardy app
  2. Go to Setup page
  3. Upload your CSV
  4. The app will validate:
    • ✓ "DOUBLE JEOPARDY" separator exists
    • ✓ Jeopardy categories have questions
    • ✓ Double Jeopardy categories have questions
  5. Add players and start game
  6. Check that Jeopardy round shows your questions
  7. Complete Jeopardy round
  8. Click "Proceed to Double Jeopardy"
  9. Verify completely different questions appear

If CSV upload fails, error message will tell you what's wrong.

Sample Complete CSV

See example.csv in the project for a full working example with:

  • 5 categories (Science, History, Sports, Literature, Geography)
  • 5 questions per category in Jeopardy round
  • 5 different questions per category in Double Jeopardy round
  • All properly formatted and separated