tonym/spoolman2
1
0
Fork 0
Code Issues 19 Pull Requests Actions Packages Projects Releases Wiki Activity

Reporting & Data Export #23

New Issue
Open
opened 2026-01-16 04:39:17 +00:00 by tonym · 0 comments
tonym commented 2026-01-16 04:39:17 +00:00
Owner
Copy Link
Copy Source

Summary

Add reporting and data export/import capabilities for inventory management.

Upstream Issues

Requested Reports

1. Filaments Without Spools

List filaments that have no associated spools (unused/depleted types).

2. Filaments by Manufacturer

Grouped list of all filaments organized by vendor/manufacturer.

3. Filaments by Material

Grouped list organized by material type (PLA, PETG, etc.).

4. Full Spool Inventory

Exportable list of all spools with key details:

  • Name, material, color
  • Remaining weight/length
  • Location
  • Last used date

5. Low Stock Report

Spools below configurable threshold (e.g., < 100g).

6. Location Inventory

Filament inventory grouped by storage location.

Export Formats

  • CSV (spreadsheet compatible) - for Excel/Google Sheets editing
  • PDF (printable)
  • JSON (API/backup) - already done in #10

CSV Import (Bulk Data Entry)

  • Import spools from CSV/Excel
  • Match columns to fields
  • Preview before import
  • Handle duplicates (skip/update/create new)
  • Great for users migrating from spreadsheets

Implementation

Backend

  • Add /api/v1/reports/{report_type} endpoints
  • Support format query param (?format=csv)
  • Add /api/v1/spool/import-csv endpoint
  • Use existing query filters

Frontend

  • Reports page/section
  • Report type selector
  • Filter options
  • Download buttons for each format
  • CSV import wizard with column mapping

Related

  • #10 Database Import/Export (JSON backup - DONE)
## Summary Add reporting and data export/import capabilities for inventory management. ## Upstream Issues - https://github.com/Donkie/Spoolman/issues/779 - Reporting - https://github.com/Donkie/Spoolman/issues/566 (3 👍) - CSV import/export ## Requested Reports ### 1. Filaments Without Spools List filaments that have no associated spools (unused/depleted types). ### 2. Filaments by Manufacturer Grouped list of all filaments organized by vendor/manufacturer. ### 3. Filaments by Material Grouped list organized by material type (PLA, PETG, etc.). ### 4. Full Spool Inventory Exportable list of all spools with key details: - Name, material, color - Remaining weight/length - Location - Last used date ### 5. Low Stock Report Spools below configurable threshold (e.g., < 100g). ### 6. Location Inventory Filament inventory grouped by storage location. ## Export Formats - **CSV** (spreadsheet compatible) - for Excel/Google Sheets editing - **PDF** (printable) - **JSON** (API/backup) - already done in #10 ## CSV Import (Bulk Data Entry) - Import spools from CSV/Excel - Match columns to fields - Preview before import - Handle duplicates (skip/update/create new) - Great for users migrating from spreadsheets ## Implementation ### Backend - Add `/api/v1/reports/{report_type}` endpoints - Support format query param (`?format=csv`) - Add `/api/v1/spool/import-csv` endpoint - Use existing query filters ### Frontend - Reports page/section - Report type selector - Filter options - Download buttons for each format - CSV import wizard with column mapping ## Related - #10 Database Import/Export (JSON backup - DONE)
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
tonym (Tony Moon)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: tonym/spoolman2#23