Logic Machine objects to file for ETS Import

[Daniel]

You can use this script. It will save csv in to ftp main folder

Code:

12345678910111213141516171819202122232425262728293031323334

-- Get all objects from DB objects_table = db:getall('SELECT * FROM objects ORDER BY address ASC') log(objects_table) buffer = {} mainvalue = -1 middlevalue = -1 subvalue = -1 -- Loop through objects_table for _, object in ipairs(objects_table) do   address = knxlib.decodega(object.address)   addresstable = string.split(address, '/')   if mainvalue ~= addresstable[1] then      mainvalue = addresstable[1]        table.insert(buffer, '"Main Group ' .. addresstable[1] .. '","","","' .. addresstable[1] .. '/-/-"')   end   if middlevalue ~= addresstable[2] then      middlevalue = addresstable[2]      table.insert(buffer, '"","Middle Group ' .. addresstable[2] .. '","","' .. addresstable[1] .. '/' .. addresstable[2] .. '/-"')   end   if subvalue ~= addresstable[3] then      subvalue = addresstable[3]      table.insert(buffer, '"","","' .. object.name .. '","' .. addresstable[1] .. '/' .. addresstable[2] .. '/' .. addresstable[3] .. '"')   end end --Create attachment inside FTP server src = 'Object export created on ' .. os.date('%Y-%m-%d %H_%M_%S') .. '.csv' dst = '/home/ftp/' .. src io.writefile(dst, buffer) script.disable(_SCRIPTNAME)