how to retrieve load profile data to the database

searventz · ‎2024-10-22

I have a PowerlogicION8600, I use ION to retrieve load profile data on a report that is exported to CSV. Then I have a need to save it to a database. How do I retrieve load profile data, especially "kwh del int" in real time every 30 minutes (as in the load profile report) which will be saved to an external database. Because there is no modbus register, and if you add the register tag, it will delete all its data.

Charles_Murison · ‎2024-10-23

Hello @searventz ,

One of the many benefits of ION meters is the ability to add customizations. If you want to get interval energy readings like "kWh del int" via modbus, it is possible to add modbus slave module and link the outputs of specific integrator modules to inputs of the Modbus slave module. Then in the setup registers for the modbus slave module you would select the desired format of the registers as well as the starting register. After changes are sent to the meter, you can now read kwh del int values via modbus.

One item to note is that interval energy readings will reset at the end of each interval, it can be tricky to catch the reading so close to the end. One suggestion would be to use a store module that can keep the kwh Del for the previous interval. At the end of an interval, have the store module update kwh reading before the integrator is reset. Then link the output of the store module to modbus slave module. What you would then read via modbus is the kwh for the last interval.

Regards,

Charles

L4 Prime for Advanced metering and Utilities

See Answer In Context

Charles_Murison · ‎2024-10-23

Hello @searventz ,

One of the many benefits of ION meters is the ability to add customizations. If you want to get interval energy readings like "kWh del int" via modbus, it is possible to add modbus slave module and link the outputs of specific integrator modules to inputs of the Modbus slave module. Then in the setup registers for the modbus slave module you would select the desired format of the registers as well as the starting register. After changes are sent to the meter, you can now read kwh del int values via modbus.

One item to note is that interval energy readings will reset at the end of each interval, it can be tricky to catch the reading so close to the end. One suggestion would be to use a store module that can keep the kwh Del for the previous interval. At the end of an interval, have the store module update kwh reading before the integrator is reset. Then link the output of the store module to modbus slave module. What you would then read via modbus is the kwh for the last interval.

Regards,

Charles

L4 Prime for Advanced metering and Utilities

searventz · ‎2024-10-24

Hello @Charles_Murison ,

Thank you for your answer. I will try it later because I am still learning the function of the modules. But is there any other way besides using modbus?

Charles_Murison · ‎2024-10-25

Hello @searventz ,

For real time communications to your ION8600 meter, your options are ION, modbus, DNP3. Note that ION8600 meters are considered obsolete so there is limited options.

Regards,

Charles

L4 Prime for Advanced metering and Utilities

searventz · ‎2024-10-27

Hello @Charles_Murison

sorry, apparently I saw it wrong. the correct type is PowerLogic8650. Is it the same?

Charles_Murison · ‎2024-10-28

Hello @searventz ,

The ION8650 meter is supported. The answer to what real time communication options are available does not change.

Regards,

Charles

L4 Prime for Advanced metering and Utilities