is it possible to upload to pvoutput.org

Have you run this script manually, ie lua <scriptname>

Can you post the output, I sometimes get an error with the module command on the first line, you could try commenting that out, but without actually seeing the error it will be difficult to say what's wrong.

Karl

Well calling self:delete() in the post function means that the timer will only fire after 60 seconds and then delete itself?  I'm sure this is not what you intended.

Later instead of using CURL and an OS callout you might want to check out http://w3.impa.br/~diego/software/luasocket/http.html which is built in.

Declare watt as a variable in the module before you start using it in the init() function, like you do the apikey and url ->  watt=0  would be fine otherwise if the post function is executed before a callback of data has arrived you'll get an error in the POST function accessing a variable before its declared.

Also try running this as a standalone program its easier then firing up plugboard for each session, you'll need a few additional lines of code.  Note for this are on the wiki and are pretty easy to follow.

Brett

To be automatically loaded they must be placed in the /etc/plugboard directory and have the prefix Applet.lua.

As documented here -> http://www.dbzoo.com/livebox/hah_plugboard_v2#writing_an_applet

Rename this file to PVoutputApplet.lua

Also you are missing the import statement

require("xap")

Which is REALLY important.

Brett

I've moved some lines around, just to make reading the code a little easier, functions at the start and some indents.  I've tried this and it works.  However, I haven't finished it for you.  Brett will most definately not like it, Brett??, but it's a start.  See how you get on, look at what I've done and compare it with yours, you've done a great job so far and you'll pick up a lot more by looking at example and finding out where you've gone wrong.

Keep it it, it's really good to get another person on-board to bounce ideas off, it all helps with the development of the project.

Karl

require ('xap')
require('xap.bsc')
local io = require("io")
local http = require("socket.http")
local ltn12 = require("ltn12")

watts="240"
elapsed = 0
Api = "2c8cd623b1........cut..............70ee538540"
Feed = "29xx"

url='://pvoutput.org/service/r2/addstatus.jsp?key='


function post(self)
    elapsed = elapsed + self.interval
     -- print("http" ..url ..Api .. "&sid="..Feed .. "&d=" ..os.date("%Y%m%d") .. "&t=" ..os.date("%H:%M") .. "&v1=" ..watts)
    b, c, h = http.request("http" ..url ..Api .. "&sid="..Feed .. "&d=" ..os.date("%Y%m%d") .. "&t=" ..os.date("%H:%M") .. "&v1=" ..watts)
    if elapsed > 1 then
        self:delete()
    end
end


function GetCurrentReading(frame)
    local watts = xap.getValue("input.state","text")
    print(string.format("watts = %s", tostring(watts)))
end


function init()
    print("System Starting")
    f = xap.Filter()
    f:add("xap-header", "source", "dbzoo.livebox.CurrentCost:ch.1")
    f:callback(GetCurrentReading)
end



xap.init("dbzoo.lua.PVtest","FF00DD00" )
init()
xap.process()
--xap.Timer(post, 2):start()

Hi,

not sure if this is what you are talking about or not but I have a script that tots up the total energy usage in 5 minutes intervals then add this 5 min total to a file located on the HAH to give a running cumulative total (the benefit of this is that rebooting the HAH only looses a max of 5min data).

I post this to pachube but you could post elsewhere as per your script. I reset this cumulatvie total by zeroing the file at midnight to give me a daily power usage but again you could reset it via a timer as often as you like.

I am sure my script is not written brilliantly but it works and may give you some ideas.

For info it works as follows:

The powerlog function populates the CurrentKwH variabe with the usage in kwH since the last value reported by current cost, then adds this to the TempCumulativeKwH variable held in memory. The power variable then gets updated with the most recent instantaneos value for to use during the next period.

every five minutes the PowerSave function is loaded which opens the /etc/plugboard/CumulativeKwH file and adds the TempCumulativeKwH value from memory to it and then overwrites the file. it then resets the timer and posts via pachube using the CumualtiveDataPost function (this is where you would post to PVoutput, etc)

Note: you may have to initially manually add the log file (/etc/plugboard/CumulativeKwH) to the HAH as I dont think the script will automatically make it.

Script is here:

-- collect cumulative power data and log to pachube

module(...,package.seeall)

require("xap")
require("string")

info={
   version="1.0", description="Cumulative Electric Script"
}

local Power = 1
local Logtime = os.time()
local TempCumulativeKwH = 0
CumulativeKwH = 0
local CurrentKwH = 0


function powersave(self)
    local file = io.open("/etc/plugboard/CumulativeKwH","r")
    CumulativeKwH = file:read("*all")
    file:close()
    CumulativeKwH = tonumber(CumulativeKwH) + TempCumulativeKwH
    TempCumulativeKwH = 0
    local cmd = string.format("echo '%s'>/etc/plugboard/CumulativeKwH", CumulativeKwH)
    os.execute(cmd)
    self:reset()
    CumulativeDataPost()
end

function powerlog()
    local CurrentPeriod = os.difftime(os.time(), Logtime)
    Logtime = os.time()   
    local CurrentKwH = Power * CurrentPeriod / 3600000
    TempCumulativeKwH = TempCumulativeKwH + CurrentKwH
    Power = xap.getValue("input.state","text")
   
end

function CumulativeDataPost()
    CumulativeData = string.format([[xap-header
{
class=pachube.update
target=dbzoo.livebox.pachube
}
datastream
{
id=10
tag=Electric KwH
Value=%s
}]], CumulativeKwH)

xap.sendShort(CumulativeData)
end

function init()
      local f = xap.Filter()
      f:add("xap-header","source","dbzoo.livebox.CurrentCost:ch.1")
      f:add("xap-header","class","xAPBSC.event")
    f:callback(powerlog)

xap.Timer(powersave, 300):start()

end

All you need to do extra is to reset the file to zero as and when you require. I do this by scripting the following at midnight but it could be done with a standard timer function

local cmd = string.format("echo '0'>/etc/plugboard/CumulativeKwH")
            os.execute(cmd)

Hope its of some use

Garry

In the spirit of not reinventing the wheel I think that your code could be the basis for a PVoutput plugboard app. I have a look in the next couple of days and see what can be done.

OK I think I have a working script for posting live data to PVoutput.org direct from the HAH livebox using the CurrentCost data. Many thanks to Garry (garrydwilms) who will no doubt recognise some of his code in the attached script.

Currently it is formatted as a standalone script while I do some testing but it should be easy enough to convert to a plugboard applet. I'd be interested to hear from anyone who cares to test it out.

It will need some modifications because of the way that the CC meter overreads PV output but that can be dealt with later.

I'm sure that there is a way of attaching the script as a file, but da**ed if I can find it. So here it is longhand:

***************************************************************************

require ('xap')
require('xap.bsc')
require("string")
local io = require("io")
local http = require("socket.http")
local ltn12 = require("ltn12")


CurrentTemp = 0
Logtime = os.time()
TempCumulativeKwH = 0
CumulativeKwH = 0
CurrentKwH = 0
watts = 0
elapsed = 0
ConvFactor = 0.95
Api = "2c8c----cut-----ee538540" -- put your PVoutput api key here
Feed = "29XX" -- put your PVoutput feed ID here
Postinterval = 5 -- The number of minutes between posts to PVoutput
url='://pvoutput.org/service/r2/addstatus.jsp?key='
Power = 1


function post(self)
local ckwh = math.floor(CumulativeKwH *1000 )
if CumulativeKwH ~= 0 then
b, c, h = http.request("http" ..url ..Api .. "&sid="..Feed .. "&d=" ..os.date("%Y%m%d") .. "&t=" ..os.date("%H:%M") ..

"&v1=" ..ckwh.. "&v2=" ..Power .."&v5=" ..CurrentTemp)
end
end

function powersave(self)
local file = io.open("/etc/plugboard/CumulativeKwH","r")
CumulativeKwH = file:read("*all")
file:close()
CumulativeKwH = tonumber(CumulativeKwH) + TempCumulativeKwH
TempCumulativeKwH = 0
local cmd = string.format("echo '%s'>/etc/plugboard/CumulativeKwH", CumulativeKwH)
os.execute(cmd)
self:reset()
post()
end

function GetTemp(frame)
CurrentTemp = frame:getValue("input.state","text")
end


function powerlog(frame)
local CurrentPeriod = os.difftime(os.time(), Logtime)
Logtime = os.time()
local CurrentKwH = Power * CurrentPeriod / 3600000
TempCumulativeKwH = TempCumulativeKwH + CurrentKwH
Power = frame:getValue("input.state","text")
if tonumber(Power) < 45 then
Power = 0
end

end



function init()
local f = xap.Filter()
f:add("xap-header", "source", "dbzoo.livebox.CurrentCost:ch.1")
f:add("xap-header","class","xAPBSC.event")
f:callback(powerlog)
local f = xap.Filter()
f:add("xap-header", "source", "dbzoo.livebox.CurrentCost:temp")
f:add("xap-header","class","xAPBSC.event")
f:callback(GetTemp)
end




xap.init("dbzoo.lua.PVtest","FF00DD00" )
init()
xap.Timer(powersave, Postinterval*60):start()
xap.process()

****************************************************************************