Il giorno martedì 15 novembre 2016 17:11:46 UTC+1, Andrew Milner ha scritto: > > Sounds as though you just want an sql select script rather than a report! > Reports are intended to summarise the detail, not provide it. How often do > you want the json file creating - or do you want it created every archive > interval? Does the json file have to provide just a list of outTemp values > or does it also contain date, time as well as outTemp? > > > > On Tuesday, 15 November 2016 18:01:25 UTC+2, Pier Francesco Costa wrote: > >> Hi, >> I am coming back with some question about how to generate a report with >> cheetah. >> >> I'd like to generate a Json file containing every outTemp value over the >> last 24 hours. >> >> I have already read the documentation and wrote a report that generate a >> Json. >> I get the outTemp.avg using the .hours iterator. >> >> The problem I have is that I'd like to iterate not every hour but every >> single archive record, because I am using an archive interval of 5 minutes. >> >> How could I do that? >> > Hi, maybe you're right, I though that I could use the report generator because I am not so skilled with python and database access. Also the database is stored in US units and I want to use metric ones, so I would either need to convert units on the fly or changing unit system inside the database. The Json file should also have a list of times, one for each values.
So after Tom answer I think I have two option... creating a SLE or writing a python script that runs as a chron job directly accessing the database, am I right? -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
