{% extends "base.html" %} {% block title %} » DC Contracts » {{contract.name}} » HH Data Imports {% endblock %} {% block nav %} DC Contracts » {{contract.name}} » HH Data Imports {% endblock %} {% block content %}

Import HH data

Valid file name extensions are {{parser_names}}.

HH Data Formats

Below are all the HH data formats accepted by Chellow. Chellow recognizes them by their filename extension. The files may be compressed as zip files.

CSV Simple

File extension .simple.csv. A CSV file with the following columns:

Name Description
MPAN Core
Channel Type 'ACTIVE', 'REACTIVE_IMP' or 'REACTIVE_EXP'
Time Half-hour starting yyyy-MM-dd hh:mm
Value
Status 'A' - actual, 'E' - estimate, 'C' - padding.

Here's an example:

MPAN core, Channel Type, Time, Value, Status
99 9999 9999 999, ACTIVE, 2006-01-01 00:30, 218.4 , E
99 9999 9999 999, ACTIVE, 2006-01-01 01:00, 220.4 , E
99 9999 9999 999, ACTIVE, 2006-01-01 01:30, 221.8 , E
99 9999 9999 999, ACTIVE, 2006-01-01 02:00, 223.4 , E
99 9999 9999 999, ACTIVE, 2006-01-01 02:30, 224.6 , E
99 9999 9999 999, ACTIVE, 2006-01-01 03:00, 226.8 , E
99 9999 9999 999, ACTIVE, 2006-01-01 03:30, 203.8 , E
99 9999 9999 999, ACTIVE, 2006-01-01 04:00, 155.2 , E
99 9999 9999 999, ACTIVE, 2006-01-01 04:30, 169.0 , E
99 9999 9999 999, ACTIVE, 2006-01-01 05:00, 171.0 , E
			

Stark DF2

File extension .df2. The data file is of the form:

    
#F2
#O 99 9999 9999 999
#S 2
27/07/05,00:30,95.4,A
27/07/05,01:00,93.8,A
27/07/05,01:30,91.9,A
			
Values Of The Sensor Number S
Number Meaning
1 Import kWh
2 Export kWh
3 Import kVArh
4 Export kVArh

and the status character on the end is optional. For the newer six-channel meters the channels are mapped to the DF2 format as follows:

Six channel meters in DF2 format
Import Related Export Related
Active kWh #O mpan_core
#S 1
#O mpan_core
#S 2
Reactive Import kVArh #O import_mpan_core
#S 3
#O export_mpan_core
#S 3
Reactive Export kVArh #O import_mpan_core
#S 4
#O export_mpan_core
#S 4

bGlobal CSV

File extension .bg.csv. A CSV file with the following columns:

Name Description
MPAN core
Meter Serial Number
Date dd/MM/yy
HH 1 kWh in 1st HH
HH 2 kWh in 2nd HH
HH 3 kWh in 3rd HH
... ...
HH 48 kWh in 48th HH

Here's an example:

9999999999999,E04M00872,06/07/2008,0.262,0.26,0.252,0.246,0.249,0.251,0.25,0.249,0.244,0.239,0.255,0.255,0.286,0.289,0.356,0.489,0.576,0.585,0.496,0.411,0.457,0.463,0.436,0.447,0.436,0.431,0.439,0.396,0.455,0.453,0.377,0.314,0.341,0.338,0.418,0.45,0.446,0.442,0.464,0.366,0.314,0.386,0.395,0.444,0.346,0.288,0.263,0.255,0,0
9999999999999,E04M00872,07/07/2008,0.247,0.216,0.211,0.227,0.237,0.233,0.229,0.204,0.225,0.267,0.301,0.324,0.466,0.471,0.475,0.546,0.505,0.382,0.362,0.434,0.387,0.395,0.35,0.378,0.348,0.356,0.301,0.34,0.337,0.396,0.386,0.388,0.369,0.325,0.356,0.36,0.367,0.429,0.427,0.466,0.404,0.403,0.319,0.359,0.299,0.294,0.264,0.29,0,0
9999999999999,E04M00872,08/07/2008,0.312,0.31,0.254,0.237,0.222,0.226,0.218,0.211,0.225,0.263,0. 262,0.283,0.423,0.495,0.561,0.569,0.496,0.41,0.381,0.355,0.323,0.366,0.4,0.363,0.381,0.396, 0.392,0.369,0.317,0.301,0.378,0.311,0.391,0.345,0.344,0.382,0.436,0.384,0.353,0.34,0.335,0.352,0.388,0.394,0.389,0.346,0.284,0.258,0,0
9999999999999,E04M00872,09/07/2008,0.246,0.246,0.257,0.266,0.251,0.24,0.229,0.236,0.232,0.245,0.268,0.289,0.424,0.46, 0.513,0.481,0.459,0.441,0.368,0.348,0.401,0.403,0.413,0.412,0.371,0.396,0.381,0.321,0.321,0.276,0.303,0.311,0.348,0.33,0.381,0.398,0.372,0.38,0.322,0.342,0.349,0.331,0.439,0.41,0.368,0.326,0.274,0.257,0,0
9999999999999,E04M00872,10/07/2008,0.247,0.247,0.242,0.251,0.243,0.254,0.25,0.243,0.245,0.246,0.252,0.336,0.378,0.49,0.443, 0.467,0.544,0.467,0.375,0.387,0.403,0.347,0.415,0.404,0.422,0.42,0.375,0.385,0.371, 0.371,0.359,0.397,0.402,0.384,0.393,0.389,0.365,0.381,0.498,0.402,0.355,0.326,0.311,0.31,0.342,0.274,0.293,0.313,0,0
9999999999999,E04M00872,11/07/2008,0.303,0.303,0.277,0.244,0.254,0.24,0.249,0.256,0.318,0.318,0.305, 0.299,0.421,0.529,0.547,0.452,0.458,0.423,0.433,0.377,0.344,0.401,0.417,0.392,0.364,0.373,0.367,0.376,0.387,0.378,0.521,0.525,0.413,0.42,0.377,0.42,0.367,0.371,0.336,0.341,0.336,0.4,0.413,0.401,0.407,0.376,0.353,0.338,0,0
9999999999999,E04M00872,12/07/2008,0.324,0.319,0.31,0.31,0.312,0.282,0.232,0.244,0.246,0.252,0.268,0.286,0.329, 0.378,0.547,0.444,0.447,0.535,0.631,0.556,0.473,0.503,0.47,0.402,0.419,0.443,0.442, 0.409,0.378,0.366,0.384,0.392,0.403,0.406,0.481,0.541,0.486,0.405,0.366,0.364, 0.364,0.43,0.436,0.386,0.402,0.322,0.279,0.291,0,0
9999999999999,E04M00872,13/07/2008,0.268,0.272,0.261,0.25,0.311,0.306,0.267,0.259,0.26,0.3,0.333,0.326,0.362, 0.37,0.448,0.458,0.567,0.664,0.781,0.609,0.529,0.566,0.464,0.366,0.388,0.423,0.357,0.41, 0.352,0.357,0.486,0.547,0.52,0.516,0.558,0.639,0.607,0.65,0.637,0.483,0.457,0.51,0.444,0.422,0.442,0.4,0.314,0.347,0,0
9999999999999,E04M00872,14/07/2008,0.32,0.344,0.261,0.304,0.309,0.239,0.302,0.312,0.26,0.334,0.265,0.444,0.488, 0.552,0.543,0.58,0.599,0.501,0.497,0.48,0.334,0.376,0.409,0.405,0.314,0.303, 0.329,0.369,0.299,0.436,0.48,0.527,0.499,0.549,0.37,0.373,0.347,0.339,0.348, 0.412,0.425,0.385,0.423,0.376,0.373,0.353,0.281,0.27,0,0
9999999999999,E04M00872,15/07/2008,0.314,0.309,0.298,0.29,0.291,0.236,0.244,0.24,0.239,0.246,0.265,0.308, 0.414,0.428,0.504,0.527,0.472,0.35,0.483,0.485,0.543,0.519,0.45,0.345,0.347, 0.375,0.455,0.509,0.498,0.469,0.304,0.329,0.413,0.397,0.445,0.534,0.506,0.405, 0.447,0.422,0.48,0.42,0.431,0.418,0.387,0.365,0.281,0.263,0,0
9999999999999,E04M00872,16/07/2008,0.279,0.313,0.316,0.314,0.311,0.311,0.303,0.287,0.239,0.261,0.269, 0.342,0.446,0.491,0.445,0.556,0.503,0.463,0.412,0.407,0.472,0.445,0.417,0.394, 0.391,0.368,0.403,0.384,0.37,0.316,0.39,0.353,0.442,0.424,0.555,0.477,0.525, 0.476,0.39,0.464,0.465,0.399,0.427,0.432,0.428,0.371,0.333,0.269,0,0
			
{% if processes|length > 0 %} {% endif %}
{% endblock %}