The Energy Detective Forums
May 27, 2018, 08:26:46 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: New TED Support forum launched!!
 
   Home   Help Search Login Register  
Pages: 1 [2]
  Print  
Author Topic: Posting to a 3rd party server
phuz
Newbie
*
Posts: 16


« Reply #15 on: September 23, 2013, 04:56:52 PM »

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?
Logged
ThermoMan
Newbie
*
Posts: 7


« Reply #16 on: October 09, 2013, 12:58:06 AM »

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.
Logged
jimmerto
Newbie
*
Posts: 1


« Reply #17 on: November 15, 2013, 11:16:54 PM »

"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?
Logged
Kevin
Newbie
*
Posts: 23


« Reply #18 on: March 11, 2018, 06:20:03 PM »

"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.
Logged

Gateway Version 1.0.499, Daughterboard Version 1.0.0, Footprints Version 1.0.281, MTU Version 1.0.61
Pages: 1 [2]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.16 | SMF © 2011, Simple Machines Valid XHTML 1.0! Valid CSS!