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 <kk4468...@gmail.com> a écrit : > You need to include the word 'interval' into backticks to access the > column of that name. > > didier....@gmail.com 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 <kk44...@gmail.com> 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. >>> >>> didier....@gmail.com 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 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 >>> <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 weewx-user+unsubscr...@googlegroups.com. > 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAAvt3%3DS4XwXP%2BAtxUQJccRFqedf2TfJui6ROomTUA3Q%3DV2LXfg%40mail.gmail.com.