Introduction
The TWAICE SFTP Server offers a secure and reliable way for customers to transfer large volumes of time-series data directly into the TWAICE Cloud. Built on AWS Transfer Family, this method ensures encrypted and efficient uploads, supporting a smooth integration into TWAICE’s Energy Analytics cloud platform.
By using the SFTP method, you can easily ingest CSV-based battery data at scale—enabling deeper insights into performance, state-of-health, and safety.
This document provides a step-by-step guide on accessing and using the TWAICE SFTP Server for data ingestion, starting with data requirements followed by connection setup.
Data Format Requirements
To ensure smooth processing and compatibility with our systems, your data must meet the following formatting standards:
File type: CSV only
Only long format is supported
Delimiter: Semicolon (
;)Header:
timestamp;metric;valueTimestamp: Must follow the ISO 8601 UTC format:
Example:
2022-03-07T13:00:00.000Z
Metric: A human-readable, unique identifier, defined during your onboarding setup
Value: A floating-point number using a dot as the decimal separator
Example:
4000.20
Note: The file size must be below 200MB to ensure fast data processing. To reduce file size, CSV files can be compressed using GZIP before transferring them.
Uploading Files to the SFTP Server
You can upload your data using standard SFTP clients (like FileZilla) or programmatically via scripting tools such as Python, Bash, or PowerShell.
Connection Details
SFTP Host:
sftp-v2.twaice.cloudPort:
2222or443Username: Your registered email address
Password: Set by the customer
Once connected, you’ll have access to your dedicated directory on the TWAICE server. From there, simply drag and drop or script your uploads.
File Structure Example
Here’s a sample view of the expected data:
timestamp;metric;value
2025-01-01T01:07:43.000Z;string:01:voltage;225.3
2025-01-01T01:07:43.000Z;string:02:voltage;225.4
2025-01-01T01:07:43.000Z;string:03:voltage;225.9
2025-01-01T01:07:43.000Z;string:01:current;0.0
2025-01-01T01:07:43.000Z;string:02:current;0.0
2025-01-01T01:07:43.000Z;string:03:current;0.0
2025-01-01T01:07:45.000Z;string:01:voltage;225.3
2025-01-01T01:07:45.000Z;string:02:voltage;225.4
2025-01-01T01:07:45.000Z;string:03:voltage;225.9
Make sure all rows follow the same structure and format, and double-check timestamps and metric identifiers for accuracy.
Need Help?
If you run into any issues or have questions, don’t hesitate to reach out to your TWAICE contact or support@twaice.com.