Excellent. You might want to ask the maintainer of the gw1000 extension to add 'ecolightningcount': 'group_count' so other users won’t hit this problem. 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. 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
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.
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.
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. 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'), 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. 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. 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); 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 correctlyCoulk 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.
--
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.
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.
--
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.
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.
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.
--
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].
--
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].
--
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.
--
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/A2F2D6B0-7DDF-4432-9771-CA5F43B3CB91%40johnkline.com.
|
