KNX LogicMachine3 Re:actor, Руководство по эксплуатации продукта

Страница: 81 / 160

81
1.4.1. Export logs
Example
Once an hour, make CSV file with all objects logs and send to external FTP server with IP
192.168.1.11, login ‘ftplogin‘, password ‘ftppassword‘.
•
In
Scripting -> Scheduled
add the script which will run once an hour
•
Add the following code in Script editor for this particular script.
1.
require ( 'socket.ftp' )
2.
3. -- ftp file
4. ftpfile
= string.format ( 'ftp://ftplogin:ftppassword@192.168.1.11/%s.csv'
,
os.date ( '%Y-
%m-%d_%H-%M' ))
5. -- get past hour data (3600 seconds)
6. logtime
= os.time ()
-
60 * 60
7.
8.
-- list of objects by id
9. objects
={}
10.
11.
-- objects with logging enabled
12. query = 'SELECT address, datatype, name FROM objects WHERE disablelog=0'
13. for _, object inipairs ( db:getall ( query )) do
14. objects
[ tonumber (
object.address
)]={
15. datatype = tonumber ( object.datatype ) ,
16. name = tostring ( object.name or '' ) ,
17.
}
18.
end
19.
20.
-- csv buffer
21. buffer ={ '"date","address","name","value"' }