#80 Totalize meter production volumes

[Maher Abdel Karim]

The data transferred from automated loggers needs to be totalized as the loggers are sending the information by sms and contains only the net production.
The BMFO is dealing with this information like a clockover events.

[Steffen Macke]

Logged In: YES
user_id=30248
Originator: NO

Latest state of discussion with Horizons:

Loggers are unable to totalize, therefore flow rates have to be used in a regular interval.
The totalizing can be done using a specially crafted insert statement with sub-select:

Instead of the usual "insert reading into operationsrecord" try something like
"insert flowrate*period + (select last reading) into operationsrecord"

An elaborated insert statement was communicated to Horizons before.

This allows to deal with the issue without changing anything in BMFO.

Let me know if you need more information. I suggest to document the proceedings
in this tracker item.