app.get("/api/export", hasRole(["PARENT", "ADMIN"]), asyncHandler(async (req: AuthRequest, res) => {
  if (!req.user) {
    return res.status(401).json({ error: "Unauthorized" });
  }

  if (!req.query.learnerId) {
    return res.status(400).json({ error: "learnerId is required" });
  }

  const learnerId = req.query.learnerId as string;

  // Verify parent has access to this learner
  if (req.user.role === "PARENT") {
    const children = await storage.getUsersByParentId(req.user.id);
    if (!children.some(child => child.id.toString() === learnerId.toString())) {
      return res.status(403).json({ error: "Forbidden" });
    }
  }

  // Get all the learner data
  const [learner, profile, lessons, achievements] = await Promise.all([
    storage.getUser(learnerId),
    storage.getLearnerProfile(learnerId),
    storage.getLessonHistory(learnerId, 1000), // Get a large number of lessons
    storage.getAchievements(learnerId)
  ]);

  if (!learner) {
    res.status(404).json({ error: "Learner not found" });
  }

  // Remove sensitive information
  const { password: _, ...learnerData } = learner;

  // Set filename for download
  const filename = `learner-data-${learnerId}-${new Date().toISOString().split('T')[0]}.json`;
  res.setHeader('Content-Disposition', `attachment; filename="${filename}"`);
  res.setHeader('Content-Type', 'application/json');

  // Return combined data
  res.json({
    learner: learnerData,
    profile,
    lessons,
    achievements,
    exportDate: new Date().toISOString(),
    exportedBy: req.user.id
  });
}));

<TouchableOpacity
  style={[styles.actionButton, styles.exportButton]}
  onPress={() => {
    // Open export endpoint in new window for download
    window.open(`/api/export?learnerId=${item.id}`, '_blank');
  }}
>
  <Download size={16} color={colors.onPrimary} />
  <Text style={styles.actionButtonText}>Export</Text>
</TouchableOpacity>

const handleDownloadReport = () => {
  if (!selectedLearnerId) return;
  window.open(`/api/export?learnerId=${selectedLearnerId}`, '_blank');
};

<TouchableOpacity 
  style={styles.downloadButton}
  onPress={handleDownloadReport}
>
  <Download size={16} color={colors.onPrimary} />
  <Text style={styles.downloadButtonText}>Download Full Report</Text>
</TouchableOpacity>

{
  "learner": {
    "id": 123,
    "username": "child_username",
    "email": "child@example.com",
    "name": "Child Name",
    "role": "LEARNER",
    "parentId": 456,
    "createdAt": "2026-01-15T10:30:00.000Z",
    "updatedAt": "2026-03-12T14:22:00.000Z"
  },
  "profile": {
    "userId": 123,
    "gradeLevel": 5,
    "subjects": ["Math", "Reading", "Science"],
    "recommendedSubjects": ["History"],
    "strugglingAreas": [],
    "graph": {
      "nodes": [
        { "id": "math", "label": "Mathematics" },
        { "id": "algebra", "label": "Algebra" }
      ],
      "edges": [
        { "source": "math", "target": "algebra" }
      ]
    },
    "preferences": {},
    "createdAt": "2026-01-15T10:30:00.000Z",
    "updatedAt": "2026-03-10T09:15:00.000Z"
  },
  "lessons": [
    {
      "id": "lesson-789",
      "userId": 123,
      "subject": "Math",
      "topic": "Fractions",
      "gradeLevel": 5,
      "status": "DONE",
      "score": 85,
      "spec": {
        "title": "Introduction to Fractions",
        "sections": [...]
      },
      "createdAt": "2026-03-10T15:00:00.000Z",
      "completedAt": "2026-03-10T15:45:00.000Z"
    }
  ],
  "achievements": [
    {
      "id": "achievement-101",
      "userId": 123,
      "type": "first_lesson_complete",
      "payload": {
        "title": "First Lesson Complete!",
        "description": "You finished your first lesson"
      },
      "awardedAt": "2026-03-10T15:45:00.000Z"
    }
  ],
  "exportDate": "2026-03-12T16:30:00.000Z",
  "exportedBy": 456
}

storage.getLessonHistory(learnerId, 1000)

import json
import pandas as pd

# Load export file
with open('learner-data-123-2026-03-12.json', 'r') as f:
    data = json.load(f)

# Convert lessons to DataFrame
lessons_df = pd.DataFrame(data['lessons'])

# Analyze performance
avg_score = lessons_df['score'].mean()
subject_performance = lessons_df.groupby('subject')['score'].mean()

print(f"Average Score: {avg_score:.1f}%")
print("\nPerformance by Subject:")
print(subject_performance)

// Read export file (Node.js)
const fs = require('fs');
const data = JSON.parse(fs.readFileSync('learner-data-123-2026-03-12.json', 'utf8'));

// Calculate statistics
const lessons = data.lessons;
const completedLessons = lessons.filter(l => l.status === 'DONE');
const avgScore = completedLessons.reduce((sum, l) => sum + l.score, 0) / completedLessons.length;

console.log(`Completed Lessons: ${completedLessons.length}`);
console.log(`Average Score: ${avgScore.toFixed(1)}%`);

// Group by subject
const bySubject = completedLessons.reduce((acc, lesson) => {
  if (!acc[lesson.subject]) acc[lesson.subject] = [];
  acc[lesson.subject].push(lesson.score);
  return acc;
}, {});

for (const [subject, scores] of Object.entries(bySubject)) {
  const avg = scores.reduce((a, b) => a + b, 0) / scores.length;
  console.log(`${subject}: ${avg.toFixed(1)}% (${scores.length} lessons)`);
}