Export¶
Export your print data for analysis, reporting, or backup purposes.
Export Options¶
Export Formats¶
| Format | Extension | Best For |
|---|---|---|
| CSV | .csv | Spreadsheets, data analysis, importing |
| Excel | .xlsx | Reports, formatting, charts |
Archive Export¶
Export your print archive data:
How to Export¶
- Go to Archives page
- Apply any desired filters
- Click Export button
- Choose format (CSV or Excel)
- Download begins
One Row per Print¶
An archive is a file, and each print of it is a run. The export has one row per print: the file's columns repeated on each, then that print's own. An archive printed before prints were logged keeps one row of its own fields; an archive never printed is one row with empty print columns.
| Column | From | Description |
|---|---|---|
| ID | File | The archive's ID |
| Print ID | The run's ID (empty for a print logged before runs) | |
| Print Name, Filename | File | Name and original 3MF file |
| Status | completed, failed, aborted, cancelled, or printing for a print running now | |
| Items Printed | Items the print produced | |
| Printer ID, Printer | The printer it ran on | |
| Plate | The plate it printed | |
| Project | File | Assigned project |
| Filament Type, Filament (g) | Material and grams used | |
| Print Time (s) | File | The slicer's estimate for the whole file |
| Layer Height, Nozzle, Bed Temp, Nozzle Temp, Total Layers | File | Slicer settings |
| Cost, Energy Cost, Wear Cost | What the print cost | |
| Designer, Tags, Notes | File | The file's description |
| Failure Reason, Outcome | Why it failed, and the good/reject verdict | |
| Duration (s) | How long it ran | |
| Started At, Completed At | When it ran (UTC, without an offset) | |
| Created At | File | When the archive was created |
Filter-Aware Export¶
Export respects your current filters:
- Printer filter, status filter and date range pick prints: those on that printer, with that outcome, started in that range. The Failed collection exports failed and aborted prints.
- Project filter and search query pick archives, with all their prints.
- A user limited to some printers gets only the prints that ran on theirs.
Statistics Export¶
Export statistics data:
How to Export¶
- Go to Statistics page
- Set your time range and filters
- Click Export button
- Choose format
- Download begins
Exported Data¶
| Data | Description |
|---|---|
| Summary stats | Total prints, success rate, etc. |
| Per-printer stats | Breakdown by printer |
| Material usage | Filament consumption |
| Cost breakdown | By printer, material |
| Time analysis | Duration statistics |
| Daily/weekly counts | Activity over time |
Export Settings¶
Date Format¶
Dates are exported in ISO 8601 format:
Number Format¶
- Decimals use period (.)
- No thousands separator
- Suitable for most spreadsheets
Text Encoding¶
- UTF-8 encoding
- Handles international characters
- Compatible with all modern software
Working with Excel¶
Opening CSV in Excel¶
- Open Excel
- Go to Data > From Text/CSV
- Select the downloaded file
- Choose UTF-8 encoding
- Click Load
Direct Open May Fail
Double-clicking CSV files may cause encoding issues. Use the import method above.
Creating Charts¶
- Select your data
- Go to Insert > Charts
- Choose chart type
- Customize as needed
Working with Google Sheets¶
Importing CSV¶
- Open Google Sheets
- Go to File > Import
- Upload the CSV file
- Choose Replace spreadsheet or Insert new sheet
- Click Import data
Direct Link (Advanced)¶
If you host Bambuddy publicly, you can link directly to export URLs.
API Export¶
Export via the REST API:
Archive Export¶
Parameters¶
| Parameter | Description |
|---|---|
format | csv or xlsx |
printer_id | Filter by printer |
project_id | Filter by project |
status | Filter by status (completed, failed, aborted, cancelled, printing) |
date_from | From this date (YYYY-MM-DD) or date and time (ISO) |
date_to | To this date, inclusive (YYYY-MM-DD), or date and time (ISO) |
tz | IANA time zone a plain date is a calendar day in; Bambuddy's own TZ when omitted or not a zone. A date and time without an offset is UTC |
search | Search query |
fields | Comma-separated columns to include |
Example¶
curl -H "X-API-Key: your-key" \
"http://localhost:8000/api/v1/archives/export?format=csv&status=completed" \
-o archives.csv
Scheduled Exports¶
For regular exports, set up a cron job:
# Weekly export every Sunday at midnight
0 0 * * 0 curl -H "X-API-Key: your-key" \
"http://localhost:8000/api/v1/archives/export?format=csv" \
-o "/backup/archives_$(date +\%Y\%m\%d).csv"
Backup Use¶
Export can serve as a partial backup:
What Export Captures¶
- Print metadata
- Statistics
- Tags and notes
What Export Doesn't Capture¶
- 3MF files
- Thumbnails
- Settings
- Notification configs
For full backups, use the Backup & Restore feature.
Tips¶
Regular Exports
Export monthly for record keeping, even if you have database backups.
Filter First
Apply filters before exporting to get exactly the data you need.
Version Control
Include dates in export filenames to track versions.
External Analysis
Export to CSV for analysis in Python, R, or other tools.
Reporting
Use Excel format for formatted reports with charts and branding.