This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

How to read logs with javascript
#1
Hi guys,

I would like to read from logs: data, time, group address and value.
I want to use an iFrame with an HTML page that display those datas as the customer wants Wink

Thanks
Reply
#2
Nobody can help me?? Confused
Reply
#3
You should prepare .lp file in/user/ location(e.g. logs.lp) and inside you must prepare in lua such script:
Code:
<?

-- How much objects do you need?
objects_number = 10

query = "SELECT ol.logtime, o.name, ol.datahex, o.datatype, ol.eventtype FROM objectlog AS ol, objects AS o WHERE ol.address=o.address AND ol.eventtype IN ('write', 'response') ORDER BY ol.logtime DESC LIMIT " .. objects_number
result = db:getall(query)

logs = {}

for _,row in ipairs(result) do  
    logs[_] = {logtime = os.date('%Y.%m.%d %H:%M:%S', row.logtime), name = row.name, value = knxdatatype.decode(row.datahex, row.datatype)}
end

logs = json.encode(logs)
print(logs)

?>

And when you will have this file you can use it in js by:
Code:
$.get( "/user/logs.lp", function( data ) {
   res = data.trim();
   res = JSON.parse(res);
// further operating with data in javascript ;)
 };
Reply
#4
Or maybe better for you would be to prepare all html, js and lua in this .lp file Wink
Reply
#5
Thank you buuuudzik! Big Grin
Reply
#6
You're welcome and good luck with your projectWink
Reply


Forum Jump: