Posting to a 3rd party server

[phuz]

I just got this working, and while it's cool, my postings are reporting "Last Value" and not the wattage.  This is great but I don't know how to reverse engineer the Last value into useable data.
Ideas?

[ThermoMan]

I did a thing where I subtract the previous value from the current value and that gives a delta (usage) per minute.

This is the SQL (for MySQL) that I used in my PHP code

SELECT date, (watts*60)-@last_watt AS delta, @last_watt := watts*60 AS dummy
FROM elec__elec_usage 
WHERE date >= (SELECT DATE(MAX(date)) from elec__elec_usage) - INTERVAL 10 DAY
                /* This WHERE clause finds the usage for May 28, 2013 */
WHERE DATE_FORMAT( date, '%Y-%m-%d' ) = '2013-05-28'
ORDER BY 1

The *60 factor is because the main number is in watt hours and I want watt minutes in my chart.

[jimmerto]

"The TED5000 has a XML based service that applications can use to poll the device directly."

żDoes TED PRO has a similar service? (besides the 3rd party posting which is very limited for remote monitoring)

For real time monitoring, we have found more powerful polling in TED5000 than posting to 3rd party. We hope to do something similar with TED PRO. żIs there a manual showing the programmable commands for polling directly the TED PRO?

[Kevin]

"The TED5000 has a XML based service that applications can use to poll the device directly."

żDoes TED PRO has a similar service? (besides the 3rd party posting which is very limited for remote monitoring)

For real time monitoring, we have found more powerful polling in TED5000 than posting to 3rd party. We hope to do something similar with TED PRO. żIs there a manual showing the programmable commands for polling directly the TED PRO?

I'm using the public API (see this thread) to grab the latest instantaneous watts from the MTU and Spyders, as XML.

Works well, but in the long run I plan to write my own listener to receive data via the "3rd party posting" mechanism instead.