Re: [weewx-user] Re: Display "normal seasonal temperatures" on Belchertown skin

2021-06-23 Thread 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.

didier@gmail.com 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_x 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  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  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
  
 
 .

>>>
>>>
>>> -- 
>>> Quel temps fait-il à Auffargis  ?
>>>
>> -- 
>> 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/74a81576-57a7-4c11-a1bf-fbee1adeb3a4n%40googlegroups.com
>>  
>> 
>> .
>>
>
>
> -- 
> Quel temps fait-il à Auffargis  ?
>

-- 
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/b4bee01e-1114-4e49-bbc9-dd9892e86202n%40googlegroups.com.

Re: [weewx-user] Re: Display "normal seasonal temperatures" on Belchertown skin

2021-06-23 Thread Didier Decoodt 
I have found "interval" (5 mn) in archive table, but not in
archive_day_x 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  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  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
>>> 
>>> .
>>>
>>
>>
>> --
>> Quel temps fait-il à Auffargis  ?
>>
> --
> 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
> 
> .
>


-- 
Quel temps fait-il à Auffargis  ?

-- 
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.

Re: [weewx-user] Re: Display "normal seasonal temperatures" on Belchertown skin

2021-06-23 Thread Karen K 
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  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
>>  
>> 
>> .
>>
>
>
> -- 
> Quel temps fait-il à Auffargis  ?
>

-- 
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.

Re: [weewx-user] Re: Display "normal seasonal temperatures" on Belchertown skin

2021-06-23 Thread 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

Le mer. 23 juin 2021 à 17:35, Karen K  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+unsubscr...@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  ?

-- 
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%3DQBfrqsbO8BmZbcPOHzUf29n3RpcAZUY7LA_K-6eFnPkQ%40mail.gmail.com.

[weewx-user] Re: Display "normal seasonal temperatures" on Belchertown skin

2021-06-23 Thread 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@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+unsubscr...@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.