- Separate measurement files
- Manual data reconciliation
- Missing data detected late
- E-mail error handling
Energy measurement-data case study
Sample project for automatic collection of production and consumption data.
01 / STARTING POSITION
The operating situation that can be automated
The measurement files arrived from several sources at different times. Absences and unusual values were checked manually.
- Scheduled collection of source data
- Format and completeness check
- Rule-based indication of anomalies
- Exception handling with a designated expert
It is unifiedmeasurement data stream
Earliervisible data errors
Checkedexception handling
02 / SYSTEM CONNECTIONS
Automation working between existing devices
The following are examples, not a closed list. Robots can also work between legacy and unique systems with API, webhook, database connection or controlled file transfer. The process can be fully automatic or, where necessary, supervised by human control points.
Measurement data sourceExcelSFTPERPEmailMicrosoft 365Google WorkspaceExcel / Google SheetsSharePoint / Google DriveTeams / SlackREST API / WebhookSFTP/CSVSQL databaseUnique internal system
Are you using a different system? We can also include it in the process with a unique API, import-export connection or robotic handling.
Illustrative, anonymized sample project. The actual result can be determined after assessing the process, data and systems.
Our measurement methodology →Free automation test
Show a problematic process. We look at whether it can be automated, what systems need to be connected, and how to get started.