Move data from one column to another in the archive table?

[Nate Bargmann]

With the recent troubles with my Davis Vantage ISS I have been looking
through various parts of my setup, both hardware and software. Along
those lines I discovered that when I set up the soil temperature
transmitter eight years and ten days ago, I didn't set it up
specifically as a soil temperature station, consequently, for that
entire time that value has been stored into the extraTemp1 column. I
have adjusted for that error by having a label override in weewx.conf.
Of course, that means that in the various skin.conf files I have to
reference extraTemp1 for the presented soil temp values.

Would there be any advantage to configuring the console correctly with
wee_device and moving the present data to the soilTemp1 column?

I'll admit to being somewhat of a pedant and knowing this sort of error
exists in my archive data does bug me a bit. :-D

- Nate

--
"The optimist proclaims that we live in the best of all
possible worlds. The pessimist fears this is true."
Web: https://www.n0nb.us
Projects: https://github.com/N0NB
GPG fingerprint: 82D6 4F6B 0E67 CD41 F689 BBA6 FB2C 5130 D55A 8819

[Nate Bargmann]

Before I made any changes to the database, I tried changing the channel
2 transmitter from being shown as "temp" to something like "soil temp"
or some such. It seems as though no permutation I used with wee_device
even as simple as:

wee_device /etc/weewx/weewx.conf --set-transmitter-type=2,7

gave me any temperature value from that sensor in the LOOP packets.
Even the console no longer displayed the temperature. I've gone back to
having the console report the value as extraTemp1.

I'm puzzled because the documentation at:

http://weewx.com/docs/hardware.htm#vantage_data

hints that soilTemp1 should be a hardware value. How do I get that?
Or, does that come from other receiving hardware such as the Envoy?

[Tom Keffer]

Personally, I would make the change, but I can certainly understand leaving it well enough alone.

To make it easy on yourself, you could use wee_database to drop column soilMoist1, then use it again to rename extraTemp1 to soilMoist1. Then use wee_device to change to the correct configuration. 

That way, you save your old data without having to offload anything. 

Make a backup first!

-tk

--
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/20231125152829.moumqapw534yum64%40n0nb.us.

[Tom Keffer]

If you have the necessary hardware, your VP2 should be able to emit the soil measurements.

The Vantage configuration utility has had some issues. The version to be included with V5 is much better. Fortunately, the new driver is compatible with V4, so all you have to do is replace the old one with the new one. You can find it here.

If that doesn't work any better, we'll take a second look.

--
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/20231125191246.kq6c6zt56gb6t6bj%40n0nb.us.

[Nate Bargmann]

* On 2023 29 Nov 18:29 -0600, Tom Keffer wrote:
> If you have the necessary hardware, your VP2 should be able to emit the
> soil measurements.

I think that is the problem. After rereading, carefully, the manual of
the Wireless Leaf & Soil Moisture/Temperature Station I've reached the
conclusion that its reporting of temperature as "soil temperature"
requires a companion soil moisture probe which I do not have. I only
have a temp probe so the VP2 console must be set for that transmitter to
be a "temp" station and nothing more. That results in the reading being
shown as "Temp 2" on the console.

> The Vantage configuration utility has had some issues. The version to be
> included with V5 is much better. Fortunately, the new driver is compatible
> with V4, so all you have to do is replace the old one with the new one. You
> can find it here

> <https://raw.githubusercontent.com/weewx/weewx/V5/src/weewx/drivers/vantage.py>
> .

>
> If that doesn't work any better, we'll take a second look.

I had tried setting that station to "soil" directly in the console setup
and received no temperature reading in the LOOP packets. Only by
setting it as "temp" did any second temperature reading appear. I don't
have leaf wetness or soil moisture sensors nor do I plan to add them so
all is good on my end now that I understand things unique to my station.
I use a label assignment to make sure the value is displayed as Soil
Temperature on the generated reports.

Thanks for a fine piece of software that keeps me learning. :-D