I am looking into doing something with the csv download on the melcloud, main idea is some minute by minute monitoring for a server. my ecodan has stopped updating its data since a firmware update in 2022, resulting in me having to pay back the monitoring mmsp part of my heatpump, apparently i should of noticed. can anyone supply a part of the csv file, im particularly interested in the format of each heading and the different operational modes (i believe there are only 3 Stop HotWater and Heating) want to make something that pings a notice up if your unit stops reporting data. If someone has allready done this can they supply a link.
Hi Darren, welcome to the forum!
The CSV energy report contains raw minute-by-minute data for selected parameters for your device in comma separated variable format. This file will be 30-40Mb in size, and may take several minutes to generate and download. It is intended to be imported into a spreadsheet for further processing rather than read directly as a report.
Fields returned: TimeStamp, RoomTemperatureZone1, RoomTemperatureZone2, OutdoorTemperature, FlowTemperature, EnergyConsumed, EnergyProduced, OperatingMode
Energy is in Wh, multiply by 60 to get power (W). Expect to be processing around 525,600 rows.
OperatingMode can be one of: Stop, HotWater, Heating, FreezeStat, LegionellaPrevention.
Note that the csv is very big, and not really suitable for constant monitoring. There are alternate methods that can work better, depending on how much programming you want to do, as well as monitoring via 3rd part dongles and HomeAssistant.
- Daily extract of MELCLOUD data for ECODAN
- Preparing to monitor a new Mitsubishi Ecodan
- WiFi + MQTT dongle for Mitsubishi Ecodan
- Monitoring & Controlling Ecodan via CN105 (long)
I can also provide real-time monitoring for you; message me for details.
Hope that helps.
That’s a great help Ty the wh readings on the data I could extract are to 3 decimal places (nothing this wasn’t from the CSV but from other reports. Id expect these are in kWh so I just need to multiply these by 1000 to get wh. Then like you said x60 to get watts been drawn. Interesting that there’s freeze and legionella cycles. I could see them in past reports but in an old csv I just had heating and hot water and stop. Wonder if it defaults to these if it’s doing them already. Assuming the wh values are minute by minute and not cumulative. Might scale this part down to a monthly review or something as like you said it’s too big to work with realistically. But still curious. Thankyou for the links I will have a look later today had a quick look and they might do what I need anyway with just a few tweaks. Much appreciated the response.