How to read logs with javascript

How to read logs with javascript - Printable Version

+- LogicMachine Forum (https://forum.logicmachine.net)
+-- Forum: LogicMachine eco-system (https://forum.logicmachine.net/forumdisplay.php?fid=1)
+--- Forum: Scripting (https://forum.logicmachine.net/forumdisplay.php?fid=8)
+--- Thread: How to read logs with javascript (/showthread.php?tid=774)

How to read logs with javascript - Mirco - 05.05.2017

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

RE: How to read logs with javascript - Mirco - 09.05.2017

Nobody can help me?? Confused

RE: How to read logs with javascript - buuuudzik - 09.05.2017

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 ;)
  };

RE: How to read logs with javascript - buuuudzik - 09.05.2017

Or maybe better for you would be to prepare all html, js and lua in this .lp file Wink

RE: How to read logs with javascript - Mirco - 16.05.2017

Thank you buuuudzik! Big Grin

RE: How to read logs with javascript - buuuudzik - 16.05.2017

You're welcome and good luck with your project Wink