The EDI-Net system gets data via data files. It can receive files either by manual or automated upload or by downloading them automatically from an external system.
Data files can come in many shapes and sizes. EDI-Net is designed to work with your data format. We can easily develop customised data adapters for most sensible file formats. We generally prefer human-readable formats such as csv and json. An example csv file format is shown below.
The file contains three key elements which are absolutely essential.
- A timestamp (e.g. 01-03-2016 01:00)
- A unique identifier (486020677320) indicating to which dataset the data belong
- A value, in this case the format always includes kWh values.
There are other things a file may want to include. For example, the units may be specified in some kind of header or as an extra column. The type of commodity being measured e.g. gas, water, electricity etc. may also be included. In the case of the file format above, these aspects are either fixed (i.e. the same for every file) or are missing and need to be applied manually in a post-processing step using the user interface. In either case, an assumption must be made about the units and commodity.
We are very happy to work with your format. Send us an example file and we will do our best to work with it.