Import Consumption Measurement

Consumption Measurement are subject to property building or group and it is highly recommended that consumptions are imported in a separate sheet, where they are tied to a building or group by the corresponding ID. Certain headers are mandatory in order to import a consumption, but additional details can also be imported by optional headers.

Mandatory headers

Column title	Description	Allowed values
Entity ID	An entity ID of the corresponding entity type subject to the cunsumption	String
Entity Type	Type of entity	PROPERTY_BUILDING, PROPERTY_GROUP
Consumption type	Type of Consumption	electricity consumption, heating consumption, cooling consumption, water consumption
Consumption value	Monthly consumption in kWh	Number
Measurement date	Starting date of the lease	Date* Format: 2019-12-24

* Attempting to import date values if alignment is left it will cause fail. Edit date formatting such that alignment is on the right side.

Support

Import Consumption Measurement

Analytics

Mandatory headers

Related content