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. [email protected] schrieb am Mittwoch, 23. Juni 2021 um 18:59:19 UTC+2: > 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 > > Le mer. 23 juin 2021 à 18:49, Karen K <[email protected]> a écrit : > >> You need to include the word 'interval' into backticks to access the >> column of that name. >> >> [email protected] schrieb am Mittwoch, 23. Juni 2021 um 18:23:15 >> UTC+2: >> >>> 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 >>> >>> Le mer. 23 juin 2021 à 17:35, Karen K <[email protected]> a écrit : >>> >>>> 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. >>>> >>>> [email protected] schrieb am Mittwoch, 23. Juni 2021 um 17:25:59 >>>> UTC+2: >>>> >>>>> 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 >>>>> >>>> -- >>>> 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]. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/weewx-user/8bf36c7a-4036-498a-b7b2-8d37b0551bf9n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/8bf36c7a-4036-498a-b7b2-8d37b0551bf9n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> >>> >>> -- >>> Quel temps fait-il à Auffargis <https://meteo-auffargis.decoodt.eu> ? >>> >> -- >> 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]. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/74a81576-57a7-4c11-a1bf-fbee1adeb3a4n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/74a81576-57a7-4c11-a1bf-fbee1adeb3a4n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > > > -- > Quel temps fait-il à Auffargis <https://meteo-auffargis.decoodt.eu> ? > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/b4bee01e-1114-4e49-bbc9-dd9892e86202n%40googlegroups.com.
