What are the data import methods and when should I use each?
Analytics → Data Import offers four methods to get meter data into the system. Pick the method card at the top of the page, then fill in the form that appears below it. Choose based on how your data source can deliver data:
1. Manual File Upload
Best for: One-time historical data loads, periodic manual uploads
How: Analytics → Data Import → Manual File Upload → drop the file → the system detects timestamps, meter identifiers, values and units
Supports: CSV, Excel and JSON files up to 10 MB. The same card also has a "Meter List" mode for registering many meters at once from a list file — see "How do I register many meters at once from a file?"
2. Automated Email Reports
Best for: Automated vendor reports that arrive via email (e.g., monthly energy reports)
How: Forward the vendor's automated report email to your dedicated import address
The system parses the CSV attachment and imports the data automatically
3. Instant API Sync
Best for: Connecting to vendor cloud platforms that offer an API (e.g., Kamstrup, Schneider Electric EcoStruxure)
How: Analytics → Data Import → Instant API Sync → provide the vendor's Swagger/OpenAPI specification
The system uses AI to analyze the API spec and configure automatic data fetching on a schedule you choose
4. Real-Time Push (Webhook)
Best for: Real-time data from BMS (Building Management Systems), IoT gateways and custom integrations that can push data
How: Analytics → Data Import → Real-Time Push → get your unique endpoint URL and signing secret → configure your system to POST data to it
Data arrives as it is generated
Which to choose?
- If you have historical data files → Manual File Upload
- If your vendor sends automated email reports → Automated Email Reports
- If the vendor has a cloud API → Instant API Sync
- If your BMS/gateway can push data → Real-Time Push (Webhook)
What about MQTT? There is no MQTT option in the import picker — you cannot give the platform a broker address and a topic. If your sensors publish to MQTT, run a small bridge (Node-RED, a gateway script, or the gateway's own HTTP output) that subscribes to the topic and POSTs the readings to a webhook data source instead.
First step for any device integration: Contact your device vendor and ask what data export options they support. Then match their capability to one of these four methods.