Help needed importing rainfall data from csv file

[WessexWeather]

Hi All,

I have a csv file containing data from a Netatmo weather station, which logs data every five minutes. Everything works with the import except for rainfall.

The rainfall data appears to show the rainfall recorded in each five minute period, as all measurements are 0.117 or a multiple of, which I assume is recording each tip of the bucket. Totting up all these measurements for a given day equals the daily rainfall displayed within the Netatmo app.

My question is, how can I set this within the import settings, as this is showing neither cumulative daily rainfall or rain rate. I cannot choose mm/h, mm/min or mm/10 min...

Any help much appreciated.

[Jachym]

Hi,
the template import script can only work with cumulative rain so an option would be opening the CSV in an editor like MS Excel and create a new column, sum the daily values to create cumulative ones and then replace the original rain column with this one.

[WessexWeather]

Thanks Jachym, why didn’t I think of that?!