Display "normal seasonal temperatures" on Belchertown skin

[didier....@gmail.com]

Hi

My site (https://meteo-auffargis.decoodt.eu) is based on the Belchertown skin (Thanks Pat).

I would like to add "normal seasonal temperatures" inside graphics in order to compare the current temperature and "normal" temperature.

For the moment, I have an excel file with 3 columns:

• Day (from 1/1 to 31/12)
• Min
• Max

Have you ever done this? and could you help me 

[Karen K]

I was thinking about that, too, but there were other project, that came first. You could store that Excel file into an SQLITE file and include it in WeeWX configuration. So you can use it in skins. Make sure to have a 'dateTime' and 'interval' column. That is necessary for WeeWX to process the database.

[Didier Decoodt]

In my Excel file the date is "year generic": the values are available only for a day and a month, but for every year (same value the 23/6/2021, 23/6/2022 ...)

In this case how do you write the dateTime?

May be I have to generate data from 1/1/2020 to 1/1/2030?

In MYSQL database, I have not the interval column...

Thanks a lot

--
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 weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/8bf36c7a-4036-498a-b7b2-8d37b0551bf9n%40googlegroups.com.

--

Quel temps fait-il à Auffargis ?

[Karen K]

You need to include the word 'interval' into backticks to access the column of that name. 

[Didier Decoodt]

I have found "interval" (5 mn) in archive table, but not in archive_day_xxxxx tables

In my case I think that I have to create a table like: archive_day_seasonTemp

The problem is that information are generic and not a result at a dateTime, this is a "reference" table

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/74a81576-57a7-4c11-a1bf-fbee1adeb3a4n%40googlegroups.com.

[Karen K]

As I said, I thought about it, but I did not do it so far. So it's all guesses.

Those 'archive_day_somthing' tables are derived tables from the archive table. As I understood the WeeWX architecture you need a table like the 'archive' table. 

In the first place I would try to put all those values into one single year and refer them by the $span tag. 

Another possibility would be to put the values into an config file and provide them in WeeWX by an searchlist extension or XType extension. That requires some lines of Python.