Advanced CSV Data Management (Export & Import)

[vivjd]

Goal:
Implement robust data portability and legacy migration tools to ensure MADE can use its data flexibly.

Tasks:

• Create Export API to accept query parameters (start_date, end_date, box_id, record_type). If Export API is not present, create one accordingly.
• Build an "Export" modal in the Admin Dashboard with a Date Range Picker and dropdown filters.
• Develop a CSV Import utility for the "Museum Inventory" data.
• Implement mapping logic:
  • Software: "Game Title" -> "Title", "System" -> "Platform".
  • Hardware: "Name" -> "Title", "Email" -> "Cataloger".
  • More details can be found on Notion.

Acceptance Criteria:

• Users can generate reports based on specific time ranges, boxes, or categories.
• Import utility successfully parses legacy inventory rows into the new schema without data loss.
• All imported records are automatically flagged as needs_review.

Note
This main difficult with this issue lies within the import functionality, which may require a bit more thinking. Please consult @vivjd or @qiuethan about this if you need help!