(20.11.2020, 06:57)admin Wrote: You can use .lp file to generate a CSV that will be sent to the user.
First you need to attach an event to a button that will open .lp in a new window:

Code:

$(function() {
  // additional class must be set to csv
  $('.csv').on('vclick', function() {
    window.open('/user/csv.lp');
  });
});

Use this as a starting point for csv.lp:

Code:

<?
-- set headers for csv file download
setdlheader('text/csv; charset=utf-8', 'report', 'csv')
-- generate csv here
csv = '...'
-- output to the user
print(csv)

(24.11.2020, 07:34)admin Wrote: .lp file is not a script, it's a Lua file that only the web server can run. It should be uploaded via FTP to the user directory using apps username. If the file is named csv.lp then the URL will be http://LM_IP/user/csv.lp

(24.11.2020, 09:16)admin Wrote: Try this:

Code:

<?
require('apps')
-- set headers for csv file download
setdlheader('text/csv; charset=utf-8', 'Consumption', 'csv')
-- generate csv here
value=grp.tag("consumption")

a={}

for index, id in ipairs(value) do
  name=id["name"]
  meter=id["data"]
  consumption=name .."," .. meter
  a[index]=consumi
end

print(a)

(24.11.2020, 09:56)admin Wrote: There were some errors in the script, this should work:

Code:

<?
require('apps')
setdlheader('text/csv; charset=utf-8', 'Consumption', 'csv')

csv = {}
objects = grp.tag('consumption')

for _, obj in ipairs(objects) do
  csv[ #csv + 1 ] = obj.name .. ',' .. tostring(obj.value)
end

print(table.concat(csv, '\n'))

(24.11.2020, 10:33)admin Wrote: dot is a special symbol that is treated as "any character" by the gsub. You need to escape it like this:

Code:

value = string.gsub(tostring(obj.value), "%.", ",")
csv[ #csv + 1 ] = obj.name .. ';' .. value

Since you are using comma as a decimal separator you should use ; instead of comma as csv field separator.