Exporting Trends 1 minute data in HL?

[Koen_Rowies]

Hello,

Is there a possibility to export the 1 minute data used for the trending. You can export a .CSV but this this is only the "hour" data.

Kind regards

[sesa299442]

Trend data are stored in rrd file. It containes minute data for 1 last hour only.

I have only tried to copy this rrd file and then convert it to xls. I can see this data there.

We do not have script for direct export of minute data to csv for now.

Be aware that the reading is done once per minute only. So if the value alternates, the minute data may give not exact view of the variable.

Hour data is done by average of these 1 minute data.

Best Regards

Tomas

[esteve_budia]

It can be usefull this script to save to txt file on ftp..

file paket 1 month..

This is what I use..

If you put in a resident script 1 minute ..

-- this script generates 1 file per month called.. /home/ftp/registros/2015-04-registros.txt

os.execute('mkdir -p /lib/genohm-scada/mnt/iNt')

os.execute('mkdir -p /home/ftp/registros')

os.execute('mkdir -p /lib/genohm-scada/mnt/iNt/registros')

mnt=io.readproc('df -h 2>/dev/null'):match('/home/ftp')

  if mnt then

  else

    os.execute('mount /lib/genohm-scada/mnt/iNt /home/ftp')

  end

Ph=(grp.getvalue('0/4/24'))

hT=(grp.getvalue('1/0/5'))

taext=(grp.getvalue('0/4/0'))

fitxer=string.format('/home/ftp/registros/%s-%s-registros.txt',os.date('%Y'),os.date('%m'))

dato = string.format('Fecha, %s, kWh Termo=, %s, horas Termo=, %s,Ta Exterior=, %s,Humedad=,%s',os.date('%c'),Ph,hT,taext,humedad )

log ('Nom fitxer:' .. fitxer .. '  Datos:' ..  dato )

file=io.open(fitxer, 'a+')

file:write(dato .. '\r\n')

file:close()

--log..

--string: Nom fitxer:/home/ftp/registros/2015-04-registros.txt  Datos:Fecha, Fri Apr 10 13:21:56 2015, kWh Termo=, 3.84, horas Termo=, 481.92,Ta Exterior=, 24.2,Humedad=,nil

just FYI ..

ftp://ftp:password@192.168.3.69/registros/

Index of /registros/

Name Size Date Modified

[parent directory]

2014-09-registros.txt 213 kB 9/30/14, 12:00:00 AM

2014-10-registros.txt 222 kB 10/10/14, 12:00:00 AM

2015-04-registros.txt 1.6 kB 4/10/15, 11:31:00 AM

Fecha, Fri Apr 10 13:17:49 2015, kWh Termo=, true, horas Termo=, false,Ta Exterior=, nil,Humedad=,nil

Fecha, Fri Apr 10 13:18:50 2015, kWh Termo=, true, horas Termo=, false,Ta Exterior=, nil,Humedad=,nil

Fecha, Fri Apr 10 13:19:10 2015, kWh Termo=, true, horas Termo=, false,Ta Exterior=, nil,Humedad=,nil

Fecha, Fri Apr 10 13:20:10 2015, kWh Termo=, true, horas Termo=, false,Ta Exterior=, nil,Humedad=,nil

Fecha, Fri Apr 10 13:21:10 2015, kWh Termo=, true, horas Termo=, false,Ta Exterior=, nil,Humedad=,nil

Fecha, Fri Apr 10 13:21:56 2015, kWh Termo=, 3.84, horas Termo=, 481.92,Ta Exterior=, 24.2,Humedad=,nil

Fecha, Fri Apr 10 13:22:56 2015, kWh Termo=, 3.84, horas Termo=, 481.92,Ta Exterior=, 24.2,Humedad=,nil

Fecha, Fri Apr 10 13:23:57 2015, kWh Termo=, 3.84, horas Termo=, 485.12,Ta Exterior=, 24.2,Humedad=,nil

Fecha, Fri Apr 10 13:24:57 2015, kWh Termo=, 3.84, horas Termo=, 485.12,Ta Exterior=, 24.2,Humedad=,nil

Fecha, Fri Apr 10 13:25:57 2015, kWh Termo=, 3.84, horas Termo=, 485.12,Ta Exterior=, 24.2,Humedad=,nil

Fecha, Fri Apr 10 13:26:57 2015, kWh Termo=, 3.84, horas Termo=, 485.12,Ta Exterior=, 24.2,Humedad=,nil

Fecha, Fri Apr 10 13:27:57 2015, kWh Termo=, 3.84, horas Termo=, 485.12,Ta Exterior=, 24.2,Humedad=,nil

Fecha, Fri Apr 10 13:28:57 2015, kWh Termo=, 3.84, horas Termo=, 479.04,Ta Exterior=, 24.2,Humedad=,nil

Fecha, Fri Apr 10 13:29:57 2015, kWh Termo=, 3.84, horas Termo=, 479.04,Ta Exterior=, 24.3,Humedad=,nil

Fecha, Fri Apr 10 13:30:58 2015, kWh Termo=, 3.84, horas Termo=, 479.04,Ta Exterior=, 24.3,Humedad=,nil

Fecha, Fri Apr 10 13:31:58 2015, kWh Termo=, 3.84, horas Termo=, 479.04,Ta Exterior=, 24.3,Humedad=,nil

Fecha, Fri Apr 10 13:32:58 2015, kWh Termo=, 3.84, horas Termo=, 479.04,Ta Exterior=, 24.3,Humedad=,nil

[Koen_Rowies]

Hello Esteve,

Thanks for the script, I will test this.

Kind regrads