i was using gw1000.py and Ive added  'ecolightningcount': 'group_count' to 
the file.
It now formats correctly without decimal points so thanks for your pointers

Phil

On Friday, June 12, 2026 at 5:30:26 PM UTC+1 John Kline wrote:

> You are showing me LoopDataReport, but not LoopData.  Is this report the 
> target report in the LoopData section.
>
> In any event, if the loop data report is the target report in the LoopData 
> section, my guess is that you haven’t properly defined the 
> ecolightningcount type.  Is this something you did on your own, or is it 
> from an extension that I can look at?  The type needs to be associated with 
> group_count in weewx.units.obs_group_dict.
>
> In any event, you might get this working the wrong way by removing the 
> “current.“ in LoopDataReport so that it reads:
>
> ecolightningcount = %.0f
>
> I say the wrong way because you really want ecolightningcount to be a 
> properly defined observation so you don’t keep hitting these problems.
>
> On Jun 12, 2026, at 8:53 AM, [email protected] <[email protected]> 
> wrote:
>
> John K
>
> This is whats in the weewx.conf
>  [[LoopDataReport]]
>         HTML_ROOT = /etc/weewx/webpages/loopdata
>         enable = true
>         skin = LoopData
>         [[[Extras]]]
>             loop_data_file = loop-data.txt
>             expiration_time = 4
>             page_update_pwd = foobar
>             googleAnalyticsId = ""
>             analytics_host = ""
>         [[[Units]]]
>             [[[[StringFormats]]]]
>                 mile_per_hour = %.0f
>                 degree_C = %.1f
>                 km_per_hour = %.0f
>                 degree_F = %.1f
> current.ecolightningcount = %.0f
>
> txt file attached and the link to view is
> Sher Center <https://sheringhamweathercenter.uk/loopdata/index.html>
>
>
> On Friday, June 12, 2026 at 2:38:26 PM UTC+1 John Kline wrote:
>
>> We are talking about the formatters associated with the observation.  It 
>> *may* be true that, if the observation was set up incorrectly, the database 
>> type would have an effect on the output, but the goal here is to properly 
>> create the new type.  This is why I have asked the OP to tell me what is 
>> displayed in the report.  That takes the extension out of the picture and 
>> we can work to get the observation configured correctly.  The loopdata 
>> extension, by design, uses the same formatters as the target report.
>>
>> On Jun 12, 2026, at 4:32 AM, Pablo Sanchez <[email protected]> 
>> wrote:
>>
>>  
>>
>> It is a database issue because the column's domain should be an integer. 
>> Any other data type allows for garbage data to exist.
>>
>> By design, many DB engines reject data that does not match the domain.
>> ---
>> pablo
>>
>> On June 12, 2026 00:32:08 John Smith <[email protected]> wrote:
>>
>>> This is fundamentally a formatting issue. 
>>>
>>>
>>> It might manifest as a formatting issue, but it's really a database 
>>> issue and a waste of bytes storing whole numbers as decimals.
>>>
>>> I do know that the extended schema has lighthing count as REAL.
>>>
>>>
>>> The defaults are unnecessarily bloated, but I guarantee others on this 
>>> list don't want the issue rehashed yet again.
>>>
>>> On Fri, 12 Jun 2026 at 11:46, 'John Kline' via weewx-user <
>>> [email protected]> wrote:
>>>
>>>> This is fundamentally a formatting issue.  I have this completely 
>>>> covered in the extension.
>>>>
>>>> I don’t know how well weewx will play with observations that are 
>>>> integers (but, like I say, this is about formatting).  I do know that the 
>>>> extended schema has lighthing count as REAL.
>>>>
>>>> ('lightning_strike_count',    'REAL'),
>>>>
>>>> On Jun 11, 2026, at 6:01 PM, John Smith <[email protected]> wrote:
>>>>
>>>> 
>>>> Why would a column for lightning strikes not use INTEGER in the first 
>>>> place?
>>>>
>>>> It's not like you can have a half or third of a lightning strike.
>>>>
>>>> On Fri, 12 Jun 2026 at 09:35, 'John Kline' via weewx-user <
>>>> [email protected]> wrote:
>>>>
>>>>> Please don’t change the database.  loopdata formats observations as 
>>>>> specified by a report.  The reason for this is, typically, the 
>>>>> observation 
>>>>> values written on every loop record are used to update values in a 
>>>>> report.  
>>>>> Of course, just like when observations are used in a report, adding .raw 
>>>>> will skip the formatting.
>>>>>
>>>>> On Jun 11, 2026, at 3:01 PM, John Smith <[email protected]> wrote:
>>>>>
>>>>> 
>>>>> The simplest fix would be to remove the column and then re-add it with 
>>>>> the INTEGER type instead of REAL.
>>>>>
>>>>> The slightly more complex fix would be to update the column type in 
>>>>> your database by doing something like
>>>>>
>>>>> ALTER TABLE my_table ADD COLUMN new_col INTEGER;
>>>>> UPDATE my_table SET new_col = CAST(old_col AS INTEGER);
>>>>> ALTER TABLE my_table DROP COLUMN old_col;
>>>>> ALTER TABLE my_table RENAME COLUMN new_col TO old_col;
>>>>>
>>>>> Although Claude.ai says SQLite columns are dynamically typed, so you 
>>>>> could get away with just doing
>>>>>
>>>>> UPDATE my_table SET col = CAST(col AS INTEGER);
>>>>>
>>>>> On Fri, 12 Jun 2026 at 01:00, [email protected] <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> weewx version 5.3.1
>>>>>> Ive added current.ecolightningcount to the weewx-loopdata ver 3.3.2 
>>>>>> program and it updates OK but it displays 6 decimal places. Ive added 
>>>>>> various things in weewx.conf but obviously not correctly
>>>>>> Coulk somebody put me out of my misery and point me in the right 
>>>>>> direction.
>>>>>>
>>>>>> Thanks Phil
>>>>>>
>>>>>> -- 
>>>>>> 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 visit 
>>>>>> https://groups.google.com/d/msgid/weewx-user/32453638-58fc-4a1b-bf38-85e6bcff50den%40googlegroups.com
>>>>>>  
>>>>>> <https://groups.google.com/d/msgid/weewx-user/32453638-58fc-4a1b-bf38-85e6bcff50den%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>>>> .
>>>>>>
>>>>> -- 
>>>>> 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 visit 
>>>>> https://groups.google.com/d/msgid/weewx-user/CAGTinV4d%2Bh78RC82nEbAr2owQEbG3r%2Be3zwS8KPJ_rcYaHYXJQ%40mail.gmail.com
>>>>>  
>>>>> <https://groups.google.com/d/msgid/weewx-user/CAGTinV4d%2Bh78RC82nEbAr2owQEbG3r%2Be3zwS8KPJ_rcYaHYXJQ%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>>> .
>>>>>
>>>>> -- 
>>>>> 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 visit 
>>>>> https://groups.google.com/d/msgid/weewx-user/D2738456-68BF-4254-984B-386411A99E8F%40johnkline.com
>>>>>  
>>>>> <https://groups.google.com/d/msgid/weewx-user/D2738456-68BF-4254-984B-386411A99E8F%40johnkline.com?utm_medium=email&utm_source=footer>
>>>>> .
>>>>>
>>>> -- 
>>>> 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 visit 
>>>> https://groups.google.com/d/msgid/weewx-user/CAGTinV51OVgF_%2BFgsPVLbLcUQXyiqvKnfBkaTdFtgE%3DRBvnrkw%40mail.gmail.com
>>>>  
>>>> <https://groups.google.com/d/msgid/weewx-user/CAGTinV51OVgF_%2BFgsPVLbLcUQXyiqvKnfBkaTdFtgE%3DRBvnrkw%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>>> -- 
>>>> 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 visit 
>>>> https://groups.google.com/d/msgid/weewx-user/FF04048C-0414-465C-84E2-543015C11210%40johnkline.com
>>>>  
>>>> <https://groups.google.com/d/msgid/weewx-user/FF04048C-0414-465C-84E2-543015C11210%40johnkline.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> -- 
>>> 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 visit 
>>> https://groups.google.com/d/msgid/weewx-user/CAGTinV7QPznu5xEQRWNS8q84nrNk9Gf_2uL2m9Do%2BDB1nboGkQ%40mail.gmail.com
>>>  
>>> <https://groups.google.com/d/msgid/weewx-user/CAGTinV7QPznu5xEQRWNS8q84nrNk9Gf_2uL2m9Do%2BDB1nboGkQ%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>>
>> -- 
>> 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 visit 
>> https://groups.google.com/d/msgid/weewx-user/19ebb9ab9a0.2848.44b74f35a7a433c111dbfaee4cca1c2d%40hillsandlakes.com
>>  
>> <https://groups.google.com/d/msgid/weewx-user/19ebb9ab9a0.2848.44b74f35a7a433c111dbfaee4cca1c2d%40hillsandlakes.com?utm_medium=email&utm_source=footer>
>> .
>>
>> -- 
> 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 visit 
> https://groups.google.com/d/msgid/weewx-user/5b0fd6f7-3463-47c7-9ff3-8c5b4bfd3b0fn%40googlegroups.com
>  
> <https://groups.google.com/d/msgid/weewx-user/5b0fd6f7-3463-47c7-9ff3-8c5b4bfd3b0fn%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
> <loop-data.txt>
>
>

-- 
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 visit 
https://groups.google.com/d/msgid/weewx-user/e86cddec-d702-4723-9b4c-ab424ef8b0c4n%40googlegroups.com.

Reply via email to