Export Center

The Export Center lets you export data from databases and charts in Excel (XLSX) or CSV format. You can run one-off exports, create reusable Excel templates with custom formatting, and set up scheduled reports that deliver data automatically via email or webhook.

The Export Center is organized into three tabs:

Opening the Export Center

1. Navigate to Observe → Value History or Inventory → Databases
2. Select the database or chart you want to export
3. Click "Export Center" in the toolbar

Exports

The Exports tab lists all export jobs — queued, in progress, completed, failed, or canceled.

Creating an Export

1. Click "New Export"
2. Choose format — Select Excel (XLSX) or CSV

3. Configure settings — Depending on the format:
   • XLSX: Select a template to apply formatting and layout, and choose the time granularity and date

• CSV: Choose separator (comma, semicolon, or tab), decimal separator (dot or comma), and text identifier settings

4. Select fields — Check which columns to include, drag to reorder, and choose a date format for timestamp fields

5. Confirm — The export job is created and appears in the Exports tab

Available Date Formats

When selecting fields, you can choose the date format for timestamp columns:

Export Status

Managing Exports

• Download — Available for completed exports
• Cancel — Available for queued or in-progress exports
• Delete — Available for completed, failed, or canceled exports

Use the filter bar to narrow the list by status, format (XLSX or CSV), or tags.

Templates

Templates are reusable Excel files that define the layout, formatting, and structure of your exports. When you export data as XLSX, the system fills the template's data sheet with your exported data, preserving any custom sheets, formulas, and charts you added.

How Templates Work

Every template contains a special ExoData sheet:

• Row 1 contains the column headers
• Row 2 contains internal column IDs (do not modify)
• Row 3 onward is filled with your data during export

You can add additional sheets with custom formatting, formulas, and charts that reference the ExoData sheet. The export engine fills the data and your custom sheets update automatically.

Downloading a Base Template

1. Open the Templates tab
2. Click "Download Base Template"
3. An Excel file with the ExoData sheet structure is downloaded

Use this file as your starting point. Add custom sheets, charts, and formulas, then upload it back as a template.

Uploading a Template

1. Open the Templates tab
2. Click "Upload Template"
3. Select a .xlsx file from your computer
4. Enter a name and optional description
5. Click Save

The template is now available for selection when creating XLSX exports.

Managing Templates

Schedules

Schedules automate recurring exports for databases. On a defined interval, the system generates an export and delivers it via email or webhook.

Schedule Types

Creating a Schedule

1. Open the Schedules tab
2. Click "New Schedule"

3. Configure the schedule:
   • Interval — Daily, Weekly, Monthly, Quarterly, or Yearly
   • Output format — CSV only, XLSX only, or both
   • Delivery method — Email recipients or webhook URL
   • Time range — The data period to export each time
4. Click Save

Managing Schedules

Schedule Limits

Webhook Payload Format

When using webhook delivery, the system sends a JSON payload via HTTP POST:

{
    "metadata": {
        "source": {
            "id": "db-12345",
            "name": "Energy Database",
            "info": {
                "table_id": "0",
                "schema": [
                    {
                        "id": "energy_consumed",
                        "label": "Energy Consumed",
                        "type": "number",
                        "format": "<v.2> kWh"
                    }
                ]
            }
        },
        "content_config": {
            "fields": ["energy_consumed", "device_temperature"],
            "start_date": "2025-01-15T00:00:00Z",
            "end_date": "2025-01-21T23:59:59Z"
        },
        "generatedAt": "2025-01-22T08:00:00Z",
        "recordCount": 168
    },
    "data": [
        {
            "timestamp": "2025-01-15T00:00:00Z",
            "type": "wallbox_session",
            "device_displayname": "Wallbox Garage",
            "session_start": "2025-01-15T00:00:00Z",
            "session_end": "2025-01-15T02:30:00Z",
            "dynamic_fields": {
                "energy_consumed": 45.8,
                "device_temperature": 22.5
            }
        }
    ]
}

Troubleshooting

For common export issues, see the Troubleshooting Guide.

Related Documentation

• Databases — Create data sources for exports
• Export Database Data — Export database records from the database detail page
• Value History — View measurement data before exporting
• Charts — Export chart data
• License Plans — Export and schedule limits by license
• User Permissions — Who can create exports and schedules