Database Import/Export Functionality #10

New Issue

2026-01-15T04:37:49Z

tonym commented

2026-01-15 04:37:49 +00:00

Summary

Add ability to export and import all Spoolman data for backup and database migration purposes.

Use Case

Migrate from PostgreSQL to SQLite (or vice versa)
Backup/restore data
Move between servers

Proposed Implementation

Export

API endpoint: GET /api/v1/backup/export
Returns JSON with all: vendors, filaments, spools, locations, settings, adjustments
Include all relationships and custom fields
Option to download as .json file from UI

Import

API endpoint: POST /api/v1/backup/import
Accepts JSON in same format as export
Options: merge vs replace
UI button in Settings page

Data Format

{
  "version": "1.0",
  "exported_at": "2026-01-14T...",
  "vendors": [...],
  "filaments": [...],
  "spools": [...],
  "locations": [...],
  "spool_adjustments": [...],
  "settings": [...]
}

Notes

Maintain referential integrity on import
Handle ID conflicts (remap or skip)
Progress indicator for large imports

Upstream References

https://github.com/Donkie/Spoolman/issues/303 (migration documentation)

## Summary Add ability to export and import all Spoolman data for backup and database migration purposes. ## Use Case - Migrate from PostgreSQL to SQLite (or vice versa) - Backup/restore data - Move between servers ## Proposed Implementation ### Export - API endpoint: `GET /api/v1/backup/export` - Returns JSON with all: vendors, filaments, spools, locations, settings, adjustments - Include all relationships and custom fields - Option to download as .json file from UI ### Import - API endpoint: `POST /api/v1/backup/import` - Accepts JSON in same format as export - Options: merge vs replace - UI button in Settings page ### Data Format ```json { "version": "1.0", "exported_at": "2026-01-14T...", "vendors": [...], "filaments": [...], "spools": [...], "locations": [...], "spool_adjustments": [...], "settings": [...] } ``` ## Notes - Maintain referential integrity on import - Handle ID conflicts (remap or skip) - Progress indicator for large imports ## Upstream References - https://github.com/Donkie/Spoolman/issues/303 (migration documentation)

tonym referenced this issue from a commit

2026-01-15 04:47:17 +00:00

feat: Add database import/export functionality (Issue #10)

tonym closed this issue

2026-01-15 04:47:22 +00:00

tonym referenced this issue from a commit

2026-01-15 04:50:08 +00:00

docs: Update CLAUDE.md with Issue #10 and Docker deployment notes

tonym referenced this issue

2026-01-16 04:52:26 +00:00

Reporting & Data Export #23

Sign in to join this conversation.